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

Alternative variants #

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

Alternative variants are:

Standalone usage #

Install the package using pip: 

pip install git+https://github.com/Matatika/tap-google-sheets.git

For additional instructions, refer to the README in the repository.

Usage with Meltano #

Meltano helps you manage your configuration, incremental replication, and scheduled pipelines.

View the Meltano-specific tap-google-sheets instructions to learn more.

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

Client Secret (oauth_credentials.client_secret) #

Google OAuth Client Secret

Refresh Token (oauth_credentials.refresh_token) #

Google OAuth Refresh Token

Sheet ID (sheet_id) #

Google Sheet ID

Looking for help? #

If you're having trouble getting the tap-google-sheets tap 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!