Creating a spreadsheet from a template

Learn how to create a spreadsheet based on the template for the Google Sheets data importer.

Templates help you quickly create a spreadsheet with a specific structure, such as a website analytics report or a marketing budget.

Templates are also a great way to explore our integrations. All of our integrations come with their own specific functions that you might want to learn eventually. But if you use our templates, these functions are already set up for you.

Let’s practice with the Google Sheets template.

Creating a spreadsheet from the Google Sheets Template

We’re going to show you how to create a spreadsheet that is based on a template for the Google Sheets data importer.

This template comes preconfigured with functions from the Google Sheets integration such as GET_CELLS_GOOGLE_SHEETS.

You can use this template to easily import data from Google Sheets.

Creating a spreadsheet from a template

To create a spreadsheet from the Google Sheets template, follow these steps:

  1. Go to your dashboard.
  2. In the top right corner, click Templates.
  3. In the left-hand navigation menu, select the category Internal Tools.
  4. Click the Google Sheets Data Importer panel.
  5. Click Use Template (and then again in the confirmation window).

    Rows then creates a new spreadsheet with the name of the template.

✳️ And that’s it! You’ve just created a spreadsheet from a template! However, you probably noticed the warning “Google Sheets integration is needed for this spreadsheet”. Let’s look at this issue in more detail and learn how to resolve it.

Authorizing Rows to access your spreadsheets in Google Sheets

Many of our integrations need to access data in third-party applications such as Google, Twitter, or Salesforce. However, you first need to authorize Rows to access that data.

In our Google Sheets example, that data happens to be spreadsheets in Google Sheets. So, let’s now give Rows the access it needs.

Authorizing Rows to access Google Sheets

To authorize Rows to access your spreadsheets in Google Sheets, follow these steps:

  1. Click the underlined link in the warning Google Sheets integration link .
  2. In the Google Sheets slide-out menu, click Connect.
  3. Choose the account associated with the spreadsheets that you want to import..
  4. Authorize Rows in the next dialog box.
  5. If you still see the warning “Google Sheets integration is needed”, refresh the page.

❇️ And that’s it! Your Google Sheets template is now fully functional. Now, you can learn how to actually use it to import data from your spreadsheets.