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 #

Using the Command Line Interface #

  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:

These and other supported settings 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!