Aggregate Marketing Spend Data with Custom Pivots & VLOOKUPs in Google Sheets

This n8n workflow pulls raw marketing spend data from a Google Sheets 'data' tab, fetches lookup/reference data (e.g., channel labels) from a 'Lookup' tab, and merges them on the Channel column using VLOOKUP-like logic. It then summarizes the data by grouping on 'Name' and summing 'Spend ($)', creating an automated pivot table effect. Before appending, it clears the 'render pivot' output tab to prevent duplicates, ensuring a fresh, clean report every run.

Ideal for marketing analysts tracking channel spend across campaigns, small businesses using Google Sheets for reporting, and teams needing daily automated rollups. It eliminates manual pivot table rebuilding, saving hours of repetitive work and reducing errors in data aggregation.

Benefits include seamless Google Sheets OAuth2 integration, no-code summarization, and reliable automation for BI tasks. Setup is straightforward: connect credentials, select sheets/worksheets, configure group-by and sum fields, then test. Perfect for scheduled daily executions to keep dashboards current.