I have a lot of data in a spreadsheet, let’s say I have 20 data and I want to post them automatically to Pinterest in rotation, but there’s a time gap between each data to be posted, for example, let’s use a 30-minute delay. So, in the first minute, it posts data number 1, then after 30 minutes, it posts data number 2, and after another 30 minutes, it posts data number 3, and so on. So it’s not a single action of posting all data because I want to make Pinterest posts every 8 hours / 3 pin postings per day. So, how can I make it like that?
You can process the data in your spreadsheet and add a column that you update with say “processed flag” set to Yes or the date/time of when the row was processed. So after you post one post, you update the processed field.
Then when you search for the next row to process you make sure you retrieve a row with processed flag set to emptystring. You can set the maxium rows returned to 1 for the search module from the spreadsheet.
Then just schedule your scenario to run every 30 minutes.