How to Connect Google Sheets to n8n: Read, Add and Update Rows

Google Sheets is the most common starting point for n8n workflows because most people already use spreadsheets.

Connecting your account

In the Google Sheets node, create a credential and sign in with Google. For a self-hosted n8n you may need to create your own OAuth app in Google Cloud and add the redirect address shown by n8n. Cloud users usually have a simpler sign-in.

Common operations

Read rows: fetch data to process.
Append row: add new data at the bottom.
Update row: change an existing row, matched by a column such as an ID or email.
Append or update: add if missing, update if found, which helps avoid duplicates.

Good sheet habits

Use a header row with simple names, avoid merged cells, and keep one record per row. Add a status column such as “processed” so you know what the workflow already handled.

Common errors

Permission denied: the connected Google account cannot access that sheet.
Wrong column: header names changed.
Quota errors: too many requests too fast; slow down with batches (looping).

Example

A form entry is added to a sheet, and a follow-up reminder is sent two days later: see lead follow-up automation.

Quick answers

Why do I get a permission error?

The connected Google account may not have access to that sheet.

How do I avoid duplicate rows?

Use append or update matched on a unique column.

Do I need my own Google OAuth app?

On self-hosted n8n you usually do; Cloud often simplifies sign-in.