Skip to main content
Google Sheets stores tabular data in spreadsheets. MantrixFlow connects using a service account with Viewer access to the spreadsheet. Each sheet tab becomes a separate stream.

​
Prerequisites

You need a Google Cloud project with the Google Sheets API and Google Drive API enabled. Create a service account and share the spreadsheet with the service account email.

​
Connection Setup

1

​
1. Create a Service Account

In Google Cloud Console, create a service account. Enable the Google Sheets API and Google Drive API for the project.
2

​
2. Share the Spreadsheet

Open the Google Sheet. Click Share. Add the service account email (e.g. mantrixflow@project.iam.gserviceaccount.com) with Viewer access.
3

​
3. Spreadsheet ID

Find the spreadsheet ID in the URL. Format: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit. The ID is the long string between /d/ and /edit.
4

​
4. Paste Credentials

Download the JSON key for the service account. Paste the JSON contents into the credentials field in MantrixFlow.

​
Available Streams

Each sheet tab within the spreadsheet becomes a separate stream. The first row is used as headers.

​
Supported Sync Modes

  • Full sync — Reads all rows on every run.