This guide explains how to send incrementing number values to Google Sheets, a useful method for tracking with webhook nodes. This approach is commonly used for split testing nodes in a decision tree, ensuring accurate data tracking and analysis. Step 1: Go to https://docs.google.com/spreadsheets Step 2: Create your Google Sheet by clicking the “Blank Spreadsheet” Step 3: In […]
Category: Scripts
How to Query Data from Supabase
Supabase allows large datasets and can perform very fast lookup via their built-in API tools. Step 1: Set up your Supabase project Step 2: Upload your CSV Step 3: Find the API details and request URL Sample Request URL:https://<your_project_id>.supabase.co/rest/v1/<table_name>?<table_column>=eq.{zip} Headers: Short video of setting it up: How to setup autocomplete lookup to your Supabase database […]
How to send data to Google Sheets directly
Step 1: Go to https://docs.google.com/spreadsheets Step 2: Create your Google Sheet by clicking the “Blank Spreadsheet” Step 3: In this example we’re going to send the first name, last name and email address. So we’re setting up 3 columns and naming the first row. Step 4: Go to Extensions > App Script Step 5: Copy […]
How to use Google Sheet as a lookup table
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 […]
How to automatically show decision tree as a pop up on your website page.
This is useful if you need something that captures the lead as prerequisite of getting access to the content of your page. The page they need access to is visible in the background and the DT is shown as pop up. Step1: Get your decision tree account domain and token here: Step2: Use this code […]
Validating special characters in the first name and last name input fields on a form node using JavaScript
Introduction: This article provides a step-by-step guide on how to implement a JavaScript script for validating first and last name input fields in a form. The script ensures that these fields contain only letters, spaces, and for the last names, single quotes. Implementing the script Step 1: Firstly, add the following script into the form […]
Integrate Google Places Map to display on the next node after the user enters Google address autocomplete
Introduction: This guide provides custom scripts to move the users to the next node the moment they click any address from the Google Places Address validation dropdown. Step by Step Guide: Step 1: Enable Google Address Autocomplete Step 2: Map Google Address API Fields to Leadshook Custom Fields Step 3: Create Q&A node and Select […]
How to assign your own class to Form Node Buttons
Please Note: This is only advised for users who are using a third party tracking system that requires a unique button class on your form node. Introduction Some third party require a specific button class to triggers and track a certain node. Since Leadshook would have the same classes for each Form Node button, then […]
How to Setup TrustedForm by ActiveProspect
IMPORTANT UPDATE: ActiveProspect has just released a new security update which will affect clients who are claiming their own lead certificates. This means that you will now need to verify your domain in order to properly claim the certificate. This is to ensure that your leads will not be able to be claimed from any […]
How to use Masked Input for Sensitive Information
Step 1: Create a Custom Field and name it masked_input Step 2: Add a new Custom Page and enter the code below