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. Provide your Spreadsheet ID from Source credentials