How to Use Zapier Triggers with the API
It is now possible to get database information exported through the API using Zapier Triggers. Zapier triggers work by checking the database for new information periodically, approximately every 15 minutes.
There are currently 5 options:
- Get New Lead by Field
- Get New Post by Field
- Get New User by Field
- Get Form Inquiries by Field
- Get Review by Field
For this example, we will be setting up a Get New User by Field trigger and connecting it to a Google Sheets spreadsheet.
Checklist Before Moving Forward With This Example
1) Make sure to generate a unique API Key using the documentation down below as a guideline. Please make sure to save the API Key in a safe place as it is not accessible after it has been created:
2) Make sure to have a Google Spreadsheet ready.
Setting Up the Trigger
In this example, we will be using Zapier to integrate Google Sheets to the Brilliant Directories site.
Log in to the Zapier account and click on Create Zap:
Name the Zap and click on Trigger:
Select Brilliant Directories as the Trigger:
Once Brilliant Directories is selected, choose an Event, in this case Get New User by Field:
The next step is to connect the Account. Click on Sign in:
Add the website URL and the API Key, and click Yes, Continue to Brilliant Directories:
Once the account is connected, set uup the Field To Search and the Field To Search Value that will trigger this zap:
Make sure to select a field and a value that will be consistent for all members that should be exported with this trigger. In this example, we want to get all new members that sign up. The membership plan is set to give all new members the status of "Inactive - Waiting for Email Verification", so we selected for the Field To Search "active" and the Value "1".
NOTE: It is not recommended to use a field that will vary between each member, like the user_name or email, these are unique to each member and tehrefore only one would be added to the spreadsheet.
Once this is set, the trigger is readyto be tested. First make sure to submit a member that will match teh ceriteria and then test the trigger.
If a new member is detected, that has teh active field set to "1", the test will be successful, click on Continue with the selected record:
Next up select the Change Action that will take place once the Trigger starts, in this case Google Sheets:
And then the event that will take place in the spreadsheet, in this example, Create a Spreadsheet Row:
Sign In to the Google Sheets account, and Continue:
Select the drive, spreadsheet, worksheet and row that will be updated:
Then test this step:
Once the test is ready click on Publish:
