Open navigation

How to use Supermetrics report templates in Google Sheets

Our team has created a gallery of ready-made free report templates for you to use in Google Sheets. If you'd like to add a template to your reporting, follow the steps below.


  1. Open the Supermetrics sidebar in Google Sheets.
  2. Scroll down, and click Template gallery.
  3. Browse our available templates. Click Preview to open a preview of any template in a new browser tab.
  4. After you've found the template you want to use, select it and click Insert.
  5. Select the connection and accounts to use with the template, and click Get my data.
  6. To refresh the queries with your data, select a Supermetrics team to use for the refresh.

Once the template’s in place, you can modify any queries you want to adjust. Some of the templates include advanced query setups — contact our support team if you need advice on making adjustments or getting the right results.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.