Google Sheets

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

Connect Zuar Runner to Google Sheets

Steps to create a Google Sheets job in Zuar Runner

Click +Add Job.

Add Job Zuar Runner 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 Zuar Runner.

Google Account Auth

Click Allow to authorize Zuar Runner 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 Zuar Runner job.

  • Type - The destination database for this table. If using Zuar Runner’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.