The tap-google-sheets Meltano extractor pulls data from Google Sheets that can then be sent to a destination using a loader.

Alternative variants #

Multiple variants of tap-google-sheets are available. This document describes the matatika variant.

Alternative variants are:

Getting Started #

Prerequisites #

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Installation and configuration #

Using the Command Line Interface #

  1. Add the tap-google-sheets extractor to your project using meltano add : 

    meltano add extractor tap-google-sheets --variant matatika
  2. Configure the settings below using meltano config .

Next steps #

Follow the remaining steps of the Getting Started guide:

  1. Select entities and attributes to extract
  2. Add a loader to send data to a destination
  3. Run a data integration (EL) pipeline

If you run into any issues, learn how to get help.

Capabilities #

Settings #

tap-google-sheets requires the configuration of the following settings:

These and other supported settings are documented below. To quickly find the setting you're looking for, use the Table of Contents at the top of the page.

Client ID (oauth_credentials.client_id) #

Google OAuth Client ID

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-google-sheets set oauth_credentials.client_id <oauth_credentials.client_id>

export TAP_GOOGLE_SHEETS_OAUTH_CREDENTIALS.CLIENT_ID=<oauth_credentials.client_id>

Client Secret (oauth_credentials.client_secret) #

Google OAuth Client Secret

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-google-sheets set oauth_credentials.client_secret <oauth_credentials.client_secret>

export TAP_GOOGLE_SHEETS_OAUTH_CREDENTIALS.CLIENT_SECRET=<oauth_credentials.client_secret>

Refresh Token (oauth_credentials.refresh_token) #

Google OAuth Refresh Token

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-google-sheets set oauth_credentials.refresh_token <oauth_credentials.refresh_token>

export TAP_GOOGLE_SHEETS_OAUTH_CREDENTIALS.REFRESH_TOKEN=<oauth_credentials.refresh_token>

Sheet ID (sheet_id) #

Google Sheet ID

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-google-sheets set sheet_id <sheet_id>

export TAP_GOOGLE_SHEETS_SHEET_ID=<sheet_id>

Looking for help? #

If you're having trouble getting the tap-google-sheets extractor to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page? #

This page is generated from a YAML file that you can contribute changes to. Edit it on GitHub!