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](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJCCLq4/edit?usp=sharing)

---

✅ Step 2: Connect OpenAI

1. Go to [OpenAI API Keys](https://platform.openai.com/api-keys) 2. Make sure you have a payment method set under [Billing](https://platform.openai.com/settings/organization/billing/overview) 3. In n8n, create a new OpenAI API credential 4. Paste your API key and save

---