Create Automatic Pivot Tables in Google Sheets with n8n

This n8n workflow pulls campaign data from Google Sheets and creates two pivot tables automatically each time it runs.

✅ 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 access
4. Use this sheet: 📄 Campaign Data Sheet
5. Make sure the sheet includes:
   • A Data tab (row 1 = headers, rows 2+ = campaign data)
   • A tab for each pivot view (e.g. by Channel, by Campaign)

📬 Need Help?

Feel free to reach out:

• 📧 [email protected]
• 🔗 LinkedIn