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 singer-io 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 (client_id) #

This is the ID setup via the Google Cloud API.

Client Secret (client_secret) #

This is generated when the client ID is created via the Google Cloud API.

Refresh Token (refresh_token) #

This is the token used to generate new access_tokens. It is manually generated by making an API call to the Google Cloud API. See the documentation for more information.

Spreadsheet ID (spreadsheet_id) #

The unique identifier for a spreadsheet.

Start Date (start_date) #

The absolute minimum start date to check if a file was modified.

User Agent (user_agent) #

  • Default: tap-google-sheets via Meltano

Used to identify the tap in the Google Remote API logs.

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!