In this article you’ll learn how to use Google Sheets as an external database. You can make API calls from LeadsHook using the API node and SAVE the returning data into custom fields.
There are 2 methods available…
METHOD #1: Easy Method Using a 3rd Party App (Developer NOT Required)
In method 1, you use a 3rd party app that provides you with API end points to use inside LeadsHook. This is quite easy. Please watch this short video…
METHOD #2: Using Scripts (Developer Required)
- 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 LeadsHook
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.