iRank Backlink Operations Portal
A growing SEO agency ran backlink campaigns entirely in Google Sheets — leadership had no live view of completion rates, daily production, or team performance without opening dozens of spreadsheets manually.
We built a production internal tool where SEO team members keep working in familiar Google Sheets while CEO and managers get real-time visibility. Every sheet row syncs permanently to the database via CSV export, with automated cron sync, role-based dashboards, and full audit trails.
The Challenge
Backlink teams worked in disconnected Google Sheets with no centralized progress view. Managers could not compare today vs yesterday production, track per-employee output, or monitor client project completion without manual sheet audits.
Our Solution
A custom PHP MVC portal linking sheet assignments to projects and employees. A SheetSync engine reads public Google Sheet CSV exports, maps backlink columns, stores every row permanently, and powers CEO and manager dashboards with completion %, daily production diffs, and sync logs.
The Results
- Google Sheets → MySQL sync with automated cron jobs
- CEO dashboard — completion %, today vs yesterday production
- Permanent sheet row history survives source sheet changes
- Role-based access for CEO and managers
- Daily, weekly & monthly reports with CSV export
- Employee performance tables with project & sheet counts
Platform Integrations
Connected systems that keep the organization running from one hub.
Sheets stay the workspace
Employees keep working in Google Sheets — the portal syncs CSV exports every 10 minutes without changing their workflow.
Always up to date
Automated background sync pulls latest rows, logs status, and alerts when sheets fail or fall behind.
Production at a glance
Daily, weekly, and monthly reports with per-employee breakdowns — exportable for client updates.
More case studies
View all
EdTech · Enterprise
Enterprise Operations & Intelligence Platform
A large online education organization ran on spreadsheets, WhatsApp groups, and disconnected tools — support, student success, classroom, HR, finance, and media all in separate silos with no single view for leadership.
Read Case Study
SaaS · MarTech
B2B Lead Generation & Outreach Platform
Agencies and solo operators were stitching together Maps scrapers, audit tools, spreadsheets, and email clients just to find local business leads and pitch them — slow, fragmented, and impossible to scale.
Read Case Study
PropTech · FinTech
Real Estate Partnership Management System
A two-partner real estate business tracked property purchases, construction costs, vendor payments, and sale proceeds through Urdu notes, paper receipts, and spreadsheets — with no reliable view of who invested what or who owed whom after each deal.
Read Case StudyHave a similar idea?
Tell us what you need built — free 30-minute call, no commitment.