Skip to main content

Create automatic pivot tables in Google Sheets with n8n

Workflow preview

Create automatic pivot tables in Google Sheets with n8n preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

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: