How to Build a Google Ads Experiment Tracker with N8n & Replit (Google Sheets Database)
Learn how to build a custom Google Ads experiment tracker that automatically emails you test results when they're complete. This complete tutorial shows how freelance PPC manager Joey manages accounts from $2K to $1M monthly spend without ever forgetting to check test results, using N8n automation, Retool front-end, and Google Sheets for data management.
📂 PROJECT FILES:
Get the complete N8n workflows, templates, and setup guides mentioned in this video:
👉 https://www.daveten.ai
🚀 SCALE YOUR AGENCY:
Stop doing manual work. Get the AI systems to automate your ad operations: https://www.daveten.ai
⏰ TIMESTAMPS:
00:00 - The Problem: Forgetting to Check Test Results
00:09 - Joey's Challenge: Managing Multiple Account Changes
00:25 - Why Calendar Reminders Don't Work
01:00 - Solution Overview: Automated Experiment Tracking
01:27 - App Walkthrough: Clean Branded Interface
01:41 - Creating Your First Experiment
02:08 - Multiple Email Notification Setup
02:10 - Slack Integration Options
02:14 - Account Selection Dropdown
02:36 - Choosing KPIs to Track
03:00 - Campaign vs Account Level Tracking
03:24 - Setting Test Date Ranges
03:28 - Automatic Before/After Comparison
03:56 - Creating & Scheduling Experiments
04:15 - Test Results Dashboard
04:39 - Email Notification System
05:05 - Google Sheets Data Storage
05:42 - Part 1: N8n Webhook Workflow
06:42 - Webhook URL Configuration
07:27 - API Key & Authentication
08:20 - No AI - Pure Data Processing
08:52 - Email Report Example
09:04 - Test Pass/Fail Analysis
09:44 - Part 2: Backend Automation
10:09 - Webhook Event Listening
10:38 - Data Processing & Formatting
11:07 - Complete System Architecture
11:32 - Clean UI for Non-Developers
11:50 - Zero Technical Setup Required
12:05 - Final Implementation Tips
🔧 WHAT YOU'LL LEARN:
✅ Build a complete experiment tracking system for Google Ads
✅ Automate email reports for test results
✅ Connect Retool, N8n, Google Sheets, and Google Ads API
✅ Track metric changes automatically over any time period
✅ Create a client-ready branded dashboard
✅ Set up webhooks for real-time data processing
💡 THE BUSINESS PROBLEM:
🚨 What Happens Now:
Make changes across multiple accounts
Forget to check test results weeks later
Lose track of what changes worked
No centralized experiment history
✅ The Solution:
One-click experiment creation
Automatic email on test completion
Before/after metric comparison
Pass/fail analysis based on KPIs
Complete test history in dashboard
🛠️ TECHNICAL ARCHITECTURE:
1️⃣ Retool Frontend:
Beautiful branded interface
Account/campaign selection
Metric selection (clicks, conversions, CTR, etc.)
Test history dashboard with pass/fail status
2️⃣ N8n Automation:
Webhook listener for form submissions
Google Ads API data pulling
Scheduled test completion checks
Email notification formatting
3️⃣ Google Sheets Database:
Test configuration storage
Historical results tracking
Status updates (scheduled/completed)
🎯 KEY FEATURES:
⚙️ Experiment Configuration:
Custom test naming
Multiple email recipients
Flexible date ranges
Choose specific metrics to track
Account or campaign level analysis
📱 Results Delivery:
Automated email on test end date
Pass/fail determination
Percentage change calculations
Before period comparison
Optional Slack notifications
📋 REQUIRED SETUP:
Google Ads Developer Token (one-time)
N8n instance (self-hosted or cloud)
Retool account
Google Sheets access
SMTP for email notifications
#N8n #GoogleAds #ExperimentTracking