n8n Google Sheets Integration: Automate Your Spreadsheet Workflows

Google Sheets is the default database for most Bangladesh small businesses. Order lists, inventory records, customer contacts, payment logs — they all live in spreadsheets. The problem is that getting data into those sheets, and acting on changes in those sheets, is almost always done manually.

n8n's Google Sheets integration is one of the most immediately useful connections you can set up. This guide covers the key workflows: reading from sheets to trigger automations, writing to sheets from other tools, and acting on new rows or changes.

Setting Up Google Sheets Authentication

n8n connects to Google Sheets via Google's OAuth API. You'll need to set up credentials once, and then all your Google Sheets nodes will share them.

In n8n, go to Settings > Credentials > New Credential > Google Sheets OAuth2 API. n8n will walk you through the OAuth flow — you'll be redirected to Google to grant permission. Grant access to your Google account, and the credential is saved.

If you're running n8n on a self-hosted server (not on localhost), you'll need to create a Google Cloud project and OAuth credentials first:

1. Go to console.cloud.google.com and create a project
2. Enable the Google Sheets API for that project
3. Create OAuth 2.0 credentials (Web application type)
4. Add your n8n callback URL as an authorized redirect URI: https://your-n8n.domain.com/rest/oauth2-credential/callback
5. Use the Client ID and Client Secret in n8n's Google Sheets credential

This one-time setup unlocks not just Google Sheets but also Gmail, Google Drive, Google Calendar, and other Google services — all with the same credential.

Workflow 1: New Sheet Row Triggers an Action

The most common use case: someone adds a row to your Google Sheet (a new order, a new contact, a new task) and n8n automatically does something in response.

Trigger: Google Sheets Trigger node → "Row Added" event

Configure it by selecting your spreadsheet and the specific sheet tab to watch. n8n polls the sheet on a schedule (every minute by default, configurable) and fires when it detects a new row.

Example workflow: Your sales team adds customer inquiries to a "Leads" sheet with columns: Name, Phone, Email, Product Interest, Date. When a new row appears:

1. Send a WhatsApp message to the customer: "Hello [Name], thank you for your interest in [Product]. We'll contact you within 2 hours."
2. Send a Telegram notification to the sales team: "New lead: [Name] is interested in [Product]. Phone: [Phone]"
3. Create a task in your project management tool (Trello, Notion, Asana)
4. Add the contact to your email marketing list

This triggers within 1 minute of the row being added. Compare this to the previous workflow: customer submits inquiry → sales person sees it eventually → manually sends reply → manually creates task. The automated version is consistently faster and nothing falls through the cracks.

Workflow 2: Write Data to Sheets from Any Source

Any event in any connected app can write to Google Sheets. A few examples:

WooCommerce Orders → Sheet

Trigger: WooCommerce new order Action: Append row to "Orders" sheet with order ID, customer name, phone, items, total BDT, payment method, order date

This gives you a running log of all orders in a format your team can filter, sort, and analyze without needing access to your WooCommerce dashboard. Very useful for daily sales reviews.

Form Submissions → Sheet

If you're using any form tool — Typeform, Google Forms, your own HTML form with a webhook — n8n can capture submissions and append them to a sheet. More usefully, n8n can add computed columns that raw form tools can't — like "total order value" calculated from quantity × price, or "estimated delivery date" calculated from the order date.

API Data → Sheet (Automated Reports)

Use a Schedule trigger to run daily and pull data from various APIs, then write the results to a reporting sheet. Example: every morning at 7 AM, pull yesterday's sales from WooCommerce, yesterday's ad spend from Facebook Ads, and yesterday's page views from Google Analytics. Write all three to a daily summary row. Build your P&L dashboard in Sheets with this data feeding in automatically.

Workflow 3: Update Existing Sheet Rows

Writing new rows is easy. Updating existing rows requires finding the right row first. n8n's Google Sheets node has a "Update Row" operation that can find a row by a lookup value in a specific column.

Example: Your delivery team updates order status in your delivery management system. n8n catches the status change, looks up the order ID in your Orders sheet, and updates the "Status" column for that row from "Processing" to "Delivered".

The node configuration:

• Operation: Update Row
• Sheet: Orders
• Column to search: Order ID
• Value to search for: {{ $json.order_id }}
• Columns to update: Status → {{ $json.new_status }}, Updated At → {{ $now }}

Workflow 4: Sheet-Based Approval Flows

A practical workflow for Bangladesh businesses that still use spreadsheets for approvals (expense reports, leave requests, purchase orders): when a manager changes a "Status" cell from "Pending" to "Approved" or "Rejected", n8n triggers the appropriate next action.

Since Google Sheets doesn't have native row-update webhooks (only new row detection), this is typically implemented by having the manager use a Google Form that writes back to the sheet — or by using a Sheets Apps Script trigger that calls your n8n webhook when a cell changes. The Apps Script approach requires a bit of setup but gives real-time triggers.

Alternatively, build the approval UI inside n8n itself using n8n's Form node — managers open a link, select Approve/Reject, and n8n handles both the sheet update and the downstream actions.

Workflow 5: Scheduled Sheet Cleanup and Reporting

Google Sheets accumulates data. Old rows need archiving, duplicate entries need flagging, and periodic reports need generating. n8n can do all of this on a schedule.

Weekly cleanup workflow (runs every Sunday at midnight):

1. Read all rows from "Orders" sheet where Status = "Delivered" and Date is older than 90 days
2. Append these rows to an "Orders Archive" sheet
3. Delete the archived rows from the main "Orders" sheet

This keeps your main sheet fast and clean while preserving historical data.

Monthly sales report:

1. Read all rows from Orders sheet for the previous month
2. Calculate: total orders, total revenue BDT, top 5 products, average order value
3. Write summary to a "Monthly Reports" sheet
4. Send email with the summary figures to the business owner

Common Issues and Solutions

n8n not detecting new rows

The Google Sheets Trigger polls on a schedule. If rows are added between polls, they'll be detected on the next poll. For more immediate detection, use a Google Apps Script to push changes to an n8n webhook instead of relying on polling.

Rate limits

Google Sheets API has rate limits: 300 requests per minute per project. If you're reading/writing very frequently, add a Wait node between operations or implement batching using n8n's Batch node to process multiple rows in fewer API calls.

Handling empty cells

Google Sheets returns empty cells differently depending on the node operation. Use n8n's Set node to provide default values: {{ $json.phone || 'no phone' }}.

Running Your Sheet Automations Reliably

Scheduled sheet workflows and polling triggers need to run continuously. On a well-configured server, this is seamless. On an unstable or shared hosting environment, missed polls and downtime cause data gaps.

SNBD HOST's n8n hosting plans include process monitoring that restarts n8n automatically if it crashes, plus BDIX connectivity for fast, reliable access. Starting from ৳499/month, it's the most cost-effective way to run always-on sheet automations in Bangladesh.

If you're building a more complex data pipeline that connects sheets to a database, check out our OpenClaw hosting for a full application stack that pairs well with n8n's data movement capabilities.