Automatically log form submissions, build sales reports and monitor competitor prices — n8n integration with Google Sheets, step by step. This guide walks UK businesses through connecting n8n to Sheets, building the common workflows and the patterns that scale.
Why integrate n8n with Google Sheets • Setting up the n8n ↔ Google Sheets connection • Building a workflow: form data to sheet • Common automation patterns • UK-specific Google Sheets workflows • Troubleshooting common issues • FAQ
Google Sheets is one of the most versatile tools in the Google ecosystem — and one of the most frequently used nodes in n8n. Spreadsheets serve millions of UK businesses as a simple database, order tracker, customer list, sales ledger or reporting tool. The problem is that manual data entry is tedious, error-prone and slow.
n8n integration with Google Sheets changes that. You can automatically add new rows every time something happens in another system: a customer fills a form, a new order appears in your shop, a recipient clicks a link in an email, a bot scrapes data from an external API. n8n captures the event, extracts relevant data and writes it to a nominated sheet — without your involvement.
Tip: n8n on SmartXHosting runs in a pre-configured Docker container on UK infrastructure. Google Sheets integration works out of the box once credentials are set.
The integration works both ways. n8n can regularly read data from Google Sheets and act on it: send emails to customers with a specific tag, process orders with “To Fulfil” status, generate invoices for rows marked “Approved”. Google Sheets becomes a data-management hub with n8n as the engine that processes it automatically.
Two methods to connect n8n to Google Sheets: Service Account (simpler, recommended for automations without user interaction) or OAuth2 (required when you need access to a specific user’s sheets).
n8n-sheets-bot) and click Create and Continue. Assign role “Editor” for the project.client_email field, looks like [email protected]). Paste it in the sharing field and give Editor permission. Without this step, n8n cannot read or write data to the sheet.If the test returns Success, you’re ready to use the Google Sheets node across all your workflows.
One of the most useful and most-built workflows — automatic logging of contact details or orders to Google Sheets.
{{ $json.name }}, in “Email” enter {{ $json.email }}, in “Date” enter {{ $now.toISO() }} (automatic save date).Every new order from WooCommerce or another ecommerce system is automatically added to the “Orders” sheet with columns: number, customer, product, GBP amount, status, date. When the order status changes (e.g. from “New” to “Shipped”), n8n updates the row in the sheet via “Update Row”. Always current view of all orders, no manual entry.
Workflow runs every Monday at 08:00. Reads data from the sales sheet for the previous week (using “Read Rows” with a date filter). Calculates total GBP, average order value, number of transactions (Code or Set node). Results saved to a “Reports” sheet and emailed to the team. The report writes itself every week.
n8n every hour fetches prices of selected products from competitor websites (HTTP Request + HTML Extract). Data saved to Google Sheets with date/time — creating a history of price changes. When a competitor’s price drops below yours, n8n automatically sends a Slack alert with product and price difference. Whole system runs itself round the clock.
/d/ and /edit).n8n automation for Google Sheets workflows
SmartXHosting n8n runs on UK infrastructure with everything needed for Google Sheets integration — Docker, SSL, reliable network and UK-based support.
See n8n hosting plansQ: Service Account or OAuth2?
A: Service Account for automations that work on specific sheets you control. OAuth2 when you need to access sheets from your users’ Google accounts (less common for business automation).
Q: Do I need a paid Google Workspace account?
A: No — free Gmail/Google accounts work. Paid Workspace gives higher API quotas if you run heavy automation.
Q: Can I use the same service account across multiple sheets?
A: Yes — share each sheet with the service account email. One service account can service hundreds of sheets.
Q: Are there size limits on sheets n8n can work with?
A: Google Sheets has a 10-million-cell limit per sheet. n8n can read/write anywhere in that range, but large operations hit API rate limits. For 100k+ rows, consider a real database.
Q: Can I read only specific cells, not whole rows?
A: Yes — the Google Sheets node has a “Read Range” operation where you specify A1 notation (e.g. B2:D100).
Q: How do I update an existing row rather than append?
A: Use the “Update Row” operation with a key column (e.g. Order ID) to identify which row to update. n8n finds and updates only the matching row.
Q: Can I format cells (colours, fonts) from n8n?
A: Basic write operations do not apply formatting. For styled output, use the Google Sheets API’s batch update endpoint via HTTP Request node with more advanced setup.
Q: Is Google Sheets UK GDPR-appropriate for customer data?
A: Data in Google Sheets is stored on Google’s infrastructure (US/EU depending on account region). For UK GDPR purposes, treat Google as a data processor and ensure a Data Processing Agreement is in place (Google Workspace DPA, available).