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

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:

📧 robert@ynteractive.com
🔗 LinkedIn