{"id":7663,"date":"2025-02-20T17:40:10","date_gmt":"2025-02-20T17:40:10","guid":{"rendered":"https:\/\/www.leadshook.com\/help\/?p=7663"},"modified":"2025-02-20T17:40:11","modified_gmt":"2025-02-20T17:40:11","slug":"how-to-use-google-sheet-as-a-lookup-table","status":"publish","type":"post","link":"https:\/\/www.leadshook.com\/help\/how-to-use-google-sheet-as-a-lookup-table\/","title":{"rendered":"How to use Google Sheet as a lookup table"},"content":{"rendered":"\n

Zipcode Lookup<\/h2>\n\n\n\n

This method returns all row values associated with the zip code or any other data. It is useful for lookups when you need to retrieve the corresponding values.<\/h4>\n\n\n\n

Step 1:<\/strong> Sign in to your Google account and access this google sheet link. <\/p>\n\n\n\n

https:\/\/docs.google.com\/spreadsheets\/d\/1e8hYcRYIsu0bHY-445NKVB58nFxhS0mB2C9LRriJ_ik\/edit?usp=sharing<\/a><\/p>\n\n\n\n

Step 2:<\/strong> Make a copy of the google sheet file (File > Make a copy).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 3:<\/strong> Go to Extensions > App Script.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 4:<\/strong> Deploy the App Script by clicking Deploy > New Deployment at the top right.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 5:<\/strong> Choose Web App under Select Type, Set the description, Make sure to select “Anyone” under “Who has access” and click Deploy.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 6:<\/strong> Allow Access until you get to the screen where you can get the Web App URL.<\/p>\n\n\n\n

Step 7:<\/strong> Import this sample decision tree to your account.<\/p>\n\n\n\n

google-sheet-zipcode-lookup_2025-02-20<\/a>Download<\/a><\/div>\n\n\n\n

Step 8:<\/strong> Paste the Web App URL in your API node Request URL.<\/p>\n\n\n\n

Step 9:<\/strong> Add the zipcode parameter at the end of the Request URL.<\/p>\n\n\n\n

?zip={zip}<\/p>\n\n\n\n

Step 10:<\/strong> Click “Test Request” and click “Proceed to fieldmapping” to map the response to your custom fields. Save and Publish the DT.<\/p>\n\n\n\n