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
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:
📧 robert@ynteractive.com
🔗 LinkedIn
Related Templates
Extract Named Entities from Web Pages with Google Natural Language API
Who is this for? Content strategists analyzing web page semantic content SEO professionals conducting entity-based anal...
Add product ideas to Notion via a Slack command
Use Case In most companies, employees have a lot of great ideas. That was the same for us at n8n. We wanted to make it a...
Automate Daily Keyword Research with Google Sheets, Suggest API & Custom Search
Who's it for This workflow is perfect for SEO specialists, marketers, bloggers, and content creators who want to automa...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments