Data Analysis and Report Generation

Track Daily Reports from Email in Google Sheet

Search my Gmail for the latest email with the subject '[Report Subject Line, e.g., Daily Sales Summary]' from '[Sender Email Address]'. From this email, extract the following data points: '[Data Point 1 Name, e.g., Total Revenue]', '[Data Point 2 Name, e.g., New Customers]', and '[Data Point 3 Name, e.g., Conversion Rate]'. Record these data points, along with the current date, as a new row in the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with corresponding columns.

Copy this command

Go to templates

Other Relevant Templates

Clean Inbox

Check all the emails received in the last 24 hours and move the newsletters and spammy emails to the bin.

Gmail

View Template

Summarize Billing Emails

Summarize unread emails from today that mention “invoice,” “payment,” or “contract. and send it to my accountant at maria@assista.us.

Gmail

View Template

Log X Post Performance

Get my posts from the last 7 days. For each, look up its details to find the like and repost count. Add the post text, like count, and repost count to a new row in my Google Sheet at '[Sheet Link]'.

Google Sheets

View Template

Track Competitor Posts in Google Sheet

Get the posts from the latest 7 days from the X user '[@CompetitorHandle]'. For each post, add a new row to the Google Sheet at '[Google Sheet Link]', sheet '[Sheet Name]', with the post text, link, and timestamp.

Google Sheets

View Template

Schedule X Posts from Google Sheet

Check the Google Sheet at '[Google Sheet Link]', sheet name '[Sheet Name]'. For any row where 'Status' is 'Ready', create a post on X using the text from the 'Post Copy' column. Update 'Status' to 'Posted'.

Google Sheets

View Template