Hey Make community, I need some guidance on optimizing my automation workflow.
I have a Google Sheet with approximately 6,000 rows, and I’m using OpenAI and Perplexity to update data on that sheet. Currently, I’m running automation that processes 250 rows per run, but it seems to get stuck after processing 250 rows straight.
Ideally, I want the automation to:
- Run every hour or half an hour, processing 250 rows each time.
- Pause for 30-60 minutes after each batch to allow the system or APIs to reset/cool down.
- Resume from where it left off, picking up from the last row it processed.
I’ve tried configuring the scheduling intervals in Make.com, but it doesn’t seem to align with what I need.
What would be the best way to achieve this? Is there a more reliable method or workaround to ensure the automation runs smoothly without getting stuck?
Any suggestions or best practices would be greatly appreciated!
Thanks in advance!