How do I update "First Row" in Google Sheets to a new row daily?

Question

Hello, I am using “Get Many Spreadsheet Rows (Advanced, output as Line Items) in Google Sheets” and I want to update “First Row” to a new row every day. For example:Today : I set “First Row” to 2Tomorrow : I want “First Row” to automatically change to 3Day after Tomorrow : I want “First Row” to automatically change to 4etc etc etc … Can anyone please recommend me the best way to do this. Thank you! also just a bit of a background, I have a new tweet saved in in a new row in google sheets, and i want to automate posting new tweets. hence any best practices/recommendations would be highly appreciated!

SamB · Accepted Answer

Hi @sbakali, welcome to the Community!Am I right in thinkingthat you’rejust wanting to retrieve a single row that contains a tweet for that specific day?If so, I wonder if a better way would be to add a column to the spreadsheet that contains the date you want the tweet to be used.Then you’duse a Lookup Spreadsheet Row (Google Sheets) actionto search for the row using the date.I’m guessing you’re using anEvery Day (Schedule by Zapier) trigger to run the Zap each day and search for the next tweet, is that correct?So you could use the date that’s output by the Schedule by Zapier trigger, as the value that theLookup Spreadsheet Rowaction would search for. That way, the Zap should always be able to find the correct tweet from the spreadsheet.Do you think that approach could work here or have I misunderstood the desired workflow here? Looking forward to hearing from you!

sbakali · Answer

Hey @SamB!Thank you so much for this! My Zap works as desired.Thank you once again!

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded