January 22, 2026

Google Sheets + Gmail: newsletters sent only when approved

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You wrote the newsletter. You double-checked the links. Then someone sends the wrong version anyway, or hits “send” before the client signs off. It’s the kind of mistake that feels small until it isn’t.

This Sheets Gmail approval automation hits marketing managers first, but agency teams and solo operators feel it too. You get a simple control system: drafts are generated and stored, and only rows marked “Approved” actually send.

Below, you’ll see how the workflow works, what it replaces, and how to put it into production without turning your newsletter process into another “project.”

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets + Gmail: newsletters sent only when approved

Click to explore

flowchart LR

    subgraph sg0["When clicking 'Test workflow' Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking 'Test workflow'", pos: "b", h: 48 }
        n3@{ icon: "mdi:database", form: "rounded", label: "Get topic from newsletter sh..", pos: "b", h: 48 }
        n4@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Validate Status as Pending", pos: "b", h: 48 }
        n5@{ icon: "mdi:robot", form: "rounded", label: "Create HTML for Newsletter", pos: "b", h: 48 }
        n6["<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/code.svg' width='40' height='40' /></div><br/>Prepare Data to create word .."]
        n7@{ icon: "mdi:cog", form: "rounded", label: "Upload doc to google drive", pos: "b", h: 48 }
        n8@{ icon: "mdi:message-outline", form: "rounded", label: "Send an email to admin", pos: "b", h: 48 }
        n9@{ icon: "mdi:database", form: "rounded", label: "Update Status as Generated", pos: "b", h: 48 }
        n8 --> n9
        n5 --> n6
        n7 --> n8
        n4 --> n5
        n0 --> n3
        n3 --> n4
        n6 --> n7
    end

    subgraph sg1["Schedule Flow"]
        direction LR
        n1@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n10@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Validate Status as Approved", pos: "b", h: 48 }
        n11@{ icon: "mdi:database", form: "rounded", label: "Pick records to send email t..", pos: "b", h: 48 }
        n12@{ icon: "mdi:database", form: "rounded", label: "Get Client email address", pos: "b", h: 48 }
        n13@{ icon: "mdi:message-outline", form: "rounded", label: "Send email to client", pos: "b", h: 48 }
        n14@{ icon: "mdi:database", form: "rounded", label: "Update status as Sent", pos: "b", h: 48 }
        n2 --> n14
        n2 --> n13
        n1 --> n11
        n13 --> n2
        n12 --> n2
        n10 --> n12
        n11 --> n10
    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,n1 trigger
    class n5 ai
    class n4,n10 decision
    class n3,n9,n11,n12,n14 database
    class n6 code
    classDef customIcon fill:none,stroke:none
    class n6 customIcon

The Problem: Newsletters Ship Before They’re Truly Ready

Newsletter operations usually start simple: a spreadsheet of topics, a doc somewhere, and a “we’ll remember” approval step. Then real life shows up. You’re juggling multiple clients, last-minute edits, and “can we send it today?” messages. The weak point is always the same: there’s no single source of truth that decides what gets sent and what stays parked. So drafts get emailed early, the wrong audience gets the wrong version, and you spend your morning doing cleanup instead of planning the next campaign.

It adds up fast. Here’s where it breaks down in most teams.

Approval lives in someone’s inbox, so the sending step turns into guesswork.
Draft files end up scattered in Drive, which makes “final” hard to define.
Manual copying of subject lines and HTML leads to tiny errors that look sloppy in production.
When you manage multiple clients, you risk sending Client A’s content to Client B.

The Solution: Google Sheets Runs the Entire Approval-to-Send Pipeline

This workflow turns one Google Sheet into your newsletter command center. You add topics as “Pending,” then run a manual generation flow that creates AI-written HTML for each topic and stores it in Google Drive for review. The system updates the row so everyone can see the draft is “Generated,” and it sends an admin notification so nothing gets lost. Separately, a schedule checks your sheet for rows marked “Approved.” Only those rows move forward. n8n pulls the client email, sends the newsletter through Gmail, then marks the row “Sent” so you have a clean audit trail and you don’t send duplicates.

The workflow starts with either a manual run (to generate content from Pending rows) or a timed schedule (to distribute only Approved rows). In the middle, OpenAI generates newsletter HTML, Google Drive stores the file, and Gmail handles both admin alerts and client delivery. At the end, Google Sheets updates every status so your spreadsheet always matches reality.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It pulls Pending topics from Google Sheets and validates the status before generating anything.
It creates AI-generated HTML newsletter drafts and formats them for file storage.
It uploads each draft to Google Drive and emails the admin when drafts are ready.
It checks for Approved rows on a schedule, sends via Gmail, and marks items as Sent.

Most teams get about 2 hours back on each newsletter cycle.
You stop sending “almost final” drafts because status controls delivery.
Drive becomes organized by default, so finding the latest version is painless.
Client sends are consistent, even when you’re handling 20+ recipients.
You get an automatic history of what was generated, approved, and sent.

Example: What This Looks Like

Say you manage 10 client newsletters a week. Manually, you might spend about 20 minutes generating content, 10 minutes saving and organizing files, and 10 minutes prepping the send per client. That’s roughly 40 minutes each, or about 7 hours weekly. With this workflow, you drop topics into Sheets, run the generation, and you’re mostly waiting on processing (about 5 minutes per newsletter). When rows flip to “Approved,” scheduled sending handles delivery automatically. You get most of that 7 hours back, and approvals stop getting skipped.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets to store topics, statuses, and send dates.
Gmail to send admin notifications and client emails.
OpenAI API key (get it from your OpenAI dashboard).

Skill level: Intermediate. You’ll connect accounts, map a few fields, and tweak an AI prompt without writing “real code.”

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

How It Works

A manual run generates drafts from “Pending.” You trigger the workflow when you’re ready to create newsletters, and it pulls the queued topics from your Google Sheet. If a row isn’t truly Pending (or the date rules don’t match), it gets skipped.

AI creates newsletter HTML, then it’s packaged for storage. OpenAI produces the draft content in HTML, and a small formatting step prepares it so it can be saved cleanly as a document.

Google Drive stores the draft, and the sheet becomes your tracker. The workflow uploads the file to Drive, emails the admin that it’s ready, and updates the Google Sheets status to “Generated” so review can happen without confusion.

A scheduled run sends only “Approved.” On a timer, n8n searches for rows marked Approved, looks up the client email, loops through recipients, and sends the newsletter via Gmail. Once sent, it marks the row “Sent.” Done.

You can easily modify the approval rules to include a “Needs edits” state or a second reviewer based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Trigger Nodes

Set up both manual and scheduled entry points so you can run the newsletter generation on demand or automatically.

Open Manual Run Initiator to enable manual test runs in the editor.
Open Timed Schedule Trigger and configure your schedule rule (e.g., daily or weekly) in the rule settings.
Confirm that Manual Run Initiator connects to Fetch Newsletter Topics, and Timed Schedule Trigger connects to Retrieve Approved Records as shown in the workflow.

Step 2: Connect Google Sheets

These nodes read newsletter topics, approvals, client emails, and update statuses. Connect Google Sheets once and reuse it across all Sheets nodes.

Open Fetch Newsletter Topics and confirm the documentId is [YOUR_ID] and sheetName is gid=0. The filter should match Status = Pending.
Open Retrieve Approved Records and ensure the documentId is [YOUR_ID] and sheetName is gid=0.
Open Lookup Client Emails and set sheetName to the client list sheet id [YOUR_ID].
Open Mark as Generated and confirm it updates Status to Generated and maps fields like Date to {{ $('Fetch Newsletter Topics').item.json.Date }}.
Open Mark as Sent and confirm it updates Status to Sent and matches on Date.
Credential Required: Connect your googleSheetsOAuth2Api credentials to all Google Sheets nodes (5 total: Fetch Newsletter Topics, Retrieve Approved Records, Lookup Client Emails, Mark as Generated, Mark as Sent).

Step 3: Set Up the Date and Approval Filters

These checks ensure only today’s pending topics are generated and only approved newsletters are sent.

In Check Pending Date, verify the condition compares {{ $json.Date }} to {{ new Date().toLocaleDateString('en-US') }}.
In Confirm Approved Status, ensure the condition checks {{ $json.Status }} equals Approved.
Confirm the flow: Fetch Newsletter Topics → Check Pending Date → Generate Newsletter HTML, and Retrieve Approved Records → Confirm Approved Status → Lookup Client Emails.

Step 4: Set Up the AI and HTML File Generation

Generate the newsletter content with AI and format it into an HTML file for Google Drive.

Open Generate Newsletter HTML and set the model to gpt-4o.
In Generate Newsletter HTML, confirm the prompt includes {{ $json.Topic }} and {{ $json.hooks }} in the message content.
Credential Required: Connect your openAiApi credentials in Generate Newsletter HTML.
Open Format HTML for Drive and keep the jsCode block as-is to generate a binary HTML file and filename based on the current date.
Confirm the flow: Generate Newsletter HTML → Format HTML for Drive → Upload File to Drive.

Tip: If the AI output looks truncated, adjust the prompt in Generate Newsletter HTML to reduce length or add formatting instructions.

Step 5: Configure Drive Upload and Admin Review Email

Store the generated HTML in Drive and notify an admin for review before sending to clients.

In Upload File to Drive, set name to =newsletter-{{ $('Fetch Newsletter Topics').item.json.Date }}.html.
Set driveId to My Drive and folderId to [YOUR_ID].
Set inputDataFieldName to =data.
Credential Required: Connect your googleDriveOAuth2Api credentials in Upload File to Drive.
In Notify Admin via Email, set sendTo to [YOUR_EMAIL] and verify message is =Review the attached newsletter {{ $json.webViewLink }}.
Set subject to =Newsletter Preview for {{ $('Fetch Newsletter Topics').item.json.Date }} and HTML body attached and emailType to text.
Credential Required: Connect your gmailOAuth2 credentials in Notify Admin via Email.
Confirm the flow: Upload File to Drive → Notify Admin via Email → Mark as Generated.

⚠️ Common Pitfall: If Upload File to Drive fails, verify the folder permissions and that the Drive credential has access to [YOUR_ID].

Step 6: Configure Client Delivery and Status Updates

This section dispatches the approved newsletter to each client and marks records as sent.

In Dispatch Client Email, set sendTo to {{ $json.Email }}.
Set message to =Attached is the newsletter {{ $('Retrieve Approved Records').item.json['Document URL'] }} and emailType to text.
Credential Required: Connect your gmailOAuth2 credentials in Dispatch Client Email.
Verify the batching flow: Lookup Client Emails → Batch Iterator → Dispatch Client Email → Batch Iterator → Mark as Sent.

Step 7: Test and Activate Your Workflow

Validate both the manual generation path and the scheduled delivery path before turning the workflow on.

Click Execute Workflow using Manual Run Initiator and confirm a newsletter HTML file is created in Drive.
Check Notify Admin via Email to verify the admin email includes a webViewLink to the uploaded file.
Run a test on the scheduled path by temporarily triggering Timed Schedule Trigger, then verify that Dispatch Client Email sends to addresses from Lookup Client Emails.
Confirm Mark as Generated and Mark as Sent update the Google Sheet with Generated and Sent statuses.
Once validated, toggle the workflow to Active to run automatically on schedule.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets permissions can block updates even when reads work. If status changes fail, check the Google connection and sharing settings on the spreadsheet 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.
OpenAI prompts that are too generic create bland newsletters. Add your brand voice, target audience, and “what to avoid” early, or you will be rewriting every draft.

Frequently Asked Questions

How long does it take to set up this Sheets Gmail approval automation?

About 45 minutes if your Google accounts and sheet are ready.

Do I need coding skills to automate Sheets Gmail approval?

No. You’ll mostly connect apps and map columns to fields. The “code” step is included and usually doesn’t need edits.

Is n8n free to use for this Sheets Gmail approval 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 (often just a few dollars a month 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 Sheets Gmail approval workflow for a two-step approval?

Yes, but keep it simple. Add a second status like “Review” or “Client Approved,” then adjust the “Confirm Approved Status” check so only the final state sends. Many teams also add an extra admin notification after “Mark as Generated” so reviewers get pinged immediately.

Why is my Google Sheets connection failing in this workflow?

Usually it’s the Google authentication scope or a spreadsheet permission mismatch. Reconnect the Google account in n8n, then confirm that same account can edit the exact file (not a copy) and the right sheet/tab names haven’t changed. If you renamed columns, check the node mappings too because n8n can’t update a field it can’t find.

How many newsletters can this Sheets Gmail approval automation handle?

It can handle 100+ clients without breaking a sweat, as long as your Google and OpenAI rate limits are respected.

Is this Sheets Gmail approval automation better than using Zapier or Make?

Often, yes. The big win is control: n8n makes it easier to enforce “only Approved sends,” loop through multiple rows, and update statuses reliably without paying extra for every branch. You also get the option to self-host, which matters once you’re running lots of scheduled checks. Zapier or Make can still be fine for a simple two-step “row added → send email,” but approvals plus file storage plus status tracking gets messy. If you want help choosing, Talk to an automation expert.

Once Sheets becomes the gatekeeper, “Oops, wrong version” stops being a regular event. Set it up once, then let approvals decide what actually ships.

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": "612b8b9ae672100956298ab59a6a71a87da915c7360619aa914b9943caa052be",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Newsletter Delivery Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-5694",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1280,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "88924d6c-0524-45c6-8982-b43bc79951c6",
"name": "Manual Run Initiator",
"type": "n8n-nodes-base.manualTrigger",
"notes": "",
"position": [
1180,
120
],
"parameters": [],
"typeVersion": 1
},
{
"id": "d386375c-ecac-4335-a29a-cd39d9233f07",
"name": "Timed Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "",
"position": [
1175,
440
],
"parameters": {
"rule": {
"interval": [
[]
]
}
},
"typeVersion": 1.2
},
{
"id": "ca49af2b-0d7f-4aa1-b63c-dc828bfeb7d6",
"name": "Batch Iterator",
"type": "n8n-nodes-base.splitInBatches",
"notes": "",
"position": [
10,
405
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "2208eb0e-a0aa-4082-905b-166fa521b75a",
"name": "Fetch Newsletter Topics",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
870,
210
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "Pending",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Topic"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Newsletter"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "2b47d026-a70e-40d5-a2c4-4f07551f0eef",
"name": "Check Pending Date",
"type": "n8n-nodes-base.if",
"notes": "",
"position": [
685,
130
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "2d883784-6213-45b4-944f-55c0ffcc19b6",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Date }}",
"rightValue": "={{ new Date().toLocaleDateString('en-US') }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "448be138-181b-4bda-95dd-66d632635256",
"name": "Generate Newsletter HTML",
"type": "@n8n/n8n-nodes-langchain.openAi",
"notes": "",
"position": [
365,
205
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": [],
"messages": {
"values": [
{
"content": "=Create an HTML newsletter on the topic:{{ $json.Topic }}. \n Include these hook sentences:{{ $json.hooks }} . \n Structure with a header, body paragraphs, and footer\n"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "f552d84a-9d14-4cb1-89d7-d99bc9784a5e",
"name": "Format HTML for Drive",
"type": "n8n-nodes-base.code",
"notes": "",
"position": [
5,
135
],
"parameters": {
"jsCode": "// Get HTML content from current input\nconst htmlContent = $input.first().json.message.content;\n\n// Generate filename with current date\nconst currentDate = new Date().toISOString().split('T')[0];\nconst filename = `document_${currentDate}.html`;\n\n// Convert string to binary buffer\nconst buffer = Buffer.from(htmlContent, 'utf8');\n\nreturn [{\n  json: {\n    fileName: filename,\n    mimeType: 'text/html'\n  },\n  binary: {\n    data: buffer\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "f2421bc4-2045-46c9-beab-ff5459b4a17c",
"name": "Upload File to Drive",
"type": "n8n-nodes-base.googleDrive",
"notes": "",
"position": [
190,
370
],
"parameters": {
"name": "=newsletter-{{ $('Fetch Newsletter Topics').item.json.Date }}.html",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive",
"cachedResultUrl": "https://drive.google.com/drive/my-drive",
"cachedResultName": "My Drive"
},
"options": [],
"folderId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://drive.google.com/drive/folders/[YOUR_ID]",
"cachedResultName": "Newsletter"
},
"inputDataFieldName": "=data"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
},
{
"id": "6b39c176-25cf-4b47-a25c-8b886f0709ba",
"name": "Notify Admin via Email",
"type": "n8n-nodes-base.gmail",
"notes": "",
"position": [
530,
330
],
"webhookId": "WEBHOOK_ID_PLACEHOLDER",
"parameters": {
"sendTo": "[YOUR_EMAIL]",
"message": "=Review the attached newsletter  {{ $json.webViewLink }}",
"options": [],
"subject": "=Newsletter Preview for {{ $('Fetch Newsletter Topics').item.json.Date }} and HTML body attached",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "8e7c42de-3fd8-4acc-afdb-83491674bf7b",
"name": "Mark as Generated",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
770,
350
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Fetch Newsletter Topics').item.json.Date }}",
"Status": "Generated",
"Timestamp": "={{ $('Upload File to Drive').item.json.createdTime }}",
"Document URL": "={{ $('Upload File to Drive').item.json.webViewLink }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Topic",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hooks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "hooks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Document URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Document URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Date"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Topic"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Newsletter"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "0f6f5d15-dbd9-415b-923d-81809708542d",
"name": "Confirm Approved Status",
"type": "n8n-nodes-base.if",
"notes": "",
"position": [
690,
415
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b3730359-d11f-4a9c-aa5f-f4dcc1f0702e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "Approved"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f03eed28-1c06-401e-8c4b-ba5b5891b048",
"name": "Retrieve Approved Records",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
875,
505
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Topic"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Newsletter"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "23ae0b93-f121-493b-a0d1-80fc748137a2",
"name": "Lookup Client Emails",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
355,
495
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=[YOUR_ID]",
"cachedResultName": "Email"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Newsletter"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "4281a45c-5af5-4311-bca6-aaee14152afc",
"name": "Dispatch Client Email",
"type": "n8n-nodes-base.gmail",
"notes": "",
"position": [
365,
670
],
"webhookId": "CLIENT_WEBHOOK_ID_PLACEHOLDER",
"parameters": {
"sendTo": "={{ $json.Email }}",
"message": "=Attached is the newsletter  {{ $('Retrieve Approved Records').item.json['Document URL'] }}",
"options": [],
"subject": "Newsletter",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "c2634a85-88f6-49b5-bd14-6e03336a49f2",
"name": "Mark as Sent",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
0,
620
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Retrieve Approved Records').item.json.Date }}",
"Status": "Sent"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Topic",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hooks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "hooks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Document URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Document URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Date"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Topic"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Newsletter"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Batch Iterator": {
"main": [
[
{
"node": "Mark as Sent",
"type": "main",
"index": 0
}
],
[
{
"node": "Dispatch Client Email",
"type": "main",
"index": 0
}
]
]
},
"Timed Schedule Trigger": {
"main": [
[
{
"node": "Retrieve Approved Records",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Client Email": {
"main": [
[
{
"node": "Batch Iterator",
"type": "main",
"index": 0
}
]
]
},
"Notify Admin via Email": {
"main": [
[
{
"node": "Mark as Generated",
"type": "main",
"index": 0
}
]
]
},
"Lookup Client Emails": {
"main": [
[
{
"node": "Batch Iterator",
"type": "main",
"index": 0
}
]
]
},
"Generate Newsletter HTML": {
"main": [
[
{
"node": "Format HTML for Drive",
"type": "main",
"index": 0
}
]
]
},
"Upload File to Drive": {
"main": [
[
{
"node": "Notify Admin via Email",
"type": "main",
"index": 0
}
]
]
},
"Check Pending Date": {
"main": [
[
{
"node": "Generate Newsletter HTML",
"type": "main",
"index": 0
}
]
]
},
"Confirm Approved Status": {
"main": [
[
{
"node": "Lookup Client Emails",
"type": "main",
"index": 0
}
]
]
},
"Manual Run Initiator": {
"main": [
[
{
"node": "Fetch Newsletter Topics",
"type": "main",
"index": 0
}
]
]
},
"Fetch Newsletter Topics": {
"main": [
[
{
"node": "Check Pending Date",
"type": "main",
"index": 0
}
]
]
},
"Format HTML for Drive": {
"main": [
[
{
"node": "Upload File to Drive",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Approved Records": {
"main": [
[
{
"node": "Confirm Approved Status",
"type": "main",
"index": 0
}
]
]
}
}
}