Capterra Ads Data To Google Sheets

Overview

Google Sheet template that uses the Capterra Ads API to import data for multiple accounts. To get started, you'll need an API Key. You can obtain one by contacting your account rep.

Instructions

1. Make a copy of the sheet template using the link above

2. Go through the Settings sheet and update your desired import date ranges and refresh schedule (if you want to import data routinely).

3. When you're done updating your desired parameters here, you can set up an automated refresh by going to the menu item Refresh Data > Update Refresh Schedule From Settings.

   • • NOTE: this script is not currently designed to import "Today's" data. Data gets deduplicated after import for the each unique row. If live data (i.e. "today's" data) is refreshed several times a day, it will get double counted. You'll need to make updates to the script to avoid this. See the removeDuplicates line of code in Script Editor.

     • NOTE: To delete existing triggers and stop the automated data refresh, just select Refresh Data > Clear Scheduled Refreshes

4. Before you run a test refresh: Go to the Account List tab.

5. Enter each account name you want to import in Column A. The specific name is just for organization purposes. You can name the accounts whatever you want.

6. The template has three values here by default. You can add more/less. Just be sure that for every account name you've entered in Column A, there is a sheet with the name: <ACCOUNT> Data Import

7. Enter the respective API Keys in Column B for each account.

8. Once you've added all of your accounts and API keys, you can import the desired data by selecting Refresh Data > Refresh Capterra Data.

9. That should do it! Data will import into each account's data import tab using the respective API key. The Dataset tab will combine all of the data into one consolidated table.

   • • NOTE: Data will automatically deduplicate duplicate rows at the time of import. Empty rows will be removed.