Project & Task Management

Automate Follow-up Task Creation from Emails

Review emails received in the last 24 hours in my Gmail inbox with the label '[Follow-up Required Label]' or containing keywords like '[Action Keyword 1, e.g., please respond]', '[Action Keyword 2, e.g., next steps]'. For each identified email, summarize the required follow-up action and note the sender's email and the email subject. Add this as a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', with columns 'Task Description', 'Sender Email', 'Email Subject', and 'Status' (default to 'Pending').

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