January 22, 2026

Gmail + Google Sheets, labeled inbox and logged leads

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your inbox is where good opportunities go to die. A new message lands, you skim it, you mean to respond, and then it gets buried under “quick questions” and notifications.

This Gmail leads logging automation hits agency owners and marketing managers hardest, because every missed follow-up costs real revenue. But consultants feel it too when collaboration requests slip through the cracks. The goal is simple: label every new email correctly, prep a reply, and log leads without you touching a thing.

You’ll see how the workflow routes messages into four categories, drafts or sends replies based on the type, and keeps a clean Google Sheets record for the leads you actually want to track.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Gmail + Google Sheets, labeled inbox and logged leads

Click to explore

flowchart LR

    subgraph sg0["Gmail Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Gmail Trigger", pos: "b", h: 48 }
        n1@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n2@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Name Found", pos: "b", h: 48 }
        n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Name Not Found", pos: "b", h: 48 }
        n5@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model1", pos: "b", h: 48 }
        n6@{ icon: "mdi:message-outline", form: "rounded", label: "Label - Agency Lead", pos: "b", h: 48 }
        n7@{ icon: "mdi:message-outline", form: "rounded", label: "Label - Course Request", pos: "b", h: 48 }
        n8@{ icon: "mdi:message-outline", form: "rounded", label: "Label - Paid Collaborations", pos: "b", h: 48 }
        n9@{ icon: "mdi:message-outline", form: "rounded", label: "Label - Miscellaneous", pos: "b", h: 48 }
        n10@{ icon: "mdi:robot", form: "rounded", label: "Message a model", pos: "b", h: 48 }
        n11@{ icon: "mdi:message-outline", form: "rounded", label: "Create a draft", pos: "b", h: 48 }
        n12@{ icon: "mdi:robot", form: "rounded", label: "Name Extractor", pos: "b", h: 48 }
        n13["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Single Intro Line"]
        n14@{ icon: "mdi:swap-vertical", form: "rounded", label: "Reducing content before LLM", pos: "b", h: 48 }
        n15@{ icon: "mdi:robot", form: "rounded", label: "AI-Classification & Sentimen..", pos: "b", h: 48 }
        n16@{ icon: "mdi:message-outline", form: "rounded", label: "Standard Answer", pos: "b", h: 48 }
        n17@{ icon: "mdi:message-outline", form: "rounded", label: "Standard Answer 2", pos: "b", h: 48 }
        n18@{ icon: "mdi:database", form: "rounded", label: "Update DB", pos: "b", h: 48 }
        n1 --> n3
        n1 --> n4
        n3 --> n13
        n0 --> n12
        n12 --> n1
        n4 --> n13
        n10 --> n11
        n2 -.-> n12
        n13 --> n14
        n17 --> n18
        n5 -.-> n15
        n6 --> n10
        n7 --> n16
        n8 --> n17
        n14 --> n15
        n15 --> n6
        n15 --> n7
        n15 --> n8
        n15 --> n9
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n10,n12,n15 ai
    class n2,n5 aiModel
    class n1 decision
    class n18 database
    classDef customIcon fill:none,stroke:none
    class n13 customIcon

The Problem: Your Inbox Isn’t a Lead System

Most inboxes are treated like a to-do list, a CRM, and a ticket queue all at once. That’s where things start breaking. A collaboration email looks like a normal “hello,” so it sits unread. A course inquiry gets a thoughtful reply… three days late. Meanwhile, you are wasting mental energy re-reading the same threads just to remember what you already decided. It’s not the big tasks that hurt. It’s the constant switching, the little decisions, and the slow drip of missed follow-ups that quietly costs you work.

The friction compounds. Here’s where it usually goes wrong.

You label emails when you remember, which means labels stop being trustworthy after about a week.
Hot leads and low-priority messages land in the same place, so you end up reacting instead of prioritizing.
Drafting replies from scratch takes “just a few minutes,” then adds up to about 2 hours a week.
Even if you track leads in a sheet, updating it manually is easy to skip when you’re busy.

The Solution: Classify, Label, Draft, and Log Automatically

This workflow watches for new unread Gmail messages, then handles the boring-but-critical inbox work for you. When a message arrives, it first tries to pull the sender’s name so your replies don’t feel robotic. Next, an AI classifier sorts the email into one of four categories (Agency, Course, Collaboration, or Misc). Based on that category, the workflow applies the right Gmail label immediately. Then it takes the correct action: for “Agency” it prepares a draft reply in Gmail for you to review, for “Course” it can send an auto-reply, and for “Collaboration” it sends a response and logs the lead in Google Sheets. You finish the day with a labeled inbox and a lead list that’s actually current.

The workflow starts with a Gmail trigger that detects unread messages. AI then extracts a name and classifies the topic using a prepared payload that includes your greeting line. Finally, Gmail handles the label plus reply behavior, and Google Sheets gets updated for collaboration leads so your follow-ups don’t rely on memory.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It monitors Gmail for new unread messages and pulls them into the workflow.
It extracts the sender name and builds a greeting line you can reuse.
It classifies each email into four categories and applies the right Gmail label.
It generates a draft reply or sends an auto-reply, then logs collaboration leads into Google Sheets.

Most teams get about 2 hours back each week by not triaging manually.
Your inbox becomes scannable again because labels are consistent, not “best effort.”
Replies go out faster, so leads don’t cool off while you’re in meetings.
Collaboration requests stop disappearing because they’re recorded in Sheets automatically.
You can hand off follow-ups more easily since the info isn’t trapped in one person’s inbox.

Example: What This Looks Like

Say you receive 25 new inbound emails a day. If you spend only 2 minutes each to read, decide a label, and start a reply, that’s about 50 minutes daily, plus the “where did I put that?” time later. With this workflow, the trigger runs instantly, labeling happens in the background, and you only touch what needs a human decision (like reviewing agency drafts). Realistically, you’ll spend maybe 10 minutes a day scanning labeled buckets and approving the few drafts that matter.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Gmail for monitoring, labeling, drafts, and replies
Google Sheets to store collaboration leads centrally
OpenAI API key (get it from your OpenAI dashboard)

Skill level: Beginner. You’ll connect accounts, create four Gmail labels, and paste in label IDs and your sheet details.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

New unread email triggers the workflow. The Gmail trigger watches your inbox and pulls in the message as soon as it arrives, so you’re not relying on periodic manual checks.

A greeting line is built automatically. The workflow extracts a sender name when possible, then chooses either a named greeting or a generic one. Both options merge into a single intro line, so downstream AI always has something clean to work with.

AI classifies the email into the right bucket. A prepared payload is sent to the classifier, which routes the message into Agency, Course, Collaboration, or Misc. That decision controls everything that follows, including which Gmail label gets applied.

Replies and logging happen based on category. Agency emails get an AI-generated draft created inside Gmail for review. Course and collaboration emails can receive auto-replies, and collaboration contacts are appended to Google Sheets so you have a running list of partner opportunities.

You can easily modify the four categories to match your business, or change which categories get drafts versus auto-replies based on your comfort level. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Gmail Trigger

Set up the workflow to watch your inbox for new unread emails and start the automation.

Add and open Gmail Inbox Watcher.
Set Read Status to unread.
Set Poll Times to everyMinute.
Credential Required: Connect your gmailOAuth2 credentials.

Step 2: Connect Gmail and Google Sheets

These nodes write labels, drafts, replies, and lead updates. Ensure all service credentials are connected before continuing.

Credential Required: Connect your gmailOAuth2 credentials to all Gmail action nodes: Apply Agency Label, Apply Course Label, Apply Collaboration Label, Apply Misc Label, Create Gmail Draft, Auto Reply Course, and Auto Reply Collab.
Credential Required: Connect your googleSheetsOAuth2Api credentials to Update Lead Sheet.
In Update Lead Sheet, set Document to [YOUR_ID] and Sheet Name to Sheet1 (gid=0).

⚠️ Common Pitfall: Replace placeholder values like [YOUR_ID], [YOUR_PHONE], and [YOUR_NAME] in Gmail and Sheets nodes before testing.

Step 3: Set Up Sender Extraction and Greeting Logic

This section extracts the sender name and generates the correct intro line for the email response.

In Extract Sender Name, set Text to ={{ $json.text }}.
Open Sender Name Check and ensure the condition checks ={{ $json.output.sender_name }} with the notEmpty operator.
In Set Named Greeting, set intro_line to =Dear {{ $json.output.sender_name }}.
In Set Generic Greeting, set intro_line to =Hey,.
In Merge Intro Line, set Mode to combine, Join Mode to keepNonMatches, and Fields To Match to =intro_line.

OpenAI Chat Engine is connected as the language model for Extract Sender Name — ensure credentials are added to OpenAI Chat Engine, not the extractor node.

Step 4: Set Up LLM Classification

Prepare a clean payload for classification and configure the category model for routing.

In Prepare LLM Payload, map fields: intro_line to ={{ $json.intro_line }}, email_body to ={{ $('Gmail Inbox Watcher').item.json.text }}, message_id to ={{ $('Gmail Inbox Watcher').item.json.id }}, and thread_id to ={{ $('Gmail Inbox Watcher').item.json.threadId }}.
In Classify Email Topic, set Input Text to ={{ $json.email_body }}.
In Classify Email Topic, verify categories: Agency Lead, Course Request, Paid Collaborations, and Miscellaneous with their descriptions.
Credential Required: Connect your openAiApi credentials to OpenAI Classify Engine.

OpenAI Classify Engine is connected as the language model for Classify Email Topic — add credentials to OpenAI Classify Engine, not the classifier node.

Step 5: Configure Labels, Replies, and Drafts

Route messages based on the classification and apply labels, send replies, and create drafts.

In Apply Agency Label, set Operation to addLabels, Message ID to ={{ $json.message_id }}, and Label IDs to [YOUR_ID].
In Apply Course Label, Apply Collaboration Label, and Apply Misc Label, set Operation to addLabels, Message ID to ={{ $json.message_id }}, and Label IDs to [YOUR_ID].
In Generate Draft Reply, keep JSON Output enabled and confirm the prompt references {{ $('Merge Intro Line').item.json.intro_line }}, {{ $('Gmail Inbox Watcher').item.json.text }}, and {{ $('Gmail Inbox Watcher').item.json.subject }}. Credential Required: Connect your openAiApi credentials.
In Create Gmail Draft, set Resource to draft, Message to ={{ $json.message.content.body }}, Subject to ={{ $json.message.content.subject }}, and Thread ID to ={{ $('Apply Agency Label').item.json.threadId }}.
In Auto Reply Course, set Operation to reply, Email Type to text, Message ID to ={{ $json.id }}, and keep the message body with {{ $('Classify Email Topic').item.json.intro_line }}.
In Auto Reply Collab, set Operation to reply, Email Type to text, Message ID to ={{ $json.id }}, and keep the message body with {{ $('Classify Email Topic').item.json.intro_line }}.
In Update Lead Sheet, map columns: Name to ={{ $('Merge Intro Line').item.json.intro_line.replace('Dear ', '') }}, email to ={{ $('Gmail Inbox Watcher').item.json.from.value[0].address }}, and subject to ={{ $('Gmail Inbox Watcher').item.json.subject }}.

⚠️ Common Pitfall: Make sure the Classify Email Topic node is connected to all four label nodes; otherwise, some categories won’t apply labels or responses.

Step 6: Test and Activate Your Workflow

Validate the entire path from email intake to labeling and responses before turning on live automation.

Click Execute Workflow and send a test email to the connected Gmail inbox.
Confirm the workflow extracts a sender name, generates intro_line, and classifies the email in Classify Email Topic.
Verify the correct label node runs (e.g., Apply Agency Label or Apply Course Label), and that a draft or reply is created.
Check Update Lead Sheet for a new or updated row when a collaboration reply is sent.
Toggle the workflow to Active to enable continuous processing.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Gmail credentials can expire or need specific permissions. If things break, check the Gmail connection inside n8n credentials first, then confirm the account still has access to the mailbox you’re watching.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Gmail leads logging automation?

About 10 minutes if your labels and sheet are ready.

Do I need coding skills to automate Gmail leads logging?

No. You’ll connect accounts and paste a few IDs into the config fields.

Is n8n free to use for this Gmail leads logging workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs, which are usually a few cents per day at low volume.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Gmail leads logging workflow for different lead types?

Yes, and it’s one of the best parts. You can rename the four categories and map them to your own Gmail labels by updating the label IDs in the Set – Config area and adjusting the “Classify Email Topic” logic. Common customizations include adding a “Support” category, splitting “Agency” into “New client” vs. “Existing client,” and changing which categories get auto-replies versus drafts.

Why is my Gmail connection failing in this workflow?

Usually it’s expired OAuth permissions or the wrong Gmail account connected. Reconnect Gmail inside n8n credentials, then confirm the trigger is watching the intended mailbox (and that messages are actually arriving as unread). If labels aren’t applying, double-check you pasted the correct label IDs, not just the label names. Also, Gmail can throttle heavy usage, so if you’re processing a big backlog, run smaller batches honestly.

How many emails can this Gmail leads logging automation handle?

Plenty for a typical small team.

Is this Gmail leads logging automation better than using Zapier or Make?

Often, yes, especially once you want branching logic and tighter control over how AI is used. n8n is more flexible when one trigger can go down four different paths (labels, drafts, auto-replies, and Sheets logging), and self-hosting means you’re not paying more just because your inbox got busy. Another advantage is that you can keep the AI prompts and decision logic right next to the Gmail actions, which makes tweaks faster. Zapier or Make can still be a fine choice for very simple labeling, but drafts plus lead logging tends to get messy in “two-step” tools. Talk to an automation expert if you’re not sure which fits.

Once this is running, your inbox stops being a guessing game. The workflow handles the repetitive sorting and prep work so you can focus on the conversations that actually move work forward.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "d107de755f66b09e4485f2881a33576e910c2fa23cc8aa1612f4422302366088",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated Email Classification & Replies",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-7399",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1785,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "1c25bce1-dce3-408f-8c17-f4e2cde60f26",
"name": "Gmail Inbox Watcher",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
0,
145
],
"parameters": {
"simple": false,
"filters": {
"readStatus": "unread"
},
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
}
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "e39fd2c4-76b2-4cb9-816e-b0e146b81be3",
"name": "Sender Name Check",
"type": "n8n-nodes-base.if",
"position": [
485,
130
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "2d7cba78-1e46-4563-9683-2151f4bc3cc6",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.output.sender_name }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "1f9d175e-dd19-4a5e-b4cf-68c67769514e",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
215,
335
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "7547e456-d72e-4bd7-a483-e600026132a1",
"name": "Set Named Greeting",
"type": "n8n-nodes-base.set",
"position": [
760,
120
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "0064bc2e-17b5-4d55-945e-ad61c4a7e796",
"name": "intro_line",
"type": "string",
"value": "=Dear {{ $json.output.sender_name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f5335b2d-2732-47fc-a916-17bd9d40e0da",
"name": "Set Generic Greeting",
"type": "n8n-nodes-base.set",
"position": [
735,
280
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "0064bc2e-17b5-4d55-945e-ad61c4a7e796",
"name": "intro_line",
"type": "string",
"value": "=Hey,"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "53f97b56-7bc6-4f25-b3c7-761fb38d7174",
"name": "OpenAI Classify Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1245,
355
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "2cc7a078-016e-4205-897d-a6c20f23dd52",
"name": "Apply Agency Label",
"type": "n8n-nodes-base.gmail",
"position": [
1480,
415
],
"webhookId": "b9cae76f-27ae-41e6-a806-61de5db8b020",
"parameters": {
"labelIds": [
"[YOUR_ID]"
],
"messageId": "={{ $json.message_id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "af773077-758f-4f64-94b2-658784b8689d",
"name": "Apply Course Label",
"type": "n8n-nodes-base.gmail",
"position": [
1305,
480
],
"webhookId": "b9cae76f-27ae-41e6-a806-61de5db8b020",
"parameters": {
"labelIds": [
"[YOUR_ID]"
],
"messageId": "={{ $json.message_id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "a93709f4-15a0-4333-b9e1-aff10ff6c693",
"name": "Apply Collaboration Label",
"type": "n8n-nodes-base.gmail",
"position": [
1075,
435
],
"webhookId": "b9cae76f-27ae-41e6-a806-61de5db8b020",
"parameters": {
"labelIds": [
"[YOUR_ID]"
],
"messageId": "={{ $json.message_id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "7994e586-a28c-47d6-902f-9389516d13f7",
"name": "Apply Misc Label",
"type": "n8n-nodes-base.gmail",
"position": [
900,
485
],
"webhookId": "b9cae76f-27ae-41e6-a806-61de5db8b020",
"parameters": {
"labelIds": [
"[YOUR_ID]"
],
"messageId": "={{ $json.message_id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "f7c8cc18-f017-4a5d-92e9-c80d16a1269a",
"name": "Generate Draft Reply",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1460,
605
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": [],
"messages": {
"values": [
{
"role": "system",
"content": "You are an intelligent and useful personal assistant that replies to my emails"
},
{
"content": "=Here's the email to reply to:\n\nIntro line for the sender:{{ $('Merge Intro Line').item.json.intro_line }}\nEmail Body: {{ $('Gmail Inbox Watcher').item.json.text }}\nEmail Subject:{{ $('Gmail Inbox Watcher').item.json.subject }}"
},
{
"content": "=Please format the data in this format:\n\n{\n\n\"subject\": \"The subject line fo the email you drafted\"\n\"body\": \"The body of the email you drafted\"\n\n}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "5c4ae3ba-5ab9-46c3-aa20-b43d8c62a1a3",
"name": "Create Gmail Draft",
"type": "n8n-nodes-base.gmail",
"position": [
1685,
590
],
"webhookId": "0c43d685-5746-44ff-ae3a-6b5b356801f1",
"parameters": {
"message": "={{ $json.message.content.body }}",
"options": {
"threadId": "={{ $('Apply Agency Label').item.json.threadId }}"
},
"subject": "={{ $json.message.content.subject }}",
"resource": "draft"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "88e31730-9014-4076-bc2a-71d1dab5ef78",
"name": "Extract Sender Name",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
245,
180
],
"parameters": {
"text": "={{ $json.text }}",
"options": {
"systemPromptTemplate": "=You are an expert extraction algorithm.\nOnly extract relevant information from the text.\nIf you do not know the value of an attribute asked to extract, you may omit the attribute's value."
},
"attributes": {
"attributes": [
{
"name": "sender_name",
"required": true,
"description": "=This is the sender name, which corresponds to the signature of the sender at the end of the body of the email. If the name is not available, return an empty string."
}
]
}
},
"typeVersion": 1.2
},
{
"id": "e97c25b3-84f0-4602-86cc-45652f9a6bf8",
"name": "Merge Intro Line",
"type": "n8n-nodes-base.merge",
"position": [
1005,
195
],
"parameters": {
"mode": "combine",
"options": [],
"joinMode": "keepNonMatches",
"fieldsToMatchString": "=intro_line"
},
"typeVersion": 3.2
},
{
"id": "0568b7a5-017a-4db1-94f1-bf80057db779",
"name": "Prepare LLM Payload",
"type": "n8n-nodes-base.set",
"position": [
1215,
160
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "a5357d59-3a7a-4197-b005-a8fa4acea9c0",
"name": "intro_line",
"type": "string",
"value": "={{ $json.intro_line }}"
},
{
"id": "17c5b46b-77e6-43ab-a314-6a36a21651f8",
"name": "email_body",
"type": "string",
"value": "={{ $('Gmail Inbox Watcher').item.json.text }}"
},
{
"id": "e534b113-0a05-4312-b577-b1918f03b361",
"name": "message_id",
"type": "string",
"value": "={{ $('Gmail Inbox Watcher').item.json.id }}"
},
{
"id": "21ab6542-a5b6-4ca0-9605-4f1c9b27e70d",
"name": "thread_id",
"type": "string",
"value": "={{ $('Gmail Inbox Watcher').item.json.threadId }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9434fc19-bbb8-4778-8e9b-49b7777cac77",
"name": "Classify Email Topic",
"type": "@n8n/n8n-nodes-langchain.textClassifier",
"position": [
1495,
190
],
"parameters": {
"options": [],
"inputText": "={{ $json.email_body }}",
"categories": {
"categories": [
{
"category": "Agency Lead",
"description": "This includes people/companies interested in inquiries regarding AI solutions, may it be asking info on what they can do, or me building a solution for them."
},
{
"category": "Course Request",
"description": "This includes inquiries from people regarding which courses they should choose in order to understand/study AI or AI Agents "
},
{
"category": "Paid Collaborations",
"description": "Inquiries regarding sponsorship of books or tools on my channels. There are also situations in which they don't specifically say that they will pay, but they ask me to share their material with my audience"
},
{
"category": "Miscellaneous",
"description": "All the remaining messages"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "680a89f0-148f-4b91-a63f-a428744ba177",
"name": "Auto Reply Course",
"type": "n8n-nodes-base.gmail",
"position": [
1315,
650
],
"webhookId": "fd82eb8a-6d1c-4509-ab21-1674cb6328d2",
"parameters": {
"message": "={{ $('Classify Email Topic').item.json.intro_line }},\n\nThanks for reaching out.\n\nThis email goes out as soon as I receive a request of a course recommendation.\n\nThis is my phone number: [YOUR_PHONE]\n\nPlease reach out to me there!\n\nThanks,\n[YOUR_NAME]",
"options": [],
"emailType": "text",
"messageId": "={{ $json.id }}",
"operation": "reply"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "bcd48315-4957-4cd1-81e2-97ea4ea1431e",
"name": "Auto Reply Collab",
"type": "n8n-nodes-base.gmail",
"position": [
1085,
650
],
"webhookId": "fd82eb8a-6d1c-4509-ab21-1674cb6328d2",
"parameters": {
"message": "={{ $('Classify Email Topic').item.json.intro_line }},\n\nThanks for reaching out.\n\nThis email goes out as soon as I receive a request of a paid collab.\n\nThis is my phone number: [YOUR_PHONE]\n\nPlease reach out to me there!\n\nThanks,\n[YOUR_NAME]",
"options": [],
"emailType": "text",
"messageId": "={{ $json.id }}",
"operation": "reply"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "39a258ef-64a3-45df-b048-0de048a4825c",
"name": "Update Lead Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
865,
640
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $('Merge Intro Line').item.json.intro_line.replace('Dear ', '') }}",
"email": "={{ $('Gmail Inbox Watcher').item.json.from.value[0].address }}",
"subject": "={{ $('Gmail Inbox Watcher').item.json.subject }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Paid Collaborations"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Sender Name Check": {
"main": [
[
{
"node": "Set Named Greeting",
"type": "main",
"index": 0
}
],
[
{
"node": "Set Generic Greeting",
"type": "main",
"index": 0
}
]
]
},
"Set Named Greeting": {
"main": [
[
{
"node": "Merge Intro Line",
"type": "main",
"index": 0
}
]
]
},
"Gmail Inbox Watcher": {
"main": [
[
{
"node": "Extract Sender Name",
"type": "main",
"index": 0
}
]
]
},
"Extract Sender Name": {
"main": [
[
{
"node": "Sender Name Check",
"type": "main",
"index": 0
}
]
]
},
"Set Generic Greeting": {
"main": [
[
{
"node": "Merge Intro Line",
"type": "main",
"index": 1
}
]
]
},
"Generate Draft Reply": {
"main": [
[
{
"node": "Create Gmail Draft",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "Extract Sender Name",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Merge Intro Line": {
"main": [
[
{
"node": "Prepare LLM Payload",
"type": "main",
"index": 0
}
]
]
},
"Auto Reply Collab": {
"main": [
[
{
"node": "Update Lead Sheet",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Classify Engine": {
"ai_languageModel": [
[
{
"node": "Classify Email Topic",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Apply Agency Label": {
"main": [
[
{
"node": "Generate Draft Reply",
"type": "main",
"index": 0
}
]
]
},
"Apply Course Label": {
"main": [
[
{
"node": "Auto Reply Course",
"type": "main",
"index": 0
}
]
]
},
"Apply Collaboration Label": {
"main": [
[
{
"node": "Auto Reply Collab",
"type": "main",
"index": 0
}
]
]
},
"Prepare LLM Payload": {
"main": [
[
{
"node": "Classify Email Topic",
"type": "main",
"index": 0
}
]
]
},
"Classify Email Topic": {
"main": [
[
{
"node": "Apply Agency Label",
"type": "main",
"index": 0
}
],
[
{
"node": "Apply Course Label",
"type": "main",
"index": 0
}
],
[
{
"node": "Apply Collaboration Label",
"type": "main",
"index": 0
}
],
[
{
"node": "Apply Misc Label",
"type": "main",
"index": 0
}
]
]
}
}
}