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 ...
Template notes
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](https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJpBfGIKd75hu4uHj0vGRZQ/edit?usp=sharing) 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:
- 📧 robert@ynteractive.com - 🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)