Automate Email Outreach: Connecting Airtable to Gmail via n8n (Free JSON Template)

Managing cold email outreach manually is time-consuming and prone to human error. By connecting Airtable (your CRM database) with Gmail using n8n, you can automate your entire email sequence, personalize messages dynamically, and update prospect statuses automatically without paying for expensive SaaS outreach tools.

In this comprehensive guide, we will walk you through building a high-converting, automated email outreach system using n8n. We also provide a free downloadable JSON template so you can deploy this workflow in minutes.

Watch the video breakdown by Matt Geer, or follow our detailed step-by-step blueprint below.

Prerequisites

An active Airtable account with a base containing prospect leads (First Name, Email, Status, Company).
A running n8n instance (Self-Hosted Docker or Cloud).
A Gmail / Google Workspace account with OAuth2 API access enabled in Google Cloud Console.

Workflow Architecture Overview

The automated pipeline works sequentially across four core stages:

Airtable Trigger / Search Node: Fetches leads from your base where the status is set to "Ready to Send".
Dynamic Formatter: Replaces template placeholders (e.g., {{ $json.FirstName }}, {{ $json.Company }}) with actual lead information.
Gmail OAuth2 Node: Sends individual personalized emails directly through your Gmail account.
Airtable Update Node: Changes the prospect status to "Sent" and records the timestamp to prevent sending duplicate emails.

Step 1: Setting Up Your Airtable Base Structure

Ensure your Airtable table includes the following mandatory columns before configuring n8n:

Column Name	Field Type	Description
Email	Email	Recipient email address
First Name	Single Line Text	Lead's first name for personalization
Status	Single Select	Values: `Ready to Send`, `Sent`, `Failed`

Step 2: Configuring Gmail OAuth2 Credentials in n8n

Pro Tip: Protecting Gmail Sender Reputation

When automating cold outreach via Gmail, keep daily volume under 50 emails per day for fresh accounts, and introduce a random delay (e.g., 60–180 seconds) between emails using n8n's Wait Node to avoid spam filters.

Step 3: Download the Free n8n JSON Template

Copy and import this pre-configured workflow JSON directly into your n8n canvas:

{
  "nodes": [
    {
      "parameters": {
        "operation": "search",
        "base": "YOUR_AIRTABLE_BASE_ID",
        "table": "Leads",
        "filterByFormula": "{Status} = 'Ready to Send'"
      },
      "name": "Fetch Leads from Airtable",
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 1,
      "position": [250, 300]
    },
    {
      "parameters": {
        "sendTo": "={{ $json.fields.Email }}",
        "subject": "=Quick question regarding {{ $json.fields.Company }}",
        "message": "=Hi {{ $json.fields['First Name'] }},\n\nI noticed your work at {{ $json.fields.Company }} and wanted to reach out...\n\nBest regards,\nYour Name"
      },
      "name": "Send Email via Gmail",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [500, 300]
    },
    {
      "parameters": {
        "operation": "update",
        "base": "YOUR_AIRTABLE_BASE_ID",
        "table": "Leads",
        "id": "={{ $json.id }}",
        "fields": {
          "Status": "Sent"
        }
      },
      "name": "Update Status to Sent",
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 1,
      "position": [750, 300]
    }
  ],
  "connections": {
    "Fetch Leads from Airtable": {
      "main": [
        [
          { "node": "Send Email via Gmail", "type": "main", "index": 0 }
        ]
      ]
    },
    "Send Email via Gmail": {
      "main": [
        [
          { "node": "Update Status to Sent", "type": "main", "index": 0 }
        ]
      ]
    }
  }
}

Copy the JSON snippet above and paste it into your n8n workflow canvas using Ctrl + V (or Cmd + V).

Troubleshooting Common Issues

Airtable 429 Rate Limit Errors: Add a Wait Node set to 200ms if processing hundreds of records at once.
Gmail OAuth Refresh Token Expiry: Make sure your Google Cloud Project publishing status is set to In Production so refresh tokens don't expire after 7 days.

PromtLogic