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.
Today : I set “First Row” to 2
Tomorrow : I want “First Row” to automatically change to 3
Day after Tomorrow : I want “First Row” to automatically change to 4
etc etc etc …
Can anyone please recommend me the best way to do this.
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!
Best answer by SamBView original