Best answer

Having a nightmare with a simple flow

  • 2 September 2020
  • 1 reply

Userlevel 1

HI All,


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.


Thanks all.


Best answer by Troy Tessalone 2 September 2020, 18:37

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Try using the below Zap Steps:

Action: GSheets - Find/Create Row (NOTE: This is the Lookup Row action)

Action: GSheets - Update Row