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, you would just have to make a copy, 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