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

0
Downloads
1
Views
6.4
Quality Score
beginner
Complexity
Author:Robert Breen(View Original β†’)
Created:9/10/2025
Updated:11/18/2025

πŸ”’ Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments