- Basically you send a request to the GS server with a parameter to search with.
- Then the script will search a given column where the parameter matches.
- When it finds the matching column value – the whole row is retrieved, converted into JSON, and sent back to the LeadsHook API call as response parameters.
- These parameters can then be assigned to custom fields in LH.
1.) Make sure you are logged in to your gmail account.
2.) Click the link below, or paste it on your browser.
3.) On your Google Sheet, go to File -> Make a Copy, and it should then be saved on your google drive’s account.
4.) You will be using that Copy as your Google Sheet of reference for your own Database ( Lookup table )
5.) To edit the script, go to: Tools -> Script editor on your Google Sheet. You can then change the script how you like. The main points to note are the GET request parameter, the column index ( which is zero based ). On the actual sheet you must take note of the column headers too.
6.) In the script editor ( once you have edited your script how you like ) you will need the server URL. So go -> Publish -> Deploy as web app. A dialog will appear with the URL to copy paste into your LeadsHook API node GET request. Then just follow the rest of the prompts to publish.
7.) When you are ready to test go ahead and run the server. Run -> Run Function -> doGet. And the server is ready to accept requests.