Skip to main content

​
Prerequisites

  • A Google Sheet you want to sync.
  • A datasource already configured in Mora.

​
Required fields

FieldDescriptionExample
NameA display name for this connection.Marketing budget sheet
SchemaThe schema name where the table will be created. Letters and underscores only.google_sheets
TableThe table name for the synced data. Letters and underscores only.budget
Sheet IDThe ID of your Google Sheet (from the URL).1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms
Named rangeThe named range within the sheet to sync.BudgetData

​
Steps

  1. Open Settings → Connections → New.
  2. Select Google Sheets.
  3. Fill in the fields above.
  4. Share your Google Sheet with the service account email displayed in the form. Click the email to copy it, then go to your Google Sheet, click Share, and paste the email as a viewer.
  5. Click Authenticate.
The service account email is shown in the connection form. You must share the sheet with this email address before the sync can access your data.

​
Finding your Sheet ID

The Sheet ID is the long string in your Google Sheets URL between /d/ and /edit: 
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit
                                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
                                       This is the Sheet ID

​
Creating a named range

  1. In Google Sheets, select the cells you want to sync.
  2. Go to Data → Named ranges.
  3. Give it a name (e.g. BudgetData) and click Done.