Log X Post Performance

Check my blog RSS feed at '[RSS Feed URL]' for new posts since yesterday. For each new post, create a post on X with its title and a shortened link. Add the hashtag '#[YourBrandTag]'.

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