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 - Begin Configuration

  1. Click on the Reverse ETL button in the side bar and click + New on the top right.

  2. Select the Google Sheets connector from the drop down menu or else click + Add new connection to authorize the connector

  3. Select the file you want to sync to.

  4. Select the sheet in that file.

  5. 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

  1. Choose the SQL model that contains the data that 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

Was this page helpful?