Google Sheets
Table of Contents
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.