Fetch from Google Sheets

Fetch from Google Sheets pulls one or more Google Sheets into your Multi FileFeed (MFF), converting each selected sheet into a CSV file. Use it as a starting point for workflows that source data directly from spreadsheets your team maintains.

Availability: Beta. Requires the WorkflowsGoogleSheetsFetch feature. Contact your OneSchema support representative if you do not see this transform.

What it does

Input: source (no upstream input). This transform starts an MFF branch by connecting directly to Google Sheets.
Output: one CSV file per selected sheet or tab.
The transform connects to your linked Google account, reads the sheets you select, and emits each as a CSV file for downstream transforms.

When to use it

Your team maintains reference data — like a product catalog or a list of regions — in Google Sheets and you want it in an MFF automatically.
You want to avoid manual CSV exports from Google Sheets before uploading to OneSchema.
You need to combine spreadsheet data with files fetched from other sources, like SFTP or S3, in the same MFF.

How to configure it

In the MFF builder, add a Fetch from Google Sheets node as a source at the start of your MFF.

Settings

Setting	Description	Default
Sheets	The list of Google Sheets (and, optionally, specific tabs) to fetch. Each selected sheet or tab becomes one CSV file.	None selected

Configuration tips

Select individual tabs if a spreadsheet has multiple tabs and you only need specific ones.
If a sheet is renamed or deleted after you configure this node, the run will fail until you update the selection.

Example

Setup

A "Regional Pricing" Google Sheet with two tabs: US Pricing and EU Pricing.

Output

Two CSV files, US Pricing.csv and EU Pricing.csv, each containing the rows from the corresponding tab.

Troubleshooting

"Sheet not found" errors

Confirm the sheet hasn't been renamed, moved, or deleted.
Reconnect your Google account if permissions have changed.

Output CSV is missing rows or columns

Check for frozen rows, merged cells, or hidden columns in the source sheet — these can affect how rows are read.