Sources - Google Sheets

Description

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.
The Singer Google Sheets tap pulls data out of Google Sheets and delivers data in a standard, JSON-based format.

Supported Replication

Continuous Sync

Authentication Type

OAuth

Collections

Collection Name

Full/
Initial Sync

Incremental/
Continuous Sync

Supports Update

Supports Delete

file_metadata

 

 

spreadsheet_metadata

 

 

 

sheet_metadata

For all sheets Title, URL, Area (max column and row), and Column Metadata

 

 

 

sheets_loaded

Sheet title, load date, number of rows

 

 

 

+ a collection for each sheet

 

 

 

Setting up Google Sheets for ELT & CDC

Overview

ELT & CDC uses the API provided by Google Sheets to sync the data.

Google Sheets API Reference

Requirements

  • You need to authenticate via OAuth2.
  • Sign In and Authenticate.

undefined

  • Provide your Spreadsheet ID from Source credentials