Promote New Blog Posts on X

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

Search X for recent posts about '[Industry Keyword, e.g., #AIinMarketing]'. Find the top post with the most likes from the last day. Create a new post on X quoting it with the comment '[Your Comment]'.

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