Hi everyone! I’ve created a simple
Scenario pulling in data from Shopify using the “Order update” webhook and plugging them into Google Sheets
It seems that the “200 OK” response is not correctly being generated as we’re getting multiple responses before timing out (usually 2-3)
Sequence looks like this:
:
- Custom Webhook Sequence
- Webhook Response
-Status: 200
-Response: Blank
- Google Sheets Add A Row
Has anyone experienced this before, and, if so, figured out how to fix it?
Any suggestions would be appreciated! Thank you!
Welcome to the Make community!
You do not need to send a response with HTTP 200, as that is the default (with body content “Accepted”) once it reaches the end of the scenario run (successfully). This saves you one operation per cycle.
Delete that webhook response module and try again.
2 Likes
Thanks Sam!
Okay I deleted the middle step:
However, this is what the previous sequence looked like and i got even more repeated rows. Let’s wait for the next order to come in and see what happens. Will update you! Thanks!
You probably just need to switch to using the “Update a Row” module instead of “Add a Row” for every order update.
“Update a Row” requires you to know the row number to update, so you might need to perform a “Search Rows” for the order ID first to get the row number where the order is stored in the sheet.
2 Likes
Nice suggestion! Still uses up operations but more efficient (and less painful) than ripping my hair apart!
Thank you!!
No problem, glad I could help!
The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
- others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post:
2 Likes
