Best answer

Rotate Through A Google Sheet Daily?

Forum|Forum|3 years ago
November 30, 2022
5 replies
216 views

Chewy14
Beginner

Hoping someone has an answer on this. If I have a Google Sheet with a list of First and Last Names for example. Could I somehow trigger a Zap one time per day for a row then trigger it again the next day for the next row?

So:

Row 1 - John Doe

Row 2 - Jane Smith

Row 3 - Jerry Jensen

Could I set a zap up to trigger Johns info then one day later trigger Janes’ then one day later trigger Jerry then when I get to the end of the list start again at the top the next day if that makes sense?

Doesn’t have to be Google Sheets either if there is some other option.

Best answer by Troy Tessalone

@Chewy14

You’ll need to add another column to the GSheet.

Something like STATUS with options such as TRUE/FALSE

In the Zap you’d use these steps

Trigger: Schedule (Daily)
Action: GSheets - Find Row
1. Search for FALSE
Action: GSheets - Update Row
1. Use Row ID from previous step

Then you’d need to add some logic to the Zap to handle the opposite when all the rows have a value of TRUE, perhaps using Paths.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|Forum|3 years ago
November 30, 2022

Hi @Chewy14

Good question.

Perhaps you can add more context about the purpose of the Zap beyond the trigger step.

You can use the Schedule app as a Zap trigger: https://zapier.com/apps/schedule/integrations

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

Like

C

Chewy14
Author
Beginner
Forum|Forum|3 years ago
November 30, 2022

@Troy Tessalone Thanks for answering on this! After that I would be sending first and last name through to subsequent steps to merge them onto a graphic. I know how to do this but I am unsure how to trigger row 1 one day, row 2 the next, and so on then move back to row one onceI got to the bottom of the list on day 3 referencing my example. The amount of first and last names on the sheet would change occassionally as some will be deleted and some added from time to time. I understand I could trigger a schedule once daily but I am unsure how to find the correct row in the Google Sheet after that so that it moved one down from the previous day. Any ideas?