Google Sheets
Google Sheets is a free, cloud-based spreadsheet software provided by Google. It offers a user-friendly interface and a range of powerful features that allow users to create, edit, and collaborate on spreadsheets online.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | True | |
| History | False | |
| ReSync | True | Table level |
| Templates | False |
π§ Setup Guide - ELT
Step 1 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize to allow Weld to access your Google account using OAuth. You will be redirected to your Google account.
Step 2 - Grant access to Weld
- Click Grant Access to allow Weld to connect to your Google app. When authorization is complete, you will be redirected back to the Weld connections overview.
π§ Setup Guide - Reverse ETL
Google Sheet reverse ETL allows you to sync data on a schedule from your Weld App automatically into a designated Sheet.
Pre-requisites:
- You first must set up a connection to google sheets via OAuth or Service Account
- You must publish your SQL model containing the data that you want to sync to Google Sheets
Step 1 - Begin Configuration
-
Click on the Reverse ETL button in the side bar and click + New on the top right.
-
Select the Google Sheets connector from the drop down menu or else click + Add new connection to authorize the connector
-
Select the file you want to sync to.
-
Select the sheet in that file.
-
Template: You can select either a blank Google Sheet No Template or choose one of our templates.
Connection and Object --> Templates
- No Template: Pushes items as they are
- Source Column Name: Inserts the source's column name at the top of the sheet
Step 2 - Model
- Choose the SQL model that contains the data you would like to send to Google Sheets.
Step 3 - Sync Operation
Choose how you would like to sync your data:
- Insert: Insert new data only - first time syncs all data
- Mirror: Syncs all data every time.
Step 4 - Schedule
Choose how often you would like the sync to run. You can choose to have the sync running on an independent schedule or as part of an orchestration workflow.
Step 5 - Mapping
Map the column from your data model to the column in the sheet. You can map up to 52 columns from A:A to AZ:AZ. ** If you require more than 52 columns please reach out to use via the help button in the app