Best answer

Error with Update Spreadsheet Row in Google Sheets, with webhook

  • 5 November 2022
  • 3 replies
  • 82 views

Hi,

i am trying to set up a zap to update a google sheet row, if webhook captures a replied LinkedIn prospect. 

I got the error message when testing at the step 3, which says, ‘unable to parse range…’

 

To let Zap know which row to update, i added Look up spreadsheet row step 2. 

But the result seems doesn’t link to Step 3… 

 

At the Step 3,  ‘Row’ item below, what should i fill in? 

I tried with some fields, it always returning error testing result. 

 

 

icon

Best answer by jesse 7 November 2022, 22:42

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.

3 replies

Many thanks Jesse!

Userlevel 7
Badge +9

Hey @Axin! It looks like you were able to get this one resolved with our support team, so I am going to paste their response here for anyone following along that may be running into a similar issue:

Looking at your screenshot, it looks like the "LinkedIn Member ID" is mapped as a row ID:
 
6b830e7829b1869005c8d026ef17a4fb.png
 
This field is looking for the "ID" value from your "Lookup Spreadsheet Row" step so to fix this, you might want to switch the row value to the "ID" from this step instead.

 

Then, it appears you were able to make the needed change and get things working - woohoo!


 
?name=Screen+Shot+2022-11-07+at+11.03.22+AM.png
 

Userlevel 7
Badge +14

Hi @Axin 

Good question.

You can map the ID or Row variables from the GSheets Lookup Row step.

Make sure to check the description under the Row field and click the “more” link.