Create Automatic Pivot Tables in Google Sheets with n8n
Go to Workflow
Robert Breen
Description
This n8n workflow pulls campaign data from Google Sheets and creates two pivot tables automatically each time it runs.
✅ Step 1: Connect Google Sheets
In n8n, go to Credentials → click New Credential
Select Google Sheets OAuth2 API
Log in with your Google account and authorize access
Use this sheet: 📄 Campaign Data Sheet
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
This workflow was created by Robert Breen and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.