Our Google Sheets integration will always show the latest Google Sheets data in your reports and dashboards. However, this can require you to manually get your data into the Google Sheet first. To fully automate the process, you can use a tool like Zapier or IFTTT (If This Then That) to send data into Google Sheets. Below, you'll see how to set this up.

The video below is an excerpt from our Google Sheets webinar. This video covers how to set up a social listening tool that automatically reports mentions of a brand name. This concept can be applied to almost any other type of data, to help you automatically report on almost anything using AgencyAnalytics.

Here's a written overview of the process covered in the above video.

This example shows how to use Zapier to set up a social listening tool that automatically reports Twitter mentions of a brand.

First, connect your Zapier account to Twitter and set it to detect tweets containing mentions of your brand (in our case, we used the brand "Tesla"). Zapier triggers can be set up to scan for specific mentions of brand names, phrases, or products.

The next step is to connect Google Sheets to Zapier. This will allow Zapier to automatically send the Twitter mentions into a Google Sheet.

Next, ensure you've integrated Google Sheets with AgencyAnalytics.

From there, you can add Google Sheets widgets to your dashboards and reports. In this example, to report our list of Twitter mentions, we've added a Google Sheets table widget.

The end result is a report table that will continually populate with new Twitter mentions of the brand "Tesla".

Regardless of the type of data or integration you're reporting on, the process will always be the same:

Use this process to automatically share data from integrations we don't natively support, to monitor engagement on social media platforms, audience research, or to automatically report on data from almost any other source.