Meta: Connect Gmail to Google Sheets with n8n in 20 minutes — free. Trigger, parse, dedupe, append: the four nodes that replace hours of manual lead entry.
n8n Gmail to Google Sheets — the beginner guide
n8n is the open-source automation tool that connects Gmail to Google Sheets for free — no Zapier subscription, no code. If you've ever wanted "every important email automatically becomes a spreadsheet row," this is the 20-minute guide.
What you're building
A workflow that watches a Gmail label, and when a new email lands there, adds a row to a Google Sheet. Four nodes:
Gmail trigger → Code (parse) → Dedupe → Sheets (append)
Step 1 — the Gmail side (3 min)
- Create a label: Gmail → Settings → Labels → New label →
leads. - Create a filter pointing matching mail at it (
subject:(quote OR project OR inquiry)→ Apply label, Skip Inbox).
Step 2 — the sheet (3 min)
Headers in row 1: lead_id | received_at | contact | email | subject | status. Share it so your automation account can write (Editor).
Step 3 — n8n (12 min)
- Create a free n8n account (cloud) or run it locally (Docker, open source — free either way).
- New workflow → import the file or add nodes manually:
- Gmail Trigger: add your Google credential; set the label to
leads. - Code node: extract sender name/email and a stable ID from the message.
- Dedupe: key on that ID — this is what stops double rows when Gmail re-polls the same thread.
- Google Sheets: bind the spreadsheet; operation *Append*; auto-map columns.
- Connect in order, activate, and email yourself a test. The row appears within one poll cycle.
Common beginner mistakes
- No dedupe → duplicates every time Gmail re-delivers a thread. The dedupe node is not optional.
- Wrong credential scope → Google shows "access not granted"; re-run the OAuth consent and allow Gmail + Sheets.
- Testing with real mail → use a second address and the label filter, not your whole inbox.
What to build next
Once rows flow, the natural upgrade is the follow-up: *wait 3 days → send email #1 → wait → email #2 → stop when the client replies*. That's exactly what the Follow-Up Autopilot pack contains ($39 one-time, free tiers to run) — the importable workflow plus templates, so you skip the trial-and-error.
n8n's free tier is generous (thousands of runs/month); at freelancer volume you will not hit it. The only real cost is the 20 minutes — which this guide just removed.