How to "CREATE" reviews through the API using Zapier
Link: https://support.brilliantdirectories.com/support/solutions/articles/12000101416
This article shows an example of how a Google Spreadsheet can be used to create a new review for members on a site using the site's API.
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. This spreadsheet should have at least one row of the review information shown below:
Please note the following required fields in order to create a member:
- user_id,
- review_title
Connecting Google Sheets with Zapier
Log in to the Zapier account and click on + Create and click on Zaps:
Click on Trigger and search for Google Sheet:
Select New or Updated Spreadsheet Row for the Trigger event and log into your Google account, once done click on Continue:
Select the Spreadsheet that has the review information with the respective Worksheet. If necessary, select a Trigger Column or leave as "any column" and click on Continue:
Click on Test Trigger and the Spreadsheet information will display as a preview:
Click on Continue with selected record for the next step in this process.
Connecting the API with Zapier
A new set of options will appear, select the option for Brilliant Directories:
Select the Action Event to Create Review and either choose a BD account if you've done this in the past or Connect a new account:
If an account is already, skip down to FILL IN THE BLANK.
If this is the first time, click on Connect a new account and a popup will show up. Add the website URL and the API Key, and click Yes, Continue to Brilliant Directories:
Once finished, click Continue.
Configuring the Review Information
The next step will be aligning the fields from your worksheet to the correct fields for the Review to be created.
Once all the respective fields have been selected and added, click on Continue:
If there is a need to send a notification, select Send Email Notifications?
These are the options:
Email Member About This Update
Email Reviewer About This Update
Email Member & Reviewer About This Update
The next step will ask to test the trigger, do so to verify that everything went well:
If done correctly, the review will show up in the Interactions ยป Member Reviews: