If you’re using Zapier to populate a Google Sheet and want to cut out the middleman. Its possible to just go straight from LH to Google sheets.

It should be much more reliable, as Zapier can miss a few calls from time to time.

This is a test sheet with working code.
1. You need to be logged in to your google Account.

2. You will need to make a Copy of the Spreadsheet which will be saved to your Google Account Sheets.

3. Change my custom fields to your own, and the sheet name to your own from the code.


Then go – Publish/ Deploy web app, and put the url in your webhook node in LH.

Here’s a video walk through


When testing your webhook, you might get a 200 status code. Yet still it doesn’t work. If you examine the webhook response and see that part of it complains of a JSON syntax error.

SyntaxError: Unexpected token in JSON at position 81 (line 18, file "Code")

That likely means you have blank spaces in your webhook between the name/value pairs, that cause the syntax error.

“firstname” : “{firstname} //wont work

“firstname“:”{firstname} //will work


Leave a Reply

Your email address will not be published. Required fields are marked *