OpenAI + Google Sheets: campaigns drafted for you
Your “campaign planning” turns into a messy chain of tabs, half-finished docs, and copy that doesn’t match across channels. One idea becomes five separate writing tasks, and somehow you’re the one stitching it all together at 11pm.
This hits marketing managers hardest, but founders and agency leads feel it too. With this OpenAI Sheets automation, you drop a single brief and get coordinated drafts (blog, email, social, and more) plus a usable plan.
Below you’ll see how the workflow runs in n8n, what results to expect, and what you need to set it up without turning into “the technical person” on your team.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: OpenAI + Google Sheets: campaigns drafted for you
flowchart LR
subgraph sg0["When chat message received Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When chat message received", pos: "b", h: 48 }
n1@{ icon: "mdi:robot", form: "rounded", label: "Content Director Agent", pos: "b", h: 48 }
n2@{ icon: "mdi:wrench", form: "rounded", label: "Think", pos: "b", h: 48 }
n3@{ icon: "mdi:wrench", form: "rounded", label: "Blog Content Writer", pos: "b", h: 48 }
n4@{ icon: "mdi:wrench", form: "rounded", label: "Social Media Content Creator", pos: "b", h: 48 }
n5@{ icon: "mdi:wrench", form: "rounded", label: "Video Script Writer", pos: "b", h: 48 }
n6@{ icon: "mdi:wrench", form: "rounded", label: "Email Newsletter Writer", pos: "b", h: 48 }
n7@{ icon: "mdi:wrench", form: "rounded", label: "Website Copy Specialist", pos: "b", h: 48 }
n8@{ icon: "mdi:wrench", form: "rounded", label: "Content Strategist & Planner", pos: "b", h: 48 }
n9@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model Content Di..", pos: "b", h: 48 }
n10@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model1", pos: "b", h: 48 }
n11@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model2", pos: "b", h: 48 }
n12@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model3", pos: "b", h: 48 }
n13@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model4", pos: "b", h: 48 }
n14@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model5", pos: "b", h: 48 }
n15@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model6", pos: "b", h: 48 }
n2 -.-> n1
n10 -.-> n3
n11 -.-> n4
n12 -.-> n5
n13 -.-> n6
n14 -.-> n7
n15 -.-> n8
n3 -.-> n1
n5 -.-> n1
n6 -.-> n1
n7 -.-> n1
n0 --> n1
n8 -.-> n1
n4 -.-> n1
n9 -.-> n1
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 n1 ai
class n9,n10,n11,n12,n13,n14,n15 aiModel
class n2,n3,n4,n5,n6,n7,n8 ai
The Problem: Multi-Channel Campaigns Get Disjointed Fast
When you plan a campaign manually, the first draft is never the real problem. It’s the follow-through. The blog post sounds thoughtful, the email sounds salesy, and the social posts feel like they were written by a different company. Then you spend about 2 hours rewriting for consistency, adding missing details, and trying to remember what the original brief even said. Small changes become painful too. Update the offer, tweak the angle, change the audience, and suddenly you’re hunting through five places to fix the same sentence.
It adds up fast. Here’s where it usually breaks down.
- You rewrite the same positioning and product details in every channel because nothing is connected.
- Drafts get created, but there’s no central log, so approvals and “what’s left” live in someone’s head.
- Inconsistent voice creeps in when multiple people (or tools) generate pieces independently.
- Campaign planning stalls because the first output isn’t a plan, it’s just more text to wrangle.
The Solution: One Brief In, Campaign Assets Out (Logged in Sheets)
This workflow turns a chat message into a coordinated content pack. You send one campaign request (topic, audience, offer, tone, goals). Then an AI “Content Director” reviews it first, decides what assets make sense, and assigns work to specialist writers for each channel. Those specialists generate drafts for long-form blog content, social posts, video scripts, email campaigns, website copy, and a strategy plan, all aligned to the same core angle. Finally, everything is structured and ready to log in Google Sheets so you can review, edit, and track what’s approved. It feels less like “using AI” and more like handing work to a small content team that actually talks to each other.
The workflow starts when a chat request is received in n8n. From there, OpenAI runs a Director agent (O3) to set direction, then GPT-4.1-mini specialist agents draft each channel in parallel. Google Sheets becomes the hub where the campaign outputs live, which means you stop losing track.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you run one campaign a week and you need 6 assets: a blog draft, 5 social posts, one email, a short video script, a landing page section, and a simple plan. Manually, even at “only” 30 minutes per asset, that’s about 3 hours, and it usually turns into more once you fix consistency. With this workflow, you spend about 10 minutes writing a solid brief, then wait for generation and review the outputs in Google Sheets. You still edit, but the heavy lifting is done before your coffee gets cold.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- OpenAI for the Director and specialist agents
- Google Sheets to log outputs and track drafts
- OpenAI API key (get it from the OpenAI dashboard)
Skill level: Beginner. You’ll connect accounts, paste an API key, and tweak prompts for your brand voice.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A chat message kicks everything off. You type a campaign brief once (topic, audience, offer, tone). n8n listens for that message and starts the run immediately.
The Content Director sets direction. OpenAI O3 reads your request, thinks through what mix of assets makes sense, then delegates tasks so each channel follows the same strategy.
Specialist agents draft the pieces. Separate GPT-4.1-mini agents produce long-form blog copy, social posts, video scripting, email content, website sections, and a strategy plan. Because they run in parallel, you’re not waiting on one output to start the next.
Everything gets structured for tracking. The workflow uses n8n’s field editing and merge steps to shape responses into clean, repeatable fields, then sends those results into Google Sheets so your team can review and work from one place.
You can easily modify the channels you generate to match your funnel (for example, swap video scripts for ad variations). See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Chat Trigger
Set up the incoming chat entry point that initiates the workflow and passes the user’s prompt to the AI orchestrator.
- Add the Incoming Chat Trigger node to your canvas.
- Keep the default Options since it’s empty in the workflow configuration.
- Connect Incoming Chat Trigger to Content Orchestrator to match the execution flow
"Incoming Chat Trigger" → "Content Orchestrator".
Step 2: Connect OpenAI Credentials for Language Models
Attach OpenAI chat models to the orchestrator and specialized agents so they can generate content.
- Open Director LM Model and set the Model to
o3. - Open Blog LM Model and set the Model to
gpt-4.1-mini. - Open Social LM Model and set the Model to
gpt-4.1-mini. - Open Video LM Model and set the Model to
gpt-4.1-mini. - Open Email LM Model and set the Model to
gpt-4.1-mini. - Open Website LM Model and set the Model to
gpt-4.1-mini. - Open Strategy LM Model and set the Model to
gpt-4.1-mini. - Credential Required: Connect your OpenAI credentials to all LM nodes (Director LM Model, Blog LM Model, Social LM Model, Video LM Model, Email LM Model, Website LM Model, Strategy LM Model).
Step 3: Set Up the Orchestrator and Reasoning Tool
Configure the central agent that routes the prompt to specialized tools and uses a reasoning helper.
- Open Content Orchestrator and leave Options empty to match the workflow.
- Attach Director LM Model to Content Orchestrator as its language model (already connected as ai_languageModel).
- Ensure Reasoning Helper is connected to Content Orchestrator as an ai_tool.
- Credential Required: Connect your OpenAI credentials to Director LM Model (the language model for Content Orchestrator).
Step 4: Configure the Specialized Content Agents
Each agent tool generates content for a specific channel using the user’s prompt.
- In Longform Blog Agent, set Text to
={{ $fromAI('Prompt__User_Message_', ``, 'string') }}and keep the Tool Description as the long-form blog specialization. - In Social Post Agent, set Text to
={{ $fromAI('Prompt__User_Message_', ``, 'string') }}and keep the social content Tool Description. - In Video Script Agent, set Text to
={{ $fromAI('Prompt__User_Message_', ``, 'string') }}and keep the video script Tool Description. - In Email Campaign Agent, set Text to
={{ $fromAI('Prompt__User_Message_', ``, 'string') }}and keep the email campaign Tool Description. - In Web Copy Agent, set Text to
={{ $fromAI('Prompt__User_Message_', ``, 'string') }}and keep the web copy Tool Description. - In Strategy Planner Agent, set Text to
={{ $fromAI('Prompt__User_Message_', ``, 'string') }}and keep the strategy planning Tool Description. - Verify all agent tools are connected back to Content Orchestrator via ai_tool.
- Attach LM nodes to each agent: Blog LM Model → Longform Blog Agent, Social LM Model → Social Post Agent, Video LM Model → Video Script Agent, Email LM Model → Email Campaign Agent, Website LM Model → Web Copy Agent, Strategy LM Model → Strategy Planner Agent.
Step 5: Test and Activate Your Workflow
Run a manual test to confirm the chat prompt flows into the orchestrator and produces multi-channel content.
- Click Execute Workflow and send a sample chat message to Incoming Chat Trigger.
- Verify Content Orchestrator calls the agent tools and you see outputs from the six content agents.
- Confirm each LM node responds successfully (no credential or model errors in the execution log).
- Once successful, toggle the workflow Active to enable production use.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credential settings and the target sheet sharing access 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
About 30 minutes if your accounts are ready.
No. You’ll mostly connect accounts and adjust prompts. The “hard part” is writing a clear brief.
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 run with GPT-4.1-mini.
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.
Yes, and you should. Update the Content Orchestrator and each specialist agent prompt (Blog, Social, Email, Video, Website, Strategy) with your tone, examples, and “do not say” rules. If you don’t want a channel, disable that agent or have the Director stop delegating to it. A common customization is to add structured fields like “CTA,” “offer terms,” and “target persona” so every output stays consistent.
Most of the time it’s an expired or incorrect API key. Update the OpenAI credential in n8n, then rerun with a simple test brief. If it still fails, check model access (O3 and GPT-4.1-mini availability) and watch for rate limiting when multiple specialist agents fire at once.
A lot.
For this use case, usually yes, because n8n handles multi-agent logic, branching, and “many steps per run” without getting painful. It’s also easier to self-host, so you’re not paying more just because a campaign has several outputs. Zapier and Make can still work if you only want a simple “brief → one response” flow. Once you want a Director, specialists, and structured logging, they tend to feel cramped. Talk to an automation expert if you want help choosing without guessing.
Set it up once, then stop rebuilding the same campaign in five different places. The workflow handles the repetitive drafting and organization so you can focus on the decisions that actually move revenue.
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.
