Aggregate marketing spend data with custom pivots & VLOOKUPs in Google Sheets
This workflow transforms raw marketing data from Google Sheets into a pivot-like summary table. It merges lookup data, groups spend by name, and appends the results into a clean reporting tab — all automatically, with...
Template notes
This workflow transforms raw marketing data from Google Sheets into a pivot-like summary table. It merges lookup data, groups spend by name, and appends the results into a clean reporting tab — all automatically, without needing to manually build pivot tables in Sheets.
---
🧑💻 Who’s it for - Marketing analysts who track channel spend across campaigns - Small businesses that rely on Google Sheets for reporting - Teams that need automated daily rollups without rebuilding pivot tables manually
---
⚙️ How it works 1. Get Marketing Data (Google Sheets) – Pulls raw spend data. 2. Vlookup Data (Google Sheets) – Brings in reference/lookup fields (e.g., channel labels). 3. Merge Tables – Joins marketing data and lookup data on the Channel column. 4. Summarize – Groups data by Name and sums up Spend ($). 5. Clear Sheet – Wipes the reporting tab to avoid duplicates. 6. Append to Pivot Sheet – Writes the aggregated results into the "render pivot" sheet.
The result: a pivot-style summary table inside Google Sheets, automatically refreshed by n8n.
---
🔑 Setup Instructions