Skip to main content

Manage email campaigns with MailerLite, Google Sheets and Claude via OpenRouter

Workflow preview

Workflow preview
100%
Manage email campaigns with MailerLite, Google Sheets and Claude via OpenRouter preview
Open on n8n.io

1. Workflow Overview

Email Marketing Manager What Native n8n chat operated AI employee for a single wellness SaaS brand Handles three intents: send campaign, report campaign, reactivate cold subscribers Why Replace rep...

Best for

  • Social Media automation workflows
  • AI Chatbot automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, @n8n/n8n-nodes-langchain.chattrigger, n8n-nodes-base.code, @n8n/n8n-nodes-langchain.lmchatopenrouter, @n8n/n8n-nodes-langchain.agent, n8n-nodes-base.if, n8n-nodes-base.switch, n8n-nodes-base.httprequest

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Pankstr.

Original n8n.io source

1.1 Workflow description

Title
Manage email campaigns with MailerLite, Google Sheets and Claude via OpenRouter
Workflow name
Manage email campaigns with MailerLite, Google Sheets and Claude via OpenRouter

Email Marketing Manager

What

  • Native n8n chat-operated AI employee for a single wellness SaaS brand
  • Handles three intents: send campaign, report campaign, reactivate cold subscribers

Why

  • Replace repetitive email manager execution work without pretending to replace brand judgment
  • Keep v1 narrow, testable, and draft-first for internal lists

Assumptions

  • Single brand only
  • Draft first
  • Reject unknown or mixed intents
  • One shared context node handles default information for every intent.
  • Generate subject + preview text + body
  • Log only task, status, time, IDs, and notes

Integrations

  • MailerLite (core email platform)
  • Google sheets
  • OpenRouter (or any AI)

Required setup before testing

  • Provide Openrouter credential or change it to openAI API.
  • Connect MailerLite HTTP Bearer Auth credential
  • Connect Google Sheets OAuth2 credential
  • Replace placeholder Google Sheet URL and verified sender email
  • Replace Postgres DB with others for chat memory.

SAMPLE INPUTS

  1. Send a campaign to long term VIP users. Goal: Introduce an early bird vip invite to personalised dietician. Key message: tailored diet buddy early access. CTA: Link to website Timing: today

  2. Give me a report for all campaigns

  3. I want to re-engage all the subscribers. Tempt with a free, limited time access (for 3 days) to personalised dietician. Share 1-2 reviews from customers on success with this feature. Real review data-{[ "I have to say I was skeptical at first, but I finally stopped emotional eating and have lost 3 lbs in 2 weeks!", "Been a long time user of Noom. Hit a ceiling and stopped using it. This new dietician helped me tweak my macros and micros for my vegetarian diet and back on track baby! Thanks guys 😍"]}

Enhancements

  • Provide brand voice via DB storage & retrieval for AI mail copy.
  • Make the emails multi modal.
  • Use RAG for context management & injecting better information to AI agent. (example : previous written samples)
  • Use native chat integrations for delivering to customers so you can integrate using Slack, WhatsApp, discord etc.

More AI Employees

I am building an AI employee roster, giving away 3 full templates with setup guides. Get early access now: AI Employee Roster

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Workflow Overview

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 2 - Intake + Routing Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Send Flow Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 4 - Report Flow Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 5 - Reactivation Flow Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Chat Trigger

Type / Role
@n8n/n8n-nodes-langchain.chatTrigger - chatTrigger
Config choices
Version 1.4

Block 7 - Prepare Chat Context

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 8 - Intent OpenRouter Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenRouter - lmChatOpenRouter
Config choices
Version 1

Block 9 - Creative OpenRouter Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenRouter - lmChatOpenRouter
Config choices
Version 1

Block 10 - AI Intent Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3.1

Block 11 - Parse Intent

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - Clarification Needed?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 13 - Intent Switch

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.4

Block 14 - Send Action Switch

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.4

Block 15 - Build Context Prompt 1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - Parse Context 1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 17 - Context Failed Reply

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 18 - Fetch Groups

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.4

Block 19 - Fetch Segments

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.4

Block 20 - Resolve Send Audience

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 21 - Send Audience Found?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 22 - Send Audience Missing Reply

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 23 - AI Send Copy Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3.1

Block 24 - Create Send Draft

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.4

Showing the first 24 of 70 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Manage email campaigns with MailerLite, Google Sheets and Claude via OpenRouter
Complexity advanced
Nodes 70
Categories Social Media, AI Chatbot
Author Pankstr
Published 26 Apr 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/15298/15298.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Manage email campaigns with MailerLite, Google Sheets and Claude via OpenRouter do?

Email Marketing Manager What Native n8n chat operated AI employee for a single wellness SaaS brand Handles three intents: send campaign, report campaign, reactivate cold subscribers Why Replace rep...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Social Media, AI Chatbot use case.