Webhook from Square > Square Get a Customer to pull the email > Google Sheets Add New Row

[Jessy]

So exactly what the title says, but the problem is that the automation creates like 5 new rows in sheets for each new execution for some reason.

I have two sheets because one is for clients and another is for the teacher for the service booked. Teacher is not dynamic as there are only 4 teachers with their matching square id’s to pull from. The client’s sheet is dynamic and where the new data is added per appointment.

And it is set up this way because the webhook data comes back as Square ID’s and not their emails which I need to send the Google Meet invite.

So the result is that since there are 5 lines populated, the automation sets up 5 meetings at the same time.

I have made sure that every Search Row function is only allowed to return one row.

What is going on here.

[Donald_Mitchell]

Hi @Jessy,

You didn’t show what the scenario looks like after an execution, but I imagine the Square module is returning multiple bundles and Google Sheets Add a Row is running once for each module. That would in fact cause all 5 modules after Square to each run 5 times, is that what is happening?

If so, then in this case Square is acting as an iterator.
To fix it you can add an Aggregator between Square and Google Sheets Add a Row, but not sure if that’s appropriate depending on the goal of your scenario. We would just need a bit more detail on how it all is supposed to work.

[Jessy]

So I took a look through all the details and I think I figured out another piece to it.

One Square’s end, they actually send 5 different packages for some reason for each event, so the make automation treats each one as a new execution.

How can I set up an iterator so that it packages them all up?

Or another approach is when searching within the google sheet to not commit if there already is an event id created.

Either way, I tried to set that up but was running into problems.

[Jessy]

Since there are 5 events received with the same event id, i just want to make it fire once for the event id.

How can make it search google sheets just once for the single event id that is made into 5 lines.

I’m trying the filtering in make but it’s not working.

[Donald_Mitchell]

There must be something unique about each of the 5 payloads, so if you are able to look at those and isolate the differences, you can focus on which one you want to act on and use filters to allow only that one.

[Jessy]

Thanks donald for the suggestion, but here are the 5 payloads.

Unfortunately, they look identical. Why is Square webhook sending 5?

But I think the only way is to somehow filter it later in the automation

t

[Jessy]

Here is the blueprint btw
blueprint.json (50.3 KB)

[Donald_Mitchell]

That is super weird! There’s a possibility you have 5 webhooks set up and they just aren’t sending unique IDs for each notification.

You may need to change your Scenario settings to Enable Sequential Processing. This will ensure each scenario instance runs in order.
Then, after Webhook, you can use Google Sheets Search Rows and try to find the event ID.
If found, it will return a bundle for each row found. In this case just end it here.
If not found, it will return Number of Bundles = 0 and you can add your row.

Another option, if you edit your webhook, enable advanced settings, there’s a way to enable get request headers

If you can find helpful info in the headers, you can filter on those and avoid querying Google Sheets every time.