n8n Node Guide: Google Sheets

Description

Storage & Databases node in n8n.

What It Does

Read and write Google Sheets as a data table.

When To Use It

Lightweight databases, reports, shared lists, config tables.

Key Parameters

Operation (append, update, read), Spreadsheet, Sheet, Header Row

Common Mistakes

The first row is treated as headers – keep it clean or mapping breaks.

Example

Webhook -> Google Sheets append -> order log.

FAQ

Is this node included in n8n Community Edition?

Yes – Google Sheets ships with the free Community Edition. No paid license needed.

Use “Update” with a key column to upsert instead of append.?

Where does it fit in a workflow?

Google Sheets works with any other node – connect it after a trigger or data node, and feed its output into the next step. Standard n8n data flow: trigger -> transform -> act.

Is support included?

Yes – message the seller through the store and I will help you wire this node.