This documentation describes a release under development. Documentation for the latest release, 3.6.2, can be found here.

Google Sheets

The Google Sheets plugin enables Mitto to pipe data from Google Sheets and store the data in a database.

Connect Mitto to Google Sheets

Steps to create a Google Sheets job in Mitto

Click +Add Job.

Add Job Mitto Button

Choose Google Sheets.

Google Sheets job

The Google Sheets plugin uses Google for authorization.

Authorize Google account

Click Next.

Google Account

Choose the Google account you want to use with Mitto.

Google Account Auth

Click Allow to authorize Mitto to connect to your Google Sheets.

Select Google Sheet

Select a Google sheet and click Next.

Select Sheet

Select the Sheet Tab from the Google Sheet.

If you only want to pull specific cells in a tab in a Google Sheet, click Advanced.

Select Range Advanced

Fill in the Range. Documentation from Google Sheets on A1 notation here .

Click Next.

Google Sheet Data Types

This part of the Google Sheets plugin wizard allows you to adjust field names and data types. Typically you will just be clicking through this page and leaving everything as is.

Click Next.

Fill in the Specify the output form.

Output screen

  • Title - The title of the resulting Mitto job.

  • Type - The destination database for this table. If using Mitto’s PostgreSQL database, leave this as Local Database

  • Schema - The database schema the table will be created in.

  • Table- The database table the job will be creating.

Click Save.