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 default singer-io variant, which is recommended for new users.

Alternative variants are:

Standalone usage

Install the package using pip: 

pip install tap-google-sheets

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

Usage with Meltano

Install Meltano, create your Meltano project, and add the tap to your project as an extractor: 

meltano add extractor tap-google-sheets

For additional instructions, refer to the Meltano-specific documentation for tap-google-sheets.

Capabilities

Settings

Client ID (client_id)

This is the ID setup via the Google Cloud API.

See https://drive.google.com/open?id=1FojlvtLwS0-BzGS37R0jEXtwSHqSiO1Uw-7RKQQO-C4.

Client Secret (client_secret)

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

See https://drive.google.com/open?id=1FojlvtLwS0-BzGS37R0jEXtwSHqSiO1Uw-7RKQQO-C4.

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.

See https://drive.google.com/open?id=1FojlvtLwS0-BzGS37R0jEXtwSHqSiO1Uw-7RKQQO-C4.

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 tap-google-sheets to work by itself or with Meltano, 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! It is also validated against a JSON Schema used for taps and targets.


Edit this page on GitLab!