🎯 Generate marketing campaign ROI reports with Google Sheets, GPT-4o and Email
⚡ 958 views · 🎯 AI Summarization & Classification
Description
This n8n workflow pulls campaign data from Google Sheets, summarizes it using OpenAI, and sends a performance recap via Outlook email.
✅ Step 1: Connect Google Sheets
- In n8n, go to Credentials → click New Credential
- Select Google Sheets OAuth2 API
- Log in with your Google account and authorize
- Use a spreadsheet with:
- Column names in the first row
- Data in rows 2–100
- Example format: 📄 Sample Marketing Sheet
✅ Step 2: Connect OpenAI
- Go to OpenAI API Keys
- Make sure you have a payment method set under Billing
- In n8n, create a new OpenAI API credential
- Paste your API key and save
📬 Need Help?
Feel free to contact me if you run into issues:
🔗 Nodes Used
Google Sheets, AI Agent, OpenAI Chat Model, Structured Output Parser, Summarize
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File