How to "DELETE" reviews through the API using Zapier
This article shows an example of how a Google Spreadsheet can be used to delete a 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 delete a member review:
- review_id
- review_title
Find the ID of the Review in Interactions » Member Reviews:
Connecting Google Sheets with Zapier
Log in to the Zapier account and click on + Create and click on Zaps:
or Click on Zaps
Click on + Create then click on New Zap:
Click on Trigger and search for Google Sheet:
The Trigger event should be set to "New or Updated Spreadsheet Row." After logging into the Google account, clicking on "Continue" will proceed.
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 Continue with Selected Record. The Spreadsheet information will display as a preview:
Connecting the API with Zapier
A new set of options will appear, select the option for Brilliant Directories:
The Action Event should be set to "Delete Review." A Brilliant Directories account can be chosen if one has been used before, or a new account can be connected.
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
Click on Continue.
Click on the vertical dots and select Custom.
Select review_id. Hit Continue.
Click on Test Step:
The record is now deleted, click on Publish to have the Zap active.
Add a name to the Zap to find it easily:
If done correctly, the review will be removed in the Interactions » Member Reviews:
Click on Transfer existing data is there is a need to delete the reviews right away. For automatic deletion, simply waiting a few minutes for the trigger "New or Updated Spreadsheet Row" to take action is all that's needed.
