Back to Templates

Create Automatic Pivot Tables in Google Sheets with n8n

Created by

Created by: Robert Breen || rbreen

Robert Breen

Last update

Last update a month ago

Categories

Share


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: