Generate marketing reports from Google Sheets with GPT-4 insights and PDF.co
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and Pdfco (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Marketing Data (Google Sheets): uses Google Sheets
- Sum Spend (Summarize): summarizes / groups the items
- Sum Spend by Channel (Summarize): summarizes / groups the items
- Combine All (Merge): merges the data from its input branches
- Covert to 1 row (Aggregate): combines items into one
- Convert to PDF Upload (Code): runs custom JavaScript code
- Write Summary (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Create PDF (PDFco Api): url/html to pdf
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-pdfco is verified or supports 3.0 (used in Create PDF).
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Summarize
n8n-nodes-base.summarize - AI Agent
@n8n/n8n-nodes-langchain.agent - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - PDFco Api
n8n-nodes-pdfco.PDFco Api - Aggregate
n8n-nodes-base.aggregate
From the author
This workflow pulls marketing data from Google Sheets, aggregates spend by channel, generates an AI-written summary, and outputs a formatted PDF report using a custom HTML template on PDF.co. --- ⚙️ Setup Instructions 1️⃣ Prepare Your Google Sheet - Copy this…