🔬 Create automatic pivot tables in Google Sheets with n8n

⚡ 229 views · 🔬 Document Extraction & Analysis

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

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:

• 📧 robert@ynteractive.com
• 🔗 LinkedIn

🔗 Nodes Used

Google Sheets, Summarize

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup