Create automatic pivot tables in Google Sheets with n8n
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (3)
- Manual Trigger
n8n-nodes-base.manualTrigger - Summarize
n8n-nodes-base.summarize - Google Sheets
n8n-nodes-base.googleSheets
What it does
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