Find New Prospects by Persona

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]'.

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.

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'.

From my Google Sheet at [Sheet Link] and worksheet [Worksheet Name], take each row where 'LinkedIn Info Updated' is 'No'. Use the 'Company Domain' to get the company's info from LinkedIn. Update the 'Industry', 'Employee Count', and 'Location' columns with the results.

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'.