How do I create a Zap that every day looks up the next row in Google sheets?
I have a work-around that is a bit too complicated and I’m hoping for a simple and effective way with less than 3 steps.
To give you an example of a use case, I have a Google spreadsheet with motivational quotes on each row, and every day I want to send the next quote to Gmail. I don’t want to send the very latest quote at the bottom of the list, or a random quote from the list, only the next quote in the list.
Hi there
Welcome to the Community! 
It looks like you’ve reached out to our Support Team about this and they replied on Sunday with a suggestion. I’ll share details of the suggestion here in case it’s helpful:
To achieve this, I would recommend adding a date column in your Google Sheets and adding the dates in each row/quote so we can fetch the quote every day using the Lookup Spreadsheet Row action.
The date format should be like this:
(view larger)
Next, kindly set up your workflow like this:
Kindly give this a try and let's see if this will work as you intended.
I hope this will help, and please let me know if you have any clarifications or other concerns. I'm happy to help!
If you’ve got any questions regarding their suggestion it would be best to continue the conversation with them over email. If you can’t locate their reply I’d recommend searching your spam/junk folder or searching your inbox for any emails from zapier.com in case. Sometimes their emails can end up in the spam/junk folder by accident.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.