From Spreadsheets to Automation: Unifying Tatler's Data Pipeline
Tatler Asia runs high-impact marketing campaigns across diverse regional markets. Proving ROI to their clients requires precise, periodic tracking of content performance and pageviews. However, as the volume of campaigns grew, their manual reporting process became too tedious to scale. So we engineered a fully automated workflow to unify their fragmented data and deliver strategic insights on autopilot.
Client
Tatler Asia
Sector
Media
Scope
Web Development
Problem & Solution
The Problem: The Spreadsheet Grind
Tatler’s client service team was drowning in tedious manual reporting. Tracking article pageviews meant cross-referencing three separate Google Sheets: one for editor targets, one for metadata, and one for the actual performance data.
The team had to manually link this data to ensure consistency, calculate how close an article was to its target, format the insights, and manually email the respective editors. Filtering out articles that had already hit their targets created constant administrative friction.
This fragmented workflow wasn't just slow and error-prone; it was actively bottlenecking their ability to take on new clients and scaling their operations.
The Solution: Automated Data Pipeline
We developed a zero-touch reporting system utilizing n8n and Google Sheets. The new pipeline handles the data manipulation and logic, entirely eliminating the administrative grind.
One-Time Campaign Onboarding
Teams simply enter an email and URL once to onboard a client, completely automating the reporting cycle.
Automated Data Unification
The system automatically pulls, links, and unifies fragmented data across multiple Google Sheets.
Smart Performance Logic
Instantly calculates metrics against targets, categorizing performance and filtering completed goals.
Scheduled Report Delivery
Formats and sends reports automatically to designated editors without any manual intervention.
Results
100
%
Manual Reporting Eliminated
Tedious data extraction was completely replaced by a system that generates and sends reports itself.
3
times a week
Reliable Thrice-Weekly Delivery
Automated schedules guarantee reports are delivered every Monday, Wednesday, and Friday on time.
Reclaimed Strategic Focus
Client service managers now spend their time on strategic planning instead of repetitive data chores.
Instead of boiling the ocean that Tatler Asia serves, we focused on a single region first to map out the architecture. We audited their three fragmented spreadsheets (targets, metadata, and live performance data) and structured a unified database model so that pageviews could be reliably matched to specific article links without breaking.
Phase 2: Workflow Engineering with n8n
We utilized n8n (a node-based workflow automation tool) to build a robust data manipulation pipeline. The system was designed to automatically ingest the Google Sheets data and run the necessary matching operations, ensuring that the final reports were always generated from a single, clean source of truth.
Phase 3: Building the Business Logic
We programmed specific logic modules within n8n to track campaign progress intelligently. The workflow calculates performance tiers (e.g., highlighting if a campaign is at 10% vs. 80% of its target) and runs a conditional check to automatically drop articles from the reporting queue once they successfully hit their 100% target.
