Jawad Chafai · Blog · Free tools · LinkedIn

Sales Pipeline Command Center: A Live RevOps Dashboard

How I connected four disconnected tools into one secure, always-current dashboard so no prospect falls through the cracks.

A live RevOps dashboard that joins four disconnected sales tools into one secure view, so no prospect falls through the cracks. Tracks prospects across 52 companies automatically.

How it works

• Problem: outreach ran across a Google Sheet used as a makeshift CRM, an automated email sequencing platform, a shared Drive folder and website leads, with no single view of the pipeline.
• Build: Google Apps Script syncs and deduplicates the four sources on a schedule, and the dashboard refreshes itself every couple of minutes.
• Access is restricted to company work accounts.
• Shows total pipeline, contact and reply rates, progress against a prospect target, sleeping prospects with no touch in 7 days, meetings booked and email sequence performance.

Jawad Chafai, RevOps and GTM engineer in Morocco. Salesforce Certified Administrator and Salesforce Certified Associate.