Umer003
Member
I am facing an issue with processing multiple rows from Google Sheets in Pabbly Connect. My goal is to send data row by row with a delay between each row to prevent multiple parallel tasks from triggering at the same time. Below is my setup and the problem I am encountering:
My Current Setup:
- Trigger: Google Sheets – "New or Updated Spreadsheet Row" (Auto Send on Schedule).
- Filter: Only process rows where the "Posted Date" column is empty.
- Action: Send the row’s data to Pinterest for pinning.
- Delay: I added a delay of 30 minutes using "Delay (Pabbly)".
- Update Google Sheets: Once processed, update the "Posted Date" column to mark the row as completed.
The Problem:
- If I add 50 rows at once, Pabbly triggers 50 parallel tasks at the same time, even though I have added a 30-minute delay.
- This causes all 50 pins to be scheduled for posting at the same time after the delay ends instead of processing them one by one with a gap of 30 minutes each.
- I need a way to process only one row at a time, wait 30 minutes, and then move to the next row instead of processing all rows at once.
What I Need:
- A way to process rows sequentially, not in parallel.
- A solution where one row is processed at a time, and the next row only starts after the previous one is completed and delayed.
- Any possible workaround using Google Sheets, API triggers, or Pabbly's built-in tools to achieve this functionality.