Google Sheets — Integration

Overview

Use Sheets as a lightweight data source or destination: read rows, validate, and append run outputs with audit-safe links.

Capabilities

• Read/append/update rows with header-aware mapping

• CSV ingest → validate → batch iterator to downstream nodes

• Cell-level validation with error routing and retries

• Service account or OAuth auth modes

1. 1

   Step 1

   Create a Google Cloud project and enable the Sheets API.

   Back to top
2. 2

   Step 2

   In FlowForge → Connections, add **Google Sheets** credentials (OAuth or service account).

   Back to top
3. 3

   Step 3

   Add **Sheets: Read** or **Append** nodes to your flow and select the spreadsheet & range.

   Back to top
4. 4

   Step 4

   Map columns to fields using the Mapper; save and run a sample.

   Back to top

Limitations

• API quotas and per-minute write limits apply; enable batching for large updates.

• Very large sheets are better exported to object storage and processed via the CSV iterator.

FAQs

Pricing