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

1. In n8n, go to Credentials → click New Credential
2. Select Google Sheets OAuth2 API
3. Log in with your Google account and authorize
4. Use a spreadsheet with:
   • Column names in the first row
   • Data in rows 2–100
5. Example format: 📄 Sample Marketing Sheet

✅ Step 2: Connect OpenAI

1. Go to OpenAI API Keys
2. Make sure you have a payment method set under Billing
3. In n8n, create a new OpenAI API credential
4. Paste your API key and save

📬 Need Help?

Feel free to contact me if you run into issues:

• 📧 robert@ynteractive.com
• 🔗 LinkedIn