Screen Shot 2014-03-12 at 15.34.38

Supermetrics for Google Drive

is an add-on that turns Google Drive into a full-blown business reporting system for web analytics, social media and online marketing. Run queries, refresh by the press of a button, and share your reports & dashboards.

Try For Free: Supermetrics for Google Sheets
The button above will direct you to the Google Add-on store, where you can install the add-on and start a free 30 day trial with full functionality. After the trial, you can continue using the add-on for free but with limited functionality.

We also have a version for Google Docs.

The Supermetrics add-on makes it simple to automate your reporting in Google Docs & Sheets:

  • Get your metrics from various sources (Google Analytics, Facebook, YouTube, Twitter, AdWords, Bing Ads, Google Webmaster Tools) into spreadsheets and documents
  • Schedule an automatic daily refresh or refresh the data by a click of a button when you need the latest figures
  • Add dynamic charts that update when you refresh your queries
  • Schedule automatic emailing or take advantage of Google’s sharing options to give others access to your reports & dashboards
  • Fast and easy-to-use interface makes it simple to get data

Combine the data fetching and processing power of Supermetrics with the awesome sharing, formatting and data visualization options of Google Drive to take your business reporting to next level.

 

Getting Started

To get started using Supermetrics for Google Drive, click here and install the Google Sheets add-on through the Chrome Store.

On the page the opens, click the blue  button to install.

If you have any problems and need more detailed instructions on getting started, visit the support page.

Features & Pricing

We offer both a free and a paid version of Supermetrics for Google Drive. The table below summarizes the differences between the versions.

When you first install the add-on, you get a free 30 day trial period with all features and data sources.

  Free Pro Super Pro
Data sources
Google Analytics
Google Analytics
Google AdWords
Database
Bing Ads
Google BigQuery
Google Search Console
Facebook Ads
Facebook Insights
MailChimp
Moz
SEMrush
Stripe
Twitter Ads
Yahoo Gemini
YouTube
Google Analytics
Google AdWords
Database
Bing Ads
Google BigQuery
Google Search Console
Facebook Ads
Facebook Insights
MailChimp
Moz
SEMrush
Stripe
Twitter Ads
Yahoo Gemini
YouTube
Adobe Analytics
Adform
DoubleClick Bid Manager
DoubleClick for Advertisers
DoubleClick for Publishers
DoubleClick Search
Simple connectors
Google+
Instagram
LinkedIn
Pinterest
Reddit
Tumblr
Twitter
Vimeo
VKontakte
Google+
Instagram
LinkedIn
Pinterest
Reddit
Tumblr
Twitter
Vimeo
VKontakte
Scheduled refresh  

daily, weekly, monthly

hourly*, daily, weekly, monthly
Scheduled emailing      
Feature for avoiding Google Analytics data sampling      
Max rows per query 100 1,000,000 1,000,000
Queries per day 100 1500 10,000
Other Restrictions on heavy queries    
   
$ 49 /month

Buy now

$ 99 /month

Buy now

For scheduling many refresh & emailing triggers, a paid Google Apps for Work account is recommended ($5/month). This ensures reliable trigger execution.

* Google restricts the processing power of triggers, so we recommend hourly triggers only be used with the most important queries, where daily refreshing is not frequent enough. We can't guarantee hourly refreshing of large numbers of queries.


When you buy Pro, it's associated with the Google account you use with Google Drive. You can still log in to data sources (eg. Google Analytics) with other accounts.

Note that Google also places some limits on the add-on usage. For instance, Google only lets scheduled triggers run for 5 minutes each hour, so if you set your files to refresh hourly, our add-on may not be able to process all queries if there are many of them or they are slow to run.