As a leading provider of cutting-edge data solutions, we strive for innovation and enhanced user experiences and want to provide all customers access to our APIs irrespective of their programming skills. With this seamless integration, we have taken a significant stride towards simplifying and automating our API processes. Now, users can effortlessly integrate our powerful Phone Validation API, Reverse Phone API, Reverse Address API, and Address Validation API into their existing Zapier workflows, unlocking a whole new realm of possibilities in data validation and enrichment.
Here is a step-by-step guide to create integrations with Trestle on Zapier.
Step 1: Sign Up
Sign up for Zapier. Once you’re signed up, you can view all the apps available on Zapier’s app marketplace. Search for Trestle in the search bar or you can search in ‘My Apps’ on your Zapier Dashboard.
Step 2: Connect Your Account
To set up your account through Trestle’s developer portal found on the homepage:
- Fill in the required information on the sign-up form. You will then verify your account.
- Once verified, you will have access to all products.
- Copy your API key, enter it on Zapier, and continue to Trestle. Once your Trestle account is connected to Zapier, you can continue to create multiple zaps without having to reconnect your account.
Step 3: Create Your Integration
On the Zapier-Trestle page, choose an app to create a custom Trestle integration, or pick from a list of our ready-to-use Zapier templates.
Below is an example of creating an integration with Google Sheets without our ready-to-use template.
Please note: Before setting up your Zap with Google Sheets, we recommend having a test spreadsheet created with some data ready (e.g., a “Phone Number” column and a phone number in the first available row). Depending on the data you want to enrich the phone number with, you should also title each of the columns you intend to insert data (e.g., Street Line 1, Street Line 2, City, etc).
Step 1: Set Up Your Trigger
First, select the external app for your trigger (e.g., Google Sheets) and select the event triggering the action (e.g., new row created).
Next, connect your external account and then select your spreadsheet, worksheet, and Trigger Column. The Trigger Column will determine where Zapier looks for new data, so in this example, the Phone Number column makes the most sense.
Finally, test the trigger to view a sample row from your Google Sheet. Zapier will provide up to three of the most recent options from your trigger column. If you don’t see the specific number you want to test, try adding that phone number to the newest row in the sheet, and re-pulling in the test results.
Step 2: Set Up Your Action
Select the Trestle action that will be triggered. In this case, we are using Phone Validation.
Your account should already be connected from the previous instructions, but if not, you can select the option to connect and enter your Trestle API Key found in Trestle’s Developer Portal.
Next, identify the column that will supply the API with the phone number that is being validated. You’ll see it in an option in the dropdown, with the sample data you identified from the previous step grayed out. Don’t worry, this data is dynamic and will change depending on the new data you add to the sheet after setup.
Test your action and get live results directly in Zapier from the Trestle API.
Finally, select Continue if you’ve already added another Google Sheets step or the “+” icon below your action in the builder and select Google Sheets.
Step 3: Map Your API Data to Google Sheets
Select the Update Spreadsheet Row event if you want to insert data into specific cells in your Google Sheet.
Your account should already be identified, and you just need to map the data received from the API to the appropriate fields.
You will need to provide details to Zapier to understand where it should be sending data. This means we effectively need to identify which row and which columns. Zapier will guide you through this by first identifying the row.
Select your spreadsheet, worksheet, and target row by selecting “Row ID”. This grayed-out number represents the row from the sample data we generated earlier. Selecting Row ID as the row identifier means whichever row the data was found in will be the row the data is sent to once it’s retrieved from the API.
Now, it’s time to identify which columns will be receiving what data. Select the column head fields below that you want to insert data. Select the Trestle API section in the dropdown, and select the field you want to insert into the spreadsheet.
After this, you can run a test. If you set everything up correctly, you should see the data from your test number populate in the spreadsheet.
Please note: Sometimes Zaps can take a few minutes to run, so we recommend waiting 3-5 minutes after entering a new row of data before expecting new data to populate in Google Sheets.
Step 4: Name Your Zap
It’s ready to be published! Now, every time a new row is created or updated in your connected Google Sheet (your trigger), Trestle Phone Validation API (Action #1) will be called, and the corresponding data will be populated in your Google Sheet row (Action #2) automatically.
You can also use our ready-to-use Google Sheets template for this workflow.
If you have any questions about this integration, please feel free to contact us.