Summarize Billing Emails

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

Run a search on X for posts containing '[Brand Name]' from the last 24 hours. For each post, extract the author, text, and link. Send this information via email to [Email Addresses].

From '[Google Sheet Link]', sheet '[Attendees Sheet Name]', identify attendees for events in the next 24 hours. For each, send a Gmail reminder to 'Email Address'. Subject: 'Reminder: Your Upcoming Event - [Event Name]'. Body: '[Event Date]', '[Event Time]', '[Meeting Link]'. Update 'Reminder Sent' to 'Yes'.

From '[Google Sheet Link]', sheet '[FAQ Sheet Name]', match 'Keyword' to new Gmails (last 24 hours) labeled 'Customer Inquiry'. If matched, send a personalized Gmail reply using the 'Response Template'. If no match, forward the email to '[Support Team Email]'.

Search my Gmail inbox for emails received in the last 7 days with the subject 'Weekly Project Update for [Project Name]' from '[Team Lead Email Address]'. For each email, summarize the key progress, blockers, and next steps. Add a new row to the Google Sheet at '[Google Sheet Link]', in the sheet named '[Sheet Name]', including the project name, the week ending date, and the summarized status.