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+

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:

The settings for tap tap-google-sheets that are known to Meltano 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!