Google sheet + Flodesk

Hello Grant,

Thanks for reaching out. Since your test works but the 10 new rows aren't triggering the workflow, this is almost always due to the Send Mode configuration in the Pabbly Connect Webhooks add-on in your Google Sheet.

Please open your Google Sheet and go to Extensions > Pabbly Connect Webhooks > Initial Setup, then check the following:

1. Trigger Column: You mentioned using Column J as the final column. Confirm that Column J always gets a value on every new row, since the webhook only fires once that column has a value.

2. Send Mode - choose based on how rows are being added:
   - If rows are added by an automation (another tool, form, API, etc.), enable Auto Send on Schedule (also called Send on Schedule). Send on Event will NOT fire for programmatic edits. Pabbly checks for such data once every hour.
   - If rows are added manually by a person typing, enable Send on Event. Note that if you paste data, you must press Enter (or click out of the cell) so the row event is committed.

3. Sheet Name (tab): Confirm the correct tab is selected and matches where the data lands.

4. Click Send Now / Submit to save after any change, and make sure the webhook URL in the add-on matches the trigger webhook URL in your workflow.

5. Confirm the workflow toggle is turned ON.

After updating, add a fresh test row the same way your real data arrives and check the Task History in Pabbly Connect to confirm the trigger captured it.

Is this the one I should use? I thought it would only go when a new row was added but i just got an email that i was maxing out my workflows. Maybe something is setup wrong?

Rows are added automatically at no specific time intervals. The data is from emails and is parsed into the sheet. Why is it trigger so many things? I only want NEW rows...not old ones added.

Hello Grant,

Initially, you reported that the workflow is not triggering even after the data is added to the Google Sheet. May we know what actions you performed after our last email?

Did you click the Send All Data event?

As the data is being added through an automation process, the recommended event is Auto Send on Schedule (Beta)

Hello Grant,

I hope you’re doing well. I just wanted to follow up regarding my last message.

Hello. I changed the trigger type to the one you see "Auto send on schedule". That is it. But I thought it would be just 4 tasks per row added but its saying I used thousands of tasks (9566 or so). Why so many I don't understand?

Hello Grant,

How many rows were there in the Google Sheet?

When I first set it up there were 2637 rows. I wrote the number to check how many appointments were added and then make sure they were being sent to Flodesk.

Hello Grant,

So, basically, you updated all the rows of the Google Sheet after setting up the Pabbly Connect Plugin on the Google Sheet?

No, I didn't change anything. I just made note of what row I was on when I enabled pabbly so I could see if any new rows were added and then make sure the data was transferred properly.

Hello Grant,

We have reset the tasks for your account. Please check on your end. Further, select Auto Send on Schedule (Beta) event in Pabbly Connect instead of Auto Send on schedule; it should work fine now and only trigger the new rows that are added in the Google Sheet.