Contacts not uploading on pabbly chatflow through pabbly connect

Hi Deepak,

Thanks for reaching out about your Google Sheet to Pabbly Chatflow contact sync that worked initially but has now stopped, even though the connection shows success and new rows are being added.

When a Google Sheets trigger stops firing on new rows, it is usually a trigger configuration issue rather than the Upsert Contact step. Please check the following:

1. Open your Google Sheet, go to Extensions > Pabbly Connect Webhooks, and confirm the correct send mode is enabled:
   - Send on Event - use this if rows are added manually.
   - Auto-Send on Schedule - use this if rows are populated by a third-party application/integration (e.g. a form tool or another automation writing into the sheet). Manual Send on Event will not fire for third-party writes.
2. Make sure the trigger column (the final data column) is consistently filled, since Pabbly only fires when that column receives a value.
3. Verify the webhook URL in the Google Sheets extension still matches the trigger URL in your current workflow.

After adjusting this, add 2-3 new test rows and check the workflow's Task History to confirm they are being received. If the issue persists do let us know.

Thanks . but will it be triggered immediately after the entry is done by automation . or there is some way where we can schedule the event on daily basis ?

Hi Deepak,

Thanks for reaching out to us.

With your current workflow structure, where the Google Sheets webhook is used as the trigger, the workflow will execute immediately whenever a new row is added to the Google Sheet.

If you would prefer to schedule the contact sync on a daily basis instead, you can restructure the workflow as follows:

1. Set Schedule as the workflow trigger and configure the specific time at which you want the workflow to run each day.

2. Add the Google Sheets – Get Rows action to fetch the required rows from your sheet.

3. Make sure the response from the Get Rows action is captured in the Advanced Response format.

4. Add an Iterator after this step so that the rows retrieved from Google Sheets can be processed one by one.

5. Finally, add the Pabbly Chatflow – Set/Upsert Contact action to create or update each contact individually.

With this setup, the workflow will run automatically at your scheduled time each day and process the Google Sheets entries one by one.

If you need any assistance while restructuring the workflow, please feel free to share the workflow details with us, and we’ll be happy to guide you further.