Zipcode Lookup
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.
Step 1: Sign in to your Google account and access this google sheet link.
https://docs.google.com/spreadsheets/d/1e8hYcRYIsu0bHY-445NKVB58nFxhS0mB2C9LRriJ_ik/edit?usp=sharing
Step 2: Make a copy of the google sheet file (File > Make a copy).
Step 3: Go to Extensions > App Script.
Step 4: Deploy the App Script by clicking Deploy > New Deployment at the top right.
Step 5: Choose Web App under Select Type, Set the description, Make sure to select “Anyone” under “Who has access” and click Deploy.
Step 6: Allow Access until you get to the screen where you can get the Web App URL.
Step 7: Import this sample decision tree to your account.
Step 8: Paste the Web App URL in your API node Request URL.
Step 9: Add the zipcode parameter at the end of the Request URL.
?zip={zip}
Step 10: Click “Test Request” and click “Proceed to fieldmapping” to map the response to your custom fields. Save and Publish the DT.
Car Make and Model Lookup
This method functions like a related dropdown, returning all values associated with the option selected in the first dropdown.
Step 1: Sign in to your Google account and access this google sheet link.
https://docs.google.com/spreadsheets/d/1iIr3NL4kXrfyDQ9cHKsY4m_dUKNhuWm2L4XWMOiEdj8/edit?usp=sharing
Step 2: Follow the same procedure as above (Step 2 to Step 6)
Step 3: Import this sample decision tree to your account.
Step 4: Paste the Web App URL in your Custom Page Node. Save and Publish the DT.
Step 5: Create text type custom fields “car_make_value” and “car_model_value”. This is where the selected options are going to be saved.
Autocomplete Lookup
This approach is similar to the zip code lookup feature above, but requires the user to input text into a field, prompting a list of suggestions drawn from the Google Sheet database.
Step 1: Sign in to your Google account and access this google sheet link.
https://docs.google.com/spreadsheets/d/1gntnmhMu4jA489vaPmjjaVn_hfmVq0qETkYzwAXc2uM/edit?usp=sharing
Step 2: Follow the same procedure as before (Step 2 to Step 6)
Step 3: Import this sample decision tree to your account.
Step 4: Paste the Web App URL in your Custom Page Node. Save and Publish the DT.
Step 5: Create text type custom field “zip”. This is where the zipcode value is going to be saved.
Feel free to reach us help@leadshook.com if you have any question or need any assistance with your implementation.
