Google Sheets dataset

Connect a Google Sheets table to Shared Email Templates for Gmail as a dataset: make it a named range, share it with your team, pick it in the web app.

Before you start

  • Turn the table into a named range: select it in Google Sheets and go to Data › Named ranges.
  • If a team template uses the dataset, share the spreadsheet with your teammates.

Connect a Google Sheets table

  1. 1.

    Right-click any folder in the pane and choose New Dataset.

    Create a new dataset in Shared Email Templates for Gmail.
  2. 2.

    In the web app, name the dataset and select Google Sheets Table.

    Connect your existing Google Sheets file.
  3. 3.

    Confirm your Google account and grant access.

  4. 4.

    Pick the spreadsheet in Google Drive and click Select.

    Select a Google spreadsheet.
  5. 5.

    Choose the named range, click OK, then save the dataset.

    Select a Google Sheets table.

See also