π‘ Built in n8n to track ad ROI automatically every day
Ashley Gross, AI consultant and course creator, runs over 30 paid ad campaigns. To avoid wasting money and time, she built an automation in n8n that:
- β° Triggers daily at the same time
- π Pulls data from Stripe, Google Analytics & HubSpot
- π Merges and reformats the data (with code + OpenAI)
- π₯ Saves it to Google Sheets and HubSpot
- π§ Sends her a daily performance summary via email in plain English
This gives her daily insights into:
- Which ads are converting for which courses
- Whatβs driving real ROI β and whatβs underperforming
- If changes (like new ad copy) hurt performance immediately
π― Outcome: No more late-night manual tracking or wasted ad spend.
Video link: