What does this Make.com template do?
Every Monday at 7am, pulls last-week metrics from GA4 (sessions, conversions), ad platforms (spend, CPL), and HubSpot (MQLs, SQLs, deals created). Writes to a Google Sheet tab and emails a formatted HTML summary to marketing leadership — no manual screenshot assembly.
What's included
- Make.com blueprint JSON
- Sheet template with WoW delta formulas
- HTML email template with metric blocks
- Metric definition glossary
Common use cases
- Fractional CMO reporting — One email replaces five dashboard links for clients.
- Internal marketing standup — Consistent numbers before the Monday pipeline review.
- Board prep — Export sheet tab to slides each month.
How to import into Make.com
- 1
Download the blueprint JSON
Use the Download Template button and open the file from the email we send you.
- 2
Import in Make.com
Make.com → Scenarios → Create a new scenario → ⋮ menu → Import Blueprint → select the JSON file.
- 3
Connect apps & credentials
Open each module and authenticate the apps listed in the prerequisites section.
- 4
Map fields and variables
Replace placeholder sheet columns, webhook URLs, or filter values with your account IDs.
- 5
Run once manually
Execute the scenario with test data before switching on scheduling.
How to customize for your stack
Add paid social from Meta API
Parallel branch aggregates Meta spend and leads into same sheet row.
Operator note: Define metric ownership before automating — arguments about MQL definition kill digest trust.
Anton Chisliuk · AI Marketing Ops · Updated September 2026