I'm new to Zapier so please forgive me if this is obvious.
I want to make a simple setup that pulls in tweets that mention my Twitter handle to a Google sheet, then retweets the tweet after a number of days (which varies depending on the tweet).
I've done the first part using Search Mention in Twitter... Create Spreadsheet Row in Google Sheets. It seems to work fine.
My Google Sheet then calculates the date/time for the retweet and puts this in a column.
However I cannot work out if there's a way to get Zapier to do this retweet according to the schedule. So far I've tried:
- When a new spreadsheet row is added, send tweet. I've set it to watch a tab which is supposed to populate a new row in the "send" sheet according to the schedule, however this doesn't really work as I think the sheet needs to be open all the time to do this.
- Once a day (Scheduler) check a sheet tab for content and send tweets. However I'm not sure this would work for multiple tweets (and I'm not sure if Google sheets again needs to be open all the time to get it to update).
Is there something I'm missing? Is there a better way?
Many thanks in advance.
Best answer by AndrewJDavison_LuhhuView original