Description |
Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. |
Supported Replication |
Continuous Sync |
Authentication Type |
OAuth |
Collections
Collection Name |
Full/ |
Incremental/ |
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.
Requirements
- You need to authenticate via OAuth2.
- Sign In and Authenticate.
- Provide your Spreadsheet ID from Source credentials