Best answer

Having a nightmare with a simple flow

  • 2 September 2020
  • 1 reply
  • 32 views

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.

icon

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

Try using the below Zap Steps:

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

Action: GSheets - Update Row

 

 

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +10

Try using the below Zap Steps:

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

Action: GSheets - Update Row