I am trying to resolve a workflow, but Zapier Support are sending me in circles, being vauge and not helpful, so I’ve come to the commuity for support.
Issue - Getting a Zap to update a Row on a Google Sheet.
1 - I’ve got a webform that sends over a hook to Zapier
2 - Zapier catches it and adds a new row to a Google Sheet.
3 - If someone edits thier Webform and re-submitts - this tiggers Zapier again
4 - Zapier performs a lookup by ID. When it finds the ID, its intructed to update all the row details
I’m not having any luck with step 4.
I just wondered if someone could post either a step by step of a scenario (i.e. a webhook) that triggers a new row or an updated row depending if the row already exsisits (i.e. new if not, if exisit then update)
Its drving me mad and support is being no help at all, being moved from agent to agent and thier answers being vague and unhelpful.
Best answer by Troy TessaloneView original
Try using the below Zap Steps:
Action: GSheets - Find/Create Row (NOTE: This is the Lookup Row action)
Action: GSheets - Update Row