I am trying to make a Webhook to update my Google Sheet.
Steps taken so far
I created a Webhook to receives data from after submission on my website. I receive data and it get the persons First Name, Last Name and email no problem. I want to have to data sent to a Google Sheet. My problem is I am not sure how to get the Webhook data broken down so in the Google Sheet set I can select (First Name, Last Name and email). Sorry if this has been asked before I looked for about an hour and did see anything.
Looks like you have a json string here and need to parse it. Try to add a “Parse JSON” module between webhook and google sheets and parse the received json string.
Ok I made head way but not sure what I might be missing. After creating the Parse JSON it seems to work as I can see the out puts I need i.e. (First Name, Last Name, Email) but when I try to add the Google sheets after the JSON only the Email is showing up to select not the First Name and Last Name.
The values are there. You just cannot see it because the key name “title” and the value name “value” are the same for each of them.
This is how you get the values. Input this to the fields in Google sheets and change the input array.
First name: {{get(map(1.fields; “value”; “title”; “First Name”); 1)}}
Last name: {{get(map(1.fields; “value”; “title”; “Last Name”); 1)}}
Email: {{get(map(1.fields; “value”; “title”; “Email”); 1)}}
