The target-gsheet Meltano loader sends data into Google Sheets after it was pulled from a source using an extractor.

Alternative variants #

Multiple variants of target-gsheet are available. This document describes the default singer-io variant, which is recommended for new users.

Alternative variants are:

Getting Started #

Prerequisites #

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project
  3. Add an extractor to pull data from a source

Installation and configuration #

  1. Add the target-gsheet loader to your project using meltano add :

    meltano add loader target-gsheet
  2. Configure the settings below using meltano config .

Next steps #

Follow the remaining steps of the Getting Started guide:

  1. Run a data integration (EL) pipeline
If you run into any issues, learn how to get help.

Capabilities #

Settings #

target-gsheet requires the configuration of the following settings:

The settings for loader target-gsheet 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.

Spreadsheet ID (spreadsheet_id) #

The unique identifier for a spreadsheet.

How to use #

Manage this setting using meltano config or an environment variable:

meltano config target-gsheet set spreadsheet_id <spreadsheet_id>

export TARGET_GSHEET_SPREADSHEET_ID=<spreadsheet_id>

Looking for help? #

If you're having trouble getting the target-gsheet loader 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!