1. Home
  2. Integrations, API & SSO
  3. Integrations
  4. Send App Reviews to Google Sheets via Zapier
  1. Home
  2. Integrations, API & SSO
  3. Send App Reviews to Google Sheets via Zapier

Send App Reviews to Google Sheets via Zapier

You can use the Appbot Zapier integration to send your app reviews to Google Sheets and thousands of other services, automatically.

Using Zapier to send your reviews to different tools can save your team hours every week. The Appbot Zapier integration can replace manual data entry or export and import of your reviews.
Popular uses include:

In this guide we will send app reviews to Google Sheets, as an example. At the end of the guide you’ll see what your Appbot data looks like in Google Sheets. Storing your app reviews in a Google Sheet can be useful in lots of ways. You can then use the Google Sheet to:

  • Produce your own multi-series/multi-app charts on reviews
  • Connect to third-party tools eg. business intelligence platforms
  • create an aggregate list of reviews from multiple app store platforms
  • and lots more – get creative!
How to send app reviews to Google Sheets using Zapier
  1. Navigate to the Integrations section for an app, and choose the “Add Integration” button.zapier integration screenshot
  2. Choose the “Create a new Zap” link to be taken to the Zapier editor.
    integrations zapier
  3. In the list of Trigger Apps shown, search for Appbot.
    list of triggers screenshot
  4. Choose Appbot from the list.
    trigger appbot screenshot
  5. From the Appbot trigger list, choose “New Review”.
    select appbot trigger screenshot
  6. You will be asked to connect your Appbot account. Click the “Connect an Account” button to proceed.
    connect appbot account screenshot
  7. In the popup, if you are not signed into Appbot, you will be asked to sign in. Once you are signed in you will be prompted to authorize Zapier to access your account data. If your account is not the one listed, click the “Sign In As Another User” button and sign into the correct account.authorize zapier screenshot
  8. In the original window, Zapier should now indicate you have successfully linked your Appbot account. Choose “Save + Continue”.linked appbot account screenshot
  9. You will now be prompted to select an app whose new reviews will be passed to the Zap. Click the dropdown button.
    select app screenshot
  10. A list of your supported apps will appear, please select the app you wish to use. If the app you want is not in the list, ensure you are tracking the app. To reload the list once you have tracked a new app, select “Check Appbot & reload to bring in new choices.”
  11. Once you have selected an app, choose “Continue”.
    app selected screenshot
  12. Zapier will now fetch the most recently fetched review for your app to use as an example while configuring the Zap. Choose “Pull in Samples”. Note: You must have at least one review in the selected app to proceed.
    pull samples screenshot
  13. If the test is successful, Zapier will show data from your app. You can view the format of the review data your Zap will have access to by expanding a review. Otherwise click select “Review A” and choose “Continue”.
    view review format screenshot
  14. You have set up the Trigger phase, now you must select a Zapier action. Click “Add one now!” to proceed.
    add zap action screenshot
  15. Choose the action you wish to connect to your Appbot reviews. Any Zapier action is supported, but for the purposes of this guide we have chosen Google Sheets.
    choose zapier action screenshotzapier google sheets zap action screenshot
  16. Select the relevant trigger from your chosen Action App.
    select google sheets action screenshot
  17. Connect any relevant accounts necessary to operate the service.
    google sheets email connection screenshot
  18. In the case of the Google Sheets example, we have created a Google Sheet with columns named appropriately for our app reviews.
    zapier google sheets example screenshot
  19. We select the relevant spreadsheet.
    select relevant google spreadsheet screenshot
    and worksheet to insert reviews into.
    select google sheets worksheet screenshot
  20. Once selected, Zapier now wants to know how we will map the Review data we receive to the four different columns in the spreadsheet. For each of the columns, select the button to the right.how to map review data screenshot
  21. Select whatever Review attributes you would like to be placed in the relevant column. You can place one or many, and you can separate them with any characters you like.review attributes screenshot
  22. Here we have mapped the Author name, Rating and Country to the fields with the same name. But for the Text column, we have placed both the Subject and the Body into the column, separated by a colon.
    example of mapping screenshot
  23. You have the option to send a test row to the Google Sheet, click “Send Test To Google Sheets” and verify it is inserted into the sheet as desired.
    sent test to google sheets screenshot
    Here’s how the results of the test will look:
    example of results test screenshot
  24. Choose “Finish”.
    finish zapier google sheets setup screenshot
  25. Give your Zap and name and switch the “Off” button to “On” to turn the Zap on.
    zap toggled off screenshot
  26. If you see the success screen, your Zap is now operational!
    zap toggled on screenshot


Was this article helpful?

Related Articles