--- title: "Build a Free Cold Email Dashboard from the Smartlead API" description: "API to Sheets to Looker Studio: every campaign, every client, your own metric definitions, for free. The full extraction schema." url: https://warminboxes.com/blog/cold-email-dashboard-smartlead-api breadcrumb: "Home > Blog > Build a Free Cold Email Dashboard from the Smartlead API" --- [WarmInboxes.com](https://warminboxes.com/) [Offer](https://warminboxes.com/offer) [Free Leads](https://warminboxes.com/leads) [Free Tools](https://warminboxes.com/deliverability-tools) [Blog](https://warminboxes.com/blog) [Reviews](https://warminboxes.com/reviews) [Home](https://warminboxes.com/) › [Blog](https://warminboxes.com/blog) › Build a Free Cold Email Dashboard from the Smartlead API [Back to Blog](https://warminboxes.com/blog) Analytics 4 min read July 20, 2026 # Build a Free Cold Email Dashboard from the Smartlead API (Sheets + Looker Studio) Sequencer dashboards show you what the sequencer wants to show you, one workspace at a time, with metrics you cannot redefine. Pulling the raw data through the API into Google Sheets and Looker Studio gets you every campaign, every client, and your own definitions, for free. Here is the whole build. [Huzayfa Majeed](https://warminboxes.com/authors/huzayfa-majeed) Cold Email Expert · WarmInboxes ![Building a cold email dashboard from the Smartlead API]() ## Quick Answer: API → Sheets → Looker Studio, Daily A scheduled job (Apps Script or n8n) pulls campaigns, sends, bounces, replies, and lead statuses from the **Smartlead API into Google Sheets daily**, one row per campaign per day, idempotent. **Looker Studio renders it free.** Track the [reply-rate ladder](https://warminboxes.com/blog/positive-reply-rate-cold-email) and bounce rate; exclude opens and clicks on purpose. Same model absorbs Instantly's API, one dashboard across every workspace and client. ## The Schema That Makes It Work Sheets tabs (v1, extendable) campaigns_daily: date | workspace | client | campaign_id | campaign | prospects_contacted | sends | hard_bounces | replies_total | replies_human | replies_positive | meetings replies_log: date | campaign_id | prospect_email | intent | confidence | summary (from the classifier) computed (formulas / Looker): bounce_rate = hard_bounces / sends positive_rr = replies_positive / prospects pos_to_meeting = meetings / replies_positive - •**One row per campaign per day** is the grain that answers every question later: trends, week-over-week, per-client rollups, and incident forensics ("what changed on the 14th?"). - •**Idempotent writes:** the job deletes-then-writes its date's rows so re-runs never duplicate. This one decision prevents 90% of dashboard rot. - •**Client column from day one** even if you have one client today. Agencies grow into it; retrofitting is painful. - •**Intent from the [classifier](https://warminboxes.com/blog/ai-cold-email-reply-classifier)** upgrades replies_total into the honest ladder. Ship v1 without it, but leave the columns. ## The Looker Studio Layer Connect the Sheet as a data source and build four views: a **program overview** (all campaigns, the ladder metrics, 30-day trend), a **campaign drilldown** (daily series for one campaign), a **client view** (filtered by the client column, shareable as a read-only link, which quietly becomes your client reporting), and an **alarm view** (any campaign with bounce rate above 3% or positive rate collapsing week over week, per the [stop rules](https://warminboxes.com/blog/cold-email-bounce-rate-pause-rules)). The alarm view is the one you check daily; the rest exist for weekly reviews and clients. **The strategic reason to own your data layer:** sequencers change pricing, change dashboards, and get migrated away from. Every month of history in your own Sheet is a month you keep when that happens, and cross-tool comparisons (is Smartlead or Instantly performing better for this client?) only exist if both feed one model. The dashboard is a few hours of build; the data ownership is permanent. Next step once this runs: break the same numbers down [by domain, inbox, and recipient provider](https://warminboxes.com/blog/track-cold-email-performance-by-domain-inbox-provider), which is where the diagnostic power really lives. ## Frequently Asked Questions ### How do I build a dashboard from the Smartlead API? Three layers: extraction, storage, visualization. A scheduled script (Apps Script inside Sheets, or n8n/Make on a timer) calls the Smartlead API for campaigns, sends, bounces, replies, and lead statuses, and appends rows into Google Sheets, one tab per entity, one row per day per campaign. Looker Studio connects to the Sheet free and renders the charts. Instantly's API follows the same shape, so an agency running both tools lands everything in one model. Under 100 campaigns, Sheets is plenty; past that, swap the storage layer for BigQuery and keep everything else. ### What metrics should the dashboard track? Per campaign per day: prospects contacted, sends, hard bounces, total replies, human replies, positive replies, and meetings. From those, the computed layer: bounce rate, the reply-rate ladder, and trendlines. Deliberately exclude opens and clicks, bots inflate them and they will poison decisions. The win over the native dashboard is definitional control: positive reply rate calculated YOUR way, per prospect, consistently across every workspace. ### How do I get positive replies into the dashboard when the API only reports replies? The API gives you reply events and text; classification is your layer. Route replies through an intent classifier (an LLM step in the same n8n flow works) and write the category back as a column, then the dashboard aggregates by intent. Without classification you can still ship v1 with total replies and add the intent column later, the schema should anticipate it from day one. ### How often should the extraction run? Daily is right for reporting, hourly adds nothing but API load since decisions are made on daily trends. Run it early morning for yesterday's complete numbers. Two robustness rules: make the job idempotent (re-running a day overwrites that day, not appends duplicates), and log failures somewhere visible, a silent extraction failure that gaps your data for a week is the classic way these dashboards die. ### Is this worth it versus paying for a reporting tool? The build is a few hours and the run cost is zero, versus per-seat pricing for outbound reporting SaaS that still will not match your metric definitions. The real value is agency-shaped: one dashboard across every client workspace, client-facing filtered views, and metrics that survive switching sequencers, because the moment you migrate tools, your history lives in your Sheet, not their UI. ## Get FREE .com Domains Prewarmed Inboxes So You Can Send Cold Emails Today [Get Prewarmed & Fresh Inboxes](https://app.warminboxes.com) ## Related Articles [Analytics ### Positive Reply Rate: The Metric Ladder 4 min read](https://warminboxes.com/blog/positive-reply-rate-cold-email)[Analytics ### Track Performance by Domain, Inbox, and Provider 5 min read](https://warminboxes.com/blog/track-cold-email-performance-by-domain-inbox-provider)[Automation ### Build an AI Cold Email Reply Classifier 5 min read](https://warminboxes.com/blog/ai-cold-email-reply-classifier) ## Prewarmed & Fresh Inboxes Google, Microsoft 365 and Azure inboxes with free prewarmed domains and DNS configured before you log in. Prewarmed inboxes send the day they land; every order is delivered within 48 to 72 hours. [Get Prewarmed & Fresh Inboxes](https://app.warminboxes.com) More from WarmInboxes [Google Workspace Inboxes](https://warminboxes.com/google-workspace-inboxes)[Microsoft 365 Inboxes](https://warminboxes.com/microsoft-365-inboxes)[Azure Inboxes](https://warminboxes.com/azure-inboxes)[Deliverability](https://warminboxes.com/deliverability)[Terms of Service](https://warminboxes.com/terms)[Privacy Policy](https://warminboxes.com/privacy)[Developers](https://warminboxes.com/developers)[For AI Agents](https://warminboxes.com/for-ai)[Inboxes for Instantly](https://warminboxes.com/instantly-inboxes)[Inboxes for PlusVibe](https://warminboxes.com/plusvibe-inboxes)[Inboxes for Smartlead](https://warminboxes.com/smartlead-inboxes)[Inboxes for EmailBison](https://warminboxes.com/emailbison-inboxes)[Inboxes for Apollo](https://warminboxes.com/apollo-inboxes)[Inboxes for ManyReach](https://warminboxes.com/manyreach-inboxes)[Inboxes for Claude](https://warminboxes.com/claude-inboxes)[Inboxes for ChatGPT](https://warminboxes.com/chatgpt-inboxes)[Inboxes for Grok](https://warminboxes.com/grok-inboxes)[About](https://warminboxes.com/about)[Huzayfa Majeed](https://warminboxes.com/authors/huzayfa-majeed)[How it works](https://warminboxes.com/how-it-works)[Deliverability Hub](https://warminboxes.com/deliverability-hub)[Studies](https://warminboxes.com/research)[Placement Test Log](https://warminboxes.com/research/inbox-placement-log)[Top-Level Domains](https://warminboxes.com/research/google-sender-reputation)[SURBL Study](https://warminboxes.com/research/surbl-blocklist-study)[Playbooks](https://warminboxes.com/playbooks)[Calculator](https://warminboxes.com/calculator)[Consultation](https://warminboxes.com/consultation)[Affiliate Program](https://warminboxes.com/affiliate)[Tool demos](https://warminboxes.com/videos)[Testimonials](https://warminboxes.com/testimonials)[Reddit Reviews](https://warminboxes.com/reddit)[Prewarmed on Reddit](https://warminboxes.com/prewarmed/reddit)[Inboxes on Reddit](https://warminboxes.com/inboxes/reddit)[Revenue Boost](https://warminboxes.com/revenueboost)[MailFirst](https://warminboxes.com/mailfirst)[Agency Advanta](https://warminboxes.com/agencyadvanta)[Liquid Syntax Guide](https://warminboxes.com/playbooks/liquid-syntax-guide)[The SPAM Plague](https://warminboxes.com/playbooks/spam-plague-segmentation-playbook)[Inboxing Playbook](https://warminboxes.com/inboxing-playbook)[Data Ops Hub](https://warminboxes.com/hub/data-ops)[Agency Hub](https://warminboxes.com/hub/cold-email-agency) Contact [WhatsApp +1 904 736 2539](https://api.whatsapp.com/send/?phone=19047362539&text=Hey%2C%20I%20need%20WarmInboxes&type=phone_number&app_absent=0) · [support@warminboxes.com](mailto:support@warminboxes.com) · Pembroke Pines, FL 33024, USA