January 22, 2026

Gmail + Google Sheets: email opens logged for you

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Sending “personalized” lead emails is already time-consuming. Then the follow-up guessing game starts, because you can’t tell who actually opened anything unless you live inside a pricey CRM.

This Gmail open tracking automation hits sales teams and agency owners first, but a marketing manager running outbound feels it too. You get real open signals logged back into Google Sheets, so follow-ups happen based on intent, not hope.

Below is what the workflow does, what you’ll need, and how to make it fit your lead-nurture process without turning your spreadsheet into a mess.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Gmail + Google Sheets: email opens logged for you

Click to explore

flowchart LR

    subgraph sg0["When clicking ‘Execute workflow’ Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
        n3@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n5@{ icon: "mdi:database", form: "rounded", label: "Get CRM", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-vertical", form: "rounded", label: "Generate Pixel", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Email Agent", pos: "b", h: 48 }
        n8@{ icon: "mdi:message-outline", form: "rounded", label: "Send email", pos: "b", h: 48 }
        n9@{ icon: "mdi:database", form: "rounded", label: "Update CRM", pos: "b", h: 48 }
        n5 --> n4
        n8 --> n9
        n9 --> n4
        n7 --> n8
        n6 --> n7
        n4 --> n6
        n3 -.-> n7
        n0 --> n5
    end

    subgraph sg1["Flow 2"]
        direction LR
        n1["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Webhook"]
        n2["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Respond to Webhook"]
        n10@{ icon: "mdi:swap-vertical", form: "rounded", label: "Create data pixel in base64", pos: "b", h: 48 }
        n11@{ icon: "mdi:cog", form: "rounded", label: "Create pixel image", pos: "b", h: 48 }
        n12@{ icon: "mdi:swap-vertical", form: "rounded", label: "Get vars", pos: "b", h: 48 }
        n13@{ icon: "mdi:database", form: "rounded", label: "Update Open email 1", pos: "b", h: 48 }
        n1 --> n10
        n12 --> n13
        n11 --> n2
        n11 --> n12
        n10 --> n11
    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 n7 ai
    class n3 aiModel
    class n5,n9,n13 database
    class n1,n2 api
    classDef customIcon fill:none,stroke:none
    class n1,n2 customIcon

The Problem: You’re Following Up Blind

If you’re sending leads from a Google Sheet, you probably have a familiar routine: copy an email address, tweak a template, send from Gmail, then try to remember who got what and when. A week later you’re staring at the thread list, wondering who opened, who ignored it, and who’s secretly interested but busy. The worst part is the mental overhead. You end up “checking” instead of doing the next useful thing, and small mistakes (wrong name, missed lead, duplicate follow-up) creep in because the process is fragile.

It adds up fast. Here’s where the friction usually shows up:

You send Email 1, but there’s no reliable open signal, so your follow-up timing is basically a guess.
CRM fields in Sheets go stale because updating “sent,” “date,” and “notes” is the first task everyone skips.
Personalization doesn’t scale, which means your “template” turns into a generic message that gets ignored.
Once you’re juggling 50+ leads, you lose track and accidentally double-send or forget hot replies.

The Solution: Gmail Sends, Google Sheets Updates, Opens Get Logged

This workflow turns Google Sheets into a lightweight outbound CRM, with Gmail doing the sending and a tracking pixel capturing opens. It starts by reading your CRM-like sheet and selecting leads who haven’t received “Email 1” yet. For each lead, n8n generates a unique pixel ID, asks OpenAI to produce a personalized HTML email, and inserts an invisible 1×1 pixel tied to that lead. Then Gmail sends the email, and the sheet is immediately updated with the send flag, send date, and the pixel ID. When a recipient opens the email, their email client loads the pixel image, which triggers your n8n webhook and flips the “OPEN EMAIL 1” field to “yes.”

The workflow starts when you run it (manual trigger for testing, then scheduled if you want). OpenAI generates the email and n8n sends it through Gmail. Finally, the webhook listens for pixel loads and writes open activity back to Google Sheets so your follow-up list stays current.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It pulls “not sent yet” leads directly from your Google Sheets CRM.
It generates a unique tracking pixel token for every recipient.
It uses OpenAI to draft a personalized HTML email that includes the pixel.
It updates your sheet automatically when the email is sent and when it’s opened.

Most teams get about 2 hours back each week once follow-ups stop being manual.
You prioritize follow-ups using real opens, not “sent date” guesswork.
Your Google Sheet stays clean, with consistent fields for send date, pixel ID, and open status.
Personalization becomes repeatable, so outreach stays sharp even as volume grows.
You get a HubSpot-like signal loop without moving your data out of Sheets.

Example: What This Looks Like

Say you add 40 new leads to your Google Sheet each week. Manually, even a “fast” process is about 5 minutes per lead to personalize, send, and update your columns, which is roughly 3 hours. With this workflow, you spend about 10 minutes checking your sheet and starting the run, then n8n does the sending and logging while you work on something else. When opens come in, the sheet updates on its own, so your follow-up list is already sorted by real activity.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for your CRM-style lead table
Gmail to send the HTML email messages
OpenAI API key (get it from your OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, paste a webhook URL into one node, and map a few spreadsheet columns.

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

How It Works

New leads live in Google Sheets. You keep one CRM-like sheet with columns like name, email, “EMAIL 1 SEND,” “PIXEL EMAIL 1,” “EMAIL 1 DATE,” and “OPEN EMAIL 1.” The workflow reads it and targets only rows that haven’t been contacted yet.

Each lead gets a unique pixel token. n8n generates an ID and builds a tiny invisible image URL that points back to your n8n webhook, so opens can be detected when the image loads.

OpenAI drafts the HTML email. The content is personalized (based on your lead fields) and the pixel is inserted into the body so the tracking is automatic. Honestly, this is where most teams win back quality, because the email stays consistent without becoming robotic.

Gmail sends, Sheets gets updated, and opens get logged. After sending, the sheet is updated with the send status, date, and pixel ID. When the webhook receives a pixel request, n8n matches it back to the lead and marks the open field as “yes.”

You can easily modify the sheet fields to match your current CRM columns based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

This workflow starts manually to fetch leads and send pixel-tracked emails.

Add and open Manual Start Trigger to initiate the workflow on demand.
Connect Manual Start Trigger to Fetch CRM Sheet as shown in the execution flow.

Tip: Keep Manual Start Trigger for testing and swap to a schedule trigger later if you want automation.

Step 2: Connect Google Sheets

These nodes load lead records and update send/open status in your CRM sheet.

Open Fetch CRM Sheet and set Document ID to your sheet ID (replace [YOUR_ID]).
Set Sheet Name to gid=0 (the sheet named Foglio1).
In Fetch CRM Sheet, confirm the filter uses EMAIL 1 SEND so only unsent leads are processed.
Open Update CRM Sheet and keep Operation set to update.
Verify Update CRM Sheet mappings include row_number set to {{ $('Fetch CRM Sheet').item.json.row_number }} and EMAIL 1 DATE set to {{$now.format('dd/LL/yyyy')}}.
Open Mark Email Opened and keep Operation as update, with matching column PIXEL EMAIL 1.
Credential Required: Connect your googleSheetsOAuth2Api credentials to Fetch CRM Sheet, Update CRM Sheet, and Mark Email Opened.

⚠️ Common Pitfall: If [YOUR_ID] is not replaced in Fetch CRM Sheet, Update CRM Sheet, and Mark Email Opened, the workflow will fail to read or update rows.

Step 3: Set Up Lead Iteration and Pixel Token Creation

This stage loops through each lead and generates a unique pixel token and webhook URL for tracking.

Open Iterate Records (Split In Batches) and leave default settings to process leads sequentially.
In Create Pixel Token, keep the pixel assignment using the expression {{ Array.from({length: 15}, () => Math.random().toString(36).charAt(2)).join('') + ['!', '@', '#', '$', '%', '&', '*'][Math.floor(Math.random() * 7)] }}.
Set email to email-1 in Create Pixel Token.
Replace webhook_url in Create Pixel Token with your live n8n webhook URL, e.g., https://YOUR_N8N_WEBHOOK_URL.

⚠️ Common Pitfall: If webhook_url does not match your active Incoming Webhook URL, pixel opens will never be tracked.

Step 4: Set Up the AI Email Drafting

The AI agent generates the email body and inserts the tracking pixel HTML.

Open Email Draft Agent and keep Prompt Type set to define.
Confirm the Text field includes the pixel image tag with expressions: <img src="{{ $json.webhook_url }}?pixel={{ $json.pixel }}&email={{ $json.email }}" width="1" height="1" style="display:none;">.
Ensure OpenAI Chat Engine is connected as the language model for Email Draft Agent.
Credential Required: Connect your openAiApi credentials to OpenAI Chat Engine (credentials are added to the parent model node, not the agent).

Step 5: Configure Email Sending and CRM Updates

This stage sends the drafted email and records the send event in your sheet.

Open Dispatch Email and set Send To to {{ $('Fetch CRM Sheet').item.json.EMAIL }}.
Set Message to {{ $json.output }} to use the AI-generated HTML body.
Set Subject to Email 1 in Dispatch Email.
Credential Required: Connect your gmailOAuth2 credentials to Dispatch Email.
In Update CRM Sheet, verify EMAIL 1 SEND is set to {{ $json.id }} and PIXEL EMAIL 1 is set to {{ $('Create Pixel Token').item.json.pixel }}.

Step 6: Configure the Webhook Pixel Tracking

The webhook receives pixel hits, converts the base64 image to binary, and updates the sheet when an open is detected.

Open Incoming Webhook and set Path to e995cbaa-9259-4685-a144-16a700d0a71d.
Set Response Mode to responseNode in Incoming Webhook.
In Build Pixel Base64, keep the data field set to the base64 PNG string provided.
In Convert Pixel File, set Operation to toBinary and Source Property to data; keep mimeType set to image/png.
Convert Pixel File outputs to both Webhook Response Sender and Extract Query Params in parallel.
In Webhook Response Sender, set Respond With to binary to return the pixel image.
In Extract Query Params, map pixel to {{ $('Incoming Webhook').item.json.query.pixel }} and email to {{ $('Incoming Webhook').item.json.query.email }}.
In Mark Email Opened, confirm OPEN EMAIL 1 is set to yes and PIXEL EMAIL 1 is set to {{ $json.pixel }}.

Tip: Make sure your webhook URL in Create Pixel Token matches the live URL generated by Incoming Webhook.

Step 7: Test and Activate Your Workflow

Run a manual test to verify email sends and open tracking before activating the workflow.

Click Execute Workflow and run Manual Start Trigger to send a test email to a row in Fetch CRM Sheet.
Confirm that Dispatch Email sends the message and Update CRM Sheet writes EMAIL 1 SEND, EMAIL 1 DATE, and PIXEL EMAIL 1.
Open the email and ensure the pixel URL is requested; Incoming Webhook should fire and Mark Email Opened should set OPEN EMAIL 1 to yes.
When successful, switch the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials panel and the Google account access prompt first.
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 open tracking automation?

About 30 minutes if your Google accounts are already connected.

Do I need coding skills to automate Gmail open tracking?

No coding required. You’ll mainly map spreadsheet fields and paste your production webhook URL into the pixel generator step.

Is n8n free to use for this Gmail open tracking 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 (usually a few cents per batch of emails, depending on prompt length).

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 open tracking workflow for a multi-step sequence?

Yes, but plan your spreadsheet columns first. Most people duplicate the same pattern (“EMAIL 2 SEND,” “PIXEL EMAIL 2,” “OPEN EMAIL 2”) and reuse the same logic: fetch eligible leads, generate a new pixel token, draft a new email in the Email Draft Agent, then send and update the row. You can also add basic lead scoring by setting a field when “OPEN EMAIL 1” flips to “yes.”

Why is my Google Sheets connection failing in this workflow?

Usually it’s expired OAuth access or the wrong Google account connected in n8n. Reconnect the Google Sheets credential, then confirm the spreadsheet documentId in the “Fetch CRM Sheet” and update nodes matches your copy. If you’re updating protected ranges, remove protections or grant edit access to the connected account.

How many leads can this Gmail open tracking automation handle?

On a typical setup, hundreds of leads per day is realistic, but Gmail sending limits are the real ceiling.

Is this Gmail open tracking automation better than using Zapier or Make?

For pixel-based tracking and the “write back to the same CRM row” logic, n8n is usually the smoother choice because you can control webhooks, looping, and conditional updates in one place. Self-hosting also removes the constant “task counting” anxiety. Zapier or Make can work if you only want simple “send email then update sheet,” but open tracking gets awkward fast without custom webhook handling. If you’re trying to decide, Talk to an automation expert and you’ll get a straight recommendation based on your volume and tooling.

Once opens and send history are logged automatically, your Sheet stops being a glorified list and starts acting like a real pipeline. Set it up once, then spend your follow-up time on the leads that actually showed interest.

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": "9abbc393b371bae38cd3334004e3244f1fd1fc4df11a7133f609569639391fff"
},
"name": "Automated Email Pixel Tracking Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11248",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
22,
42
],
"parameters": {
"color": 7,
"width": 1266,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "2cde4e1b-498d-473c-8275-d5fbdaa87cea",
"name": "Manual Start Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
1188,
198
],
"parameters": [],
"typeVersion": 1
},
{
"id": "b94e5896-b9a0-48b0-b7c4-d63b057eb51e",
"name": "Incoming Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
1184,
532
],
"webhookId": "e995cbaa-9259-4685-a144-16a700d0a71d",
"parameters": {
"path": "e995cbaa-9259-4685-a144-16a700d0a71d",
"options": [],
"responseMode": "responseNode"
},
"typeVersion": 2.1
},
{
"id": "daaea3b2-7206-4db6-b55b-5d5b9ab2e750",
"name": "Webhook Response Sender",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
548,
486
],
"parameters": {
"options": [],
"respondWith": "binary"
},
"typeVersion": 1.4
},
{
"id": "6ae5b2fa-378a-4f23-ac73-24b07eaa6e93",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
392,
142
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-5-mini",
"cachedResultName": "gpt-5-mini"
},
"options": [],
"builtInTools": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.3
},
{
"id": "2fee2a5d-f761-4abe-acf6-c8e12fe6abba",
"name": "Iterate Records",
"type": "n8n-nodes-base.splitInBatches",
"position": [
748,
212
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "813526d1-3e10-4c06-adfd-3d332b4bda4a",
"name": "Fetch CRM Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
980,
245
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupColumn": "EMAIL 1 SEND"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Lead nurturing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "de323153-3e9d-4937-98f1-1ce9bbbff51a",
"name": "Create Pixel Token",
"type": "n8n-nodes-base.set",
"position": [
562,
258
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "e8ad4a95-c1ce-4d64-9a4b-167980da3896",
"name": "pixel",
"type": "string",
"value": "={{ Array.from({length: 15}, () => Math.random().toString(36).charAt(2)).join('') + ['!', '@', '#', '$', '%', '&', '*'][Math.floor(Math.random() * 7)] }}"
},
{
"id": "475402e2-a308-484b-8d99-c37fdbd2e0b4",
"name": "email",
"type": "string",
"value": "email-1"
},
{
"id": "73c0c4d5-d2fd-4025-8a02-c2f376f517cb",
"name": "webhook_url",
"type": "string",
"value": "https://YOUR_N8N_WEBHOOK_URL"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "79f1dc9b-7694-4fe2-a008-3714361ac97f",
"name": "Email Draft Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
352,
226
],
"parameters": {
"text": "=Write a lead conversion email with a clear call-to-action button. Include this conversion tracking pixel in the HTML body:\n\n<img src=\"{{$json.webhook_url}}?pixel={{ $json.pixel }}&email={{ $json.email }}\" width=\"1\" height=\"1\" style=\"display:none;\">\n\nReturn only the email body in HTML format, no introductions or explanations.",
"options": [],
"promptType": "define"
},
"typeVersion": 3
},
{
"id": "abe94c92-a340-4bf8-a964-8902d738c1c8",
"name": "Dispatch Email",
"type": "n8n-nodes-base.gmail",
"position": [
168,
268
],
"webhookId": "35ca41a3-6095-4263-a760-8be487e2c6ed",
"parameters": {
"sendTo": "={{ $('Fetch CRM Sheet').item.json.EMAIL }}",
"message": "={{ $json.output }}",
"options": [],
"subject": "Email 1"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "a1063c9e-ea92-46c0-b97e-da0933d37fc4",
"name": "Update CRM Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
22,
238
],
"parameters": {
"columns": {
"value": {
"row_number": "={{ $('Fetch CRM Sheet').item.json.row_number }}",
"EMAIL 1 DATE": "={{$now.format('dd/LL/yyyy')}}",
"EMAIL 1 SEND": "={{ $json.id }}",
"PIXEL EMAIL 1": "={{ $('Create Pixel Token').item.json.pixel }}"
},
"schema": [
{
"id": "DATE",
"type": "string",
"display": true,
"required": false,
"displayName": "DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FIRST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "FIRST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "LAST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 1 SEND",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL 1 SEND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 1 DATE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL 1 DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PIXEL EMAIL 1",
"type": "string",
"display": true,
"required": false,
"displayName": "PIXEL EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "OPEN EMAIL 1",
"type": "string",
"display": true,
"required": false,
"displayName": "OPEN EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLICK EMAIL 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CLICK EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "REPLY TO EMAIL 1",
"type": "string",
"display": true,
"required": false,
"displayName": "REPLY TO EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 2 SEND",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL 2 SEND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 2 DATE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL 2 DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PIXEL EMAIL 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PIXEL EMAIL 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "OPEN EMAIL 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "OPEN EMAIL 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLICK EMAIL 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CLICK EMAIL 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "REPLY TO EMAIL 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "REPLY TO EMAIL 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 3 SEND",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL 3 SEND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 3 DATE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL 3 DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PIXEL EMAIL 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PIXEL EMAIL 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "OPEN EMAIL 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "OPEN EMAIL 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLICK EMAIL 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CLICK EMAIL 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "REPLY TO EMAIL 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "REPLY TO EMAIL 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Lead nurturing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "afc85c64-f00c-4424-8344-aa8696fcdf96",
"name": "Build Pixel Base64",
"type": "n8n-nodes-base.set",
"position": [
972,
548
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "e8ad4a95-c1ce-4d64-9a4b-167980da3896",
"name": "data",
"type": "string",
"value": "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAAYdEVYdFNvZnR3YXJlAFBhaW50Lk5FVCA1LjEuMvu8A7YAAAC2ZVhJZklJKgAIAAAABQAaAQUAAQAAAEoAAAAbAQUAAQAAAFIAAAAoAQMAAQAAAAIAAAAxAQIAEAAAAFoAAABphwQAAQAAAGoAAAAAAAAAYAAAAAEAAABgAAAAAQAAAFBhaW50Lk5FVCA1LjEuMgADAACQBwAEAAAAMDIzMAGgAwABAAAAAQAAAAWgBAABAAAAlAAAAAAAAAACAAEAAgAEAAAAUjk4AAIABwAEAAAAMDEwMAAAAADp1fY4ytpsegAAAA1JREFUGFdjYGBgYAAAAAUAAYoz4wAAAAAASUVORK5CYII"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0985436f-d56b-43a1-83b1-d74152b03c83",
"name": "Convert Pixel File",
"type": "n8n-nodes-base.convertToFile",
"position": [
756,
520
],
"parameters": {
"options": {
"mimeType": "image/png"
},
"operation": "toBinary",
"sourceProperty": "data"
},
"typeVersion": 1.1
},
{
"id": "f4a9d59d-25ec-428a-bfd3-bea81fe5a181",
"name": "Extract Query Params",
"type": "n8n-nodes-base.set",
"position": [
574,
628
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "3c40f4c6-de0e-43da-870d-937ba9740ed0",
"name": "pixel",
"type": "string",
"value": "={{ $('Incoming Webhook').item.json.query.pixel }}"
},
{
"id": "25584f1f-d40a-43b6-8e04-bb7ceadcdfe6",
"name": "email",
"type": "string",
"value": "={{ $('Incoming Webhook').item.json.query.email }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "575935b6-4709-4146-93ee-c6bd47215cad",
"name": "Mark Email Opened",
"type": "n8n-nodes-base.googleSheets",
"position": [
360,
612
],
"parameters": {
"columns": {
"value": {
"OPEN EMAIL 1": "yes",
"PIXEL EMAIL 1": "={{ $json.pixel }}"
},
"schema": [
{
"id": "DATE",
"type": "string",
"display": true,
"required": false,
"displayName": "DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FIRST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "FIRST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "LAST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL 1 SEND",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL 1 SEND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PIXEL EMAIL 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PIXEL EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "OPEN EMAIL 1",
"type": "string",
"display": true,
"required": false,
"displayName": "OPEN EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "REPLY TO EMAIL 1",
"type": "string",
"display": true,
"required": false,
"displayName": "REPLY TO EMAIL 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"PIXEL EMAIL 1"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Lead nurturing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Fetch CRM Sheet": {
"main": [
[
{
"node": "Iterate Records",
"type": "main",
"index": 0
}
]
]
},
"Incoming Webhook": {
"main": [
[
{
"node": "Build Pixel Base64",
"type": "main",
"index": 0
}
]
]
},
"Extract Query Params": {
"main": [
[
{
"node": "Mark Email Opened",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Email": {
"main": [
[
{
"node": "Update CRM Sheet",
"type": "main",
"index": 0
}
]
]
},
"Update CRM Sheet": {
"main": [
[
{
"node": "Iterate Records",
"type": "main",
"index": 0
}
]
]
},
"Email Draft Agent": {
"main": [
[
{
"node": "Dispatch Email",
"type": "main",
"index": 0
}
]
]
},
"Create Pixel Token": {
"main": [
[
{
"node": "Email Draft Agent",
"type": "main",
"index": 0
}
]
]
},
"Iterate Records": {
"main": [
[],
[
{
"node": "Create Pixel Token",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "Email Draft Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Convert Pixel File": {
"main": [
[
{
"node": "Webhook Response Sender",
"type": "main",
"index": 0
},
{
"node": "Extract Query Params",
"type": "main",
"index": 0
}
]
]
},
"Build Pixel Base64": {
"main": [
[
{
"node": "Convert Pixel File",
"type": "main",
"index": 0
}
]
]
},
"Manual Start Trigger": {
"main": [
[
{
"node": "Fetch CRM Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}