Best answer

Receive data from webhook call, creating a worksheet at google sheet and lastly adding webhook data to the new worksheet

  • 17 March 2020
  • 1 reply
  • 127 views

Hi all, so i have been having trouble with creating the worksheet with the title being one of the webhook data, the custom header would disappear once i try to send the data for testing. It would create the worksheet with the right name but without any header.Secondly once i create the worksheet i want to take the data that i get from the webhook and insert it to the newly made worksheet. What is the id of the new worksheet as it dynamically changes?

 

icon

Best answer by Danvers 19 March 2020, 12:56

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 +12

Hi @beelian_aba Thanks for your question and I’m sorry you’re having some trouble here. 

 

It would create the worksheet with the right name but without any header

Could you confirm something for me here? Do you mean that the header row doesn’t exist in the Sheet, or that you can’t see the header row fields in the Zap?

 

What is the id of the new worksheet as it dynamically changes?

You’ll be able to get the ID of the Worksheet from the Create Worksheet step. To do that, for Worksheet choose the ‘custom’ option and select the ID of the worksheet created in the previous step. 

 

When you use a custom value for a spreadsheet or worksheet in a Google Sheets step, it wont show you the fields from the header rows. This is a limitation of the way that the integration works and isn’t one that we’re able to fix right now, but there is a workaround!

 

If all of your sheets have the same columns, then you can set up the Zap using an existing worksheet and then switch it to the custom value. To do that:

  1. When you first set up the Zap, choose another Worksheet that already exists
  2. Map the values that you need from your previous step (in this case from the webhook) into the fields in the Zap editor
  3. Change the Worksheet to use a custom value and select the worksheet ID from the Create Worksheet step

 

This will make all of your existing fields disappear, don’t worry they’re still there! Test the step in your Zap to make sure that everything is set up as you need but you should be good to go!