Google Sheets is the quiet workhorse of small business. It is free, familiar, and flexible. When you connect it to n8n, that humble spreadsheet becomes a live database that can capture leads, trigger messages, and update itself automatically. This guide shows you exactly how to connect the two, even if you have never touched automation before.
Why Google Sheets + n8n Is So Powerful
On its own, a spreadsheet just sits there. Paired with n8n, it becomes the centre of your operations:
- New leads from your website or Telegram bot land in a sheet automatically
- A new row can trigger a welcome message or a follow-up
- Daily totals can be calculated and sent to you without opening the file
- Records can be looked up and updated as customers move through your pipeline
What You Will Need
- A Google account with a spreadsheet ready
- A running n8n instance
- About ten minutes for the one-time connection setup
Step-by-Step: Connecting the Two
Add a Google Sheets Node
In your n8n workflow, click the plus button and search for "Google Sheets". Add the node to your canvas. This is the block that will talk to your spreadsheet.
Create a Credential
The node will ask for a credential. Choose to connect your Google account, sign in, and grant n8n permission to access your sheets. You only do this once; n8n remembers it for all future workflows.
Pick Your Spreadsheet and Sheet
Select the spreadsheet file and the specific tab you want from the dropdowns. n8n reads them directly from your Google Drive.
Choose an Operation
Decide what the node should do: Append a new row, Read existing rows, Update a row, or Look up a value. This is the heart of your automation.
The Four Operations You Will Use Most
- Append, adds a new row. Perfect for saving incoming leads or orders.
- Read, pulls rows out of the sheet so other steps can use the data.
- Update, changes an existing row, for example marking a lead as "contacted".
- Lookup, finds a specific row by a value like phone number or email.
↓
Google Sheets: Append row (name, phone, source)
↓
Telegram: Send "Thanks, we will reply soon"
💡 Tip: Keep your column headers clean and consistent (name, phone, source, date). n8n maps data to these headers, so tidy headers make every workflow easier to build.
A Common First Project
The most popular starter workflow is a lead sheet: a form or bot collects a name and phone number, n8n appends it as a new row, and you get a notification. From there you can grow, add a follow-up message two days later, or a weekly summary of all new leads.
Frequently Asked Questions
Is my data safe?
Your sheet stays in your own Google account. n8n only accesses what you grant it, and with self-hosted n8n the connection runs on your own server.
How many rows can it handle?
For typical small-business use, Google Sheets handles thousands of rows comfortably. If you ever outgrow it, the same workflow can be pointed at a proper database with minimal changes.
Want a Done-For-You Lead Sheet System?
AutoFlowa connects your sheets, bots, and workflows so leads flow in and follow-ups go out automatically, set up within 24 hours.
Get a Free Demo