Generate Marketing Campaign ROI Reports with Google Sheets, GPT-4o and Email

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:

📧 [email protected]
🔗 LinkedIn