Google Sheets

​

Prerequisites

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

​

Required fields

​

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.

​

Finding your Sheet ID

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.

​

Related

• Managing connections
• Connections overview