Google Sheets Overview
Customers often need to show either in-house, spreadsheet based data, or data from third-party tools that aren't natively supported, in their AgencyAnalytics reporting and dashboards.
We make this quick and easy with our Google Sheets integration.
The Google Sheets integration allows you to automatically pull in any custom data you like, and easily show it in your reports and custom dashboards.
All you'll need to do is get your data into a Google Sheet, then connect it to a campaign. You can update the Google Sheet at any time, and we'll automatically fetch those updates whenever a report or dashboard is loaded.
Using Google Sheets
First, ensure you've integrated Google Sheets within your campaign (see here for a step-by-step guide).
Once integrated, you can create table widgets and stat widgets showing your data in reports and on custom dashboards. Here's an overview of each of these widgets:
Google Sheets Table Widgets
Table widgets will show the entire spreadsheet from the first sheet (tab) of a Google Sheet. These widgets are vertically scrollable on the custom dashboard, so you can resize them as needed.
Data in the first row of your Google Sheet will be treated as headings for each column, and any column width changes you make in the Google Sheet will be reflected in the widget.
The output of any calculations will be shown in the table, and a cell's contents will become a clickable hyperlink if it begins with "http://" or "https://". All hyperlinks will open in a new window.
Here's how to set up Google Sheets table widgets:
- Add a Google Sheets table widget to a report, then configure it.
Add a Google Sheets table widget to a dashboard, then configure it.
Google Sheets Stat Widgets
Stat widgets will show data from any single cell within a Google Sheet.
Google Sheets stat widgets can display numbers, symbols, or short sentences, and they'll show the output of any calculations being performed in the cell.
Here's how to set up Google Sheets stat widgets:
- Add a Google Sheets stat widget to a report, then configure it.
Add a Google Sheets stat widget to a dashboard, then configure it.
Automating Your Workflow With Zapier
We automatically fetch data from Google Sheets, but you can also automatically send your third-party data into a Sheet using zapier.com. Zapier does this by connecting almost any third-party platform to Google Sheets.
Once set up, Zapier will "zap" the data into a Google Sheet, and we'll then pull it from the Sheet into our platform. This means you can fully automate the process of getting outside data into your AgencyAnalytics dashboards and reports.