How to Connect n8n to Google Sheets: The Complete Integration Guide (2025)
Google Sheets is the unofficial database of small business. Connecting it to n8n turns a humble spreadsheet into the hub of powerful automations. Here’s exactly how to wire it up and what to build first.
Two ways to authenticate
OAuth2 is fastest for personal use — click, authorize, done. Service account is better for production: create one in Google Cloud, share the target sheet with its email, and your workflows keep running without a human re-authorizing tokens.
Reading data from a sheet
The Google Sheets node can return all rows or a filtered range. Combine it with a Schedule trigger to process new rows on an interval, or use it as a lookup table mid-workflow.
Writing and updating rows
Use Append to log events, Update to modify existing records by a key column, and Upsert to do both intelligently. This trio covers almost every spreadsheet automation you’ll ever need.
A perfect real-world example
This template watches a Google Sheet of leads and auto-imports each new row into Pipedrive as a deal — bulk lead loading with zero copy-paste. A great first Sheets workflow.
Triggering on new rows
For near-real-time automation, poll the sheet on a short schedule and track the last processed row, or push changes via an Apps Script webhook into n8n for instant triggers.
Common pitfalls
- Forgot to share the sheet with the service account email — the #1 cause of permission errors.
- Header row mismatches — keep column names stable so field mapping doesn’t break.
- Rate limits on huge sheets — batch your reads and writes.
What to build first
Start with a logging workflow (append every form submission or sale to a sheet), then graduate to two-way sync between Sheets and your CRM. From there the possibilities are endless.
Ready to automate?
Don’t build this from scratch. The Google Sheets → Pipedrive Lead Import template gives you a production-ready n8n workflow you can import, connect your accounts, and run in minutes.
