How to use templates for Google Sheets

Two MInute Reports (TMR) a google sheets add-on, is an easy and simple tool to analyze data and create reports in no time. 

And now you no longer need to create a report from scratch, as we have our readymade templates published for quick use. You can now quickly create your reports in a Spreadsheet using our templates for Google Sheets.

Why use our Template?

  1. Easy to Understand
  2. Ready to Use
  3. Predefined & Extensible
  4. Saves Time
  5. Custom Branding
  6. Dynamically change date range 
  7. Better design
  8. Repeatable for multiple Accounts 

Inorder to get all these benefits out of your data, follow the steps below:


The first step is to install our Two Minute Reports add-on. After installing, click “Launch” to open the TMR sidebar, Click “Templates” to open the TMR Template gallery. 

Selecting a Template

To get to the right Template that’s perfect,  you can search through our Templates Gallery and use the filters to shortlist the potential Templates easily. The template thumbnails, titles, categories will give you additional information to make your choice easier. Click on a Template card, to view its full details.

For a better preview of the template, click on view, to get an actual presentation of the template on a spreadsheet. You can also check the description given below the template snapshots, which explains every information about the template. If you have any questions, reviews or feedback about the template, you can give your review and feedback here. 

Accessing the Template

Once you find the right Template, Click on the Use button to start using the Template. The next step is to map your data source with the Template. 

Once mapping of data is completed, your Template is now ready to use. The Template has now been successfully transformed into your Private Google Sheets report.

Customizing the Template

A cool Feature of Templates is, you can customize the Template with your Brand Logo and make the report yours.

After opening the copied spreadsheet, the template dashboard would appear, Click on add-ons → Two Minute Reports→ Launch. After launching, the TMR side bar would appear. You can select, “Run all Queries” to update the Template with new data.

Some templates have the feature of changing the date ranges within the Spreadsheet, for others you can do the same in the queries. To change the date range , click on the date cell and type the date in the date format to get your desired data.

Schedule Refresh

You can also automatically Refresh your data in Google Sheets by Scheduling the Reports. Click here to learn about it.  

And that’s how simple it is to create a Template in Google Sheets.

You can also publish your own Templates to our Templates Gallery to showcase your brand and expertise with fellow users. We hope you liked this Tutorial on how to use Templates for Google Sheets on TMR. If you have any questions please feel free to comment below or contact our Support Team. 

Was this helpful?