Google Sheets - Service account

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 nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataTrue
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

πŸ”§ Setup Guide

  1. Click β€œConnect”, and select the newly created connection.
  2. On the connector details on the left there is a β€œService Account Email” field, make sure to paste the correct email.
  3. Share any sheets you want to have access to with this Email.

Avoid creating many instances of a service account connector, try reusing them whenever possible (this is due to a limited number of Email accounts Google allows to be created).

πŸ”§ 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:

  1. You first must set up a connection to google sheets via OAuth or Service Account
  2. You must publish your SQL model containing the data that you want to sync to Google Sheets

Step 1 - Destination

  1. Click on the Reverse ETL item in the sidebar to navigate to the page.
  2. If this is your first reverse ETL sync the setup guide will automatically start. Otherwise click "Add Reverse ETL Sync" button to start the setup guide.
  3. Find the Google Sheets Service Account connector from the list of destinations and choose an existing connection, if any, or click to create a new connection which you will need to authorize.

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 - Target Details

Configure Spreadsheet details

  • Spreadsheet: Select spreadsheet, e.g. the name of your Google Sheet
  • Sheet: Select sheet where data should be written
  • Template: select either a blank Google Sheet No Template or choose one of our templates.\
  • Parameters: Timezone: You can specify the timezone context when writing data to Google Sheets
  • Activate Google Sheets data types integration: convert data types into appropriate ones

Step 3 - Map Data

  1. Select the source data model that you would like to sync to Google Sheets Service Account. This can be a table or a view from your data warehouse.
  2. Select the destination object sheet.

Sync mode

  • Insert: Insert new data only - first time syncs all data
  • Mirror: Syncs all data every time.

Field Mapping

Field 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

Step 4 - Schedule Sync

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.

  • Independent: The sync will run on its own schedule, independent of other syncs.
  • Orchestration: The sync will be part of an orchestration workflow, allowing you to run it in conjunction with other tasks.

Step 5 - Finalise and run

After you have configured the sync, click on Start Sync to finalize the setup. The sync will perform the initial run immediately.

Was this page helpful?