Generate marketing reports from Google Sheets with GPT-4 insights and PDF.co

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 template into your Google Drive: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJCCLq4/edit?gid=365710158gid=365710158) - Add or update your marketing spend data in rows 2–100.

Connect Google Sheets in n8n 1. Go to n8n → Credentials → New → Google Sheets (OAuth2) 2. Log in with your Google account and grant access 3. Select the Spreadsheet ID and Worksheet in the workflow

---

2️⃣ Set Up PDF.co for PDF Reports 1. Create a free account at [PDF.co](https://pdf.co/) 2. In PDF.co Dashboard → HTML to PDF Templates, create a new Mustache template - Paste the HTML provided at the bottom of this description - Save, and note your Template ID 3. In n8n → Credentials → New → PDF.co API, paste your API Key and save 4. In the workflow, select your PDF.co credential in the Create PDF node 5. Replace the templateId with your Template ID

---