With Supermetrics for Google Docs, you can build online dashboards combining data from social media, web analytics and online marketing platforms. Unlike other online dashboarding tools in the market, the data processing happens inside Google spreadsheets, so you have complete control over everything: you can fetch exactly the data you want and add your own calculations and charts. With the latest update, we have now made this tool even better by adding the feature that you have most asked for.

Screen Shot 2014-10-21 at 15.52.37
Screen Shot 2014-10-21 at 16.03.18We’re happy to announce that you can now set up triggers that automatically refresh your Supermetrics queries and email the results. This means you can now

  • Ensure your results are always up-to-date by scheduling a daily refresh of queries. You no longer need to open the file and click the refresh button.
  • Share your results by scheduled email, so it’s simple to share with people who don’t use Google Docs.

We’ve put a lot of effort into making it simple to set up triggers. You can do so in just four quick steps:

  1. Click ‘Schedule refresh & emailing’ in the Supermetrics sidebar or the Add-ons menu, to launch the trigger window.
  2. Select the trigger type: daily refresh, or daily/weekly/monthly emailing.
  3. Type a destination email (if it’s an email trigger).
  4. Press ‘Store trigger’

You can also select whether to email all worksheets or just one, whether to email the results as a PDF attachment or as an HTML table in the message body, and you can modify the details of the email message like sender name and the subject. For each file, you can set up multiple triggers. Once you’ve set up a trigger, it will start running every day at around midnight GMT. If your trigger is a weekly or monthly one, it will be processed on the day of week or month you select when setting up the trigger.

Triggers are available now in both the Google Sheets and Google Docs versions of our add-on. We’d love to get your feedback on this and hear if there’s something we can improve!

 

 

Get started with Supermetrics.

#1 reporting automation tool for PPC, SEO, social and web analytics.
 Free trial with full features. No credit card required.

Start Free Trial

Share This