How to ensure correct execution order for multiple Google Sheets triggers using Auto-Send on Schedule

[akshit_c]

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hi Pabbly Support Team,

I have a workflow setup involving three Google Sheets, each connected to a separate webhook / Pabbly flow, all configured with the trigger “New Row Added” and Auto-Send on Schedule enabled.

Here’s the setup:

• Sheet 1: Stores user profile details
  • A new row is added via API when a user signs up on our website.
• Sheet 2 & Sheet 3: Store user queries
  • These correspond to two different query forms on the website.
  • Queries can only be submitted after signup, but may be submitted within 1–2 minutes of signup.
  • These sheets rely on the user profile data from Sheet 1.

Because rows are added via API, all three sheets use Auto-Send on Schedule, which (as I understand) sends data in batches on an hourly schedule.

Concern:
If Sheet 2 or Sheet 3 is processed before Sheet 1 during a scheduled send, the flows for Sheet 2 / Sheet 3 may fail because the corresponding user profile row from Sheet 1 may not yet have been processed by its flow.

My question:
Is there a way to ensure that Sheet 1’s flow always executes before Sheet 2 and Sheet 3?

If not, what would be the recommended best practice to handle this dependency reliably?

Looking forward to your guidance.

 

[Preeti Paryani]

Hey @akshit_c,

Could you please provide us with the Workflow URL where you are facing this issue? This will help us investigate the problem more effectively and assist you accordingly.

Please be aware that to assist you effectively, we may need to access your Pabbly Connect account. If you're comfortable with this, please grant us permission by stating in your next reply:

"You have my permission to log into my Pabbly Connect account and edit the workflow, if required. Here is the registered email address associated with it."

Looking forward to assisting you further.

 

[akshit_c]

workflow for sheet 1 : https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZkMDYzZjA0MzU1MjY4NTUzNjUxMzQi_pc

workflow for sheet 2 : https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZkMDYzZjA0MzU1MjY5NTUzMTUxM2Ii_pc

workflow for sheet 3 : https://connect.pabbly.com/workflow/mapping/IjU3NjcwNTZjMDYzNDA0Mzc1MjY1NTUzMDUxMzEi_pc

"You have my permission to log into my Pabbly Connect account and edit the workflow, if required. [email protected] is the registered email address associated with it."

 

[ArshilAhmad]

When data is added to your Google Sheets spreadsheet through a third-party application, it can take up to 1 hour for the workflow to get triggered.

You can reduce this time to 1 minute by adding an Apps Script to your spreadsheet. This way, whenever data is added to the sheet, it will trigger the workflow within 1 minute.

Google Sheets (1 Minute Trigger) Send New rows in every 1 minute.

In this tutorial, we will see how can you set up Google sheets trigger "New or Updated Spreadsheet Row" in Google Sheet so that you can capture data every minute. Please note: We also offer a Pabbly Connect Webhooks addon for Google Sheets. The current limitations of the Google Sheets trigger...

forum.pabbly.com

You can add this Apps Script to the spreadsheet connected to Workflow 1.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support