Smartlead Google Sheets Email Analytics Marketing Automation n8n

Automate Cold Email Analytics: Smartlead to Google Sheets

Sync lead-level engagement metrics—opens, clicks, replies, unsubscribes—into a live Google Sheet for dashboards, reporting, and sales prioritization.

Download Template JSON · n8n compatible · Free
Diagram showing Smartlead email analytics data flowing into Google Sheets dashboard

What This Workflow Does

This automation solves a critical problem for sales and marketing teams: fragmented email campaign data. Manually checking Smartlead for opens, clicks, and replies, then copying that data into a spreadsheet is slow, error-prone, and doesn't scale.

This n8n workflow automatically pulls lead-level engagement statistics from your Smartlead campaigns and syncs them into a structured Google Sheet. It handles pagination, prevents duplicates, and updates existing records, giving you a single, always-current source of truth for campaign performance.

The result is a live analytics dashboard that your entire team can access without needing Smartlead logins, enabling data-driven decisions on follow-up timing, sequence optimization, and lead prioritization.

How It Works

The workflow runs on a schedule you set (e.g., hourly or daily) and follows a clear, reliable process.

1. Schedule Trigger & Pagination Setup

A schedule node initiates the workflow. A Code node then generates pagination parameters (offset and limit) to ensure all campaign data is fetched in manageable batches, avoiding API timeouts.

2. Fetch Data from Smartlead API

For each batch, an HTTP Request node calls the Smartlead API endpoint (/campaigns/{campaign_id}/statistics) with your API key, retrieving structured JSON data for each lead in the campaign.

3. Process & Transform Records

A Split Out node separates the API response array into individual lead records. Each record contains fields like lead name, email, sequence step, open count, click time, reply status, and a unique stats_id.

4. Update Google Sheets

The Google Sheets node uses the "Append or Update" operation. It matches incoming records by the stats_id field. If a matching row exists, it updates the metrics; if not, it appends a new row. This prevents duplicate entries.

5. Loop & Complete

The workflow loops through all batches until all data is processed, then completes. You now have a refreshed Google Sheet ready for analysis.

Pro tip: Set this workflow to run daily in the early morning. Your sales team will start their day with yesterday's engagement data already summarized and waiting in their shared dashboard.

Who This Is For

This template is ideal for:

  • Sales Teams & SDRs: Who need to quickly identify and act on engaged leads from cold email campaigns.
  • Marketing Operations: Professionals who must report on email campaign performance across sequences and time periods.
  • Startups & Small Businesses: Running outbound sales campaigns without a dedicated data analyst, needing simple, automated reporting.
  • Agencies: Managing cold email for multiple clients, requiring consolidated reporting outside of the Smartlead interface.
  • Operations Managers: Looking to create a centralized data hub by combining email engagement with other lead sources.

What You'll Need

  1. A Smartlead account with an active campaign and API access.
  2. Your Smartlead API key and the specific Campaign ID you want to track.
  3. A Google account with a Google Sheet ready (we provide the exact column structure).
  4. n8n credentials set up for the Google Sheets node (OAuth2).
  5. Basic familiarity with n8n to import the JSON template and paste in your credentials.

Quick Setup Guide

Follow these steps to get your automation running in under 15 minutes:

  1. Download the template using the button above and import it into your n8n instance.
  2. Create your Google Sheet with the tab name "EngagedLeads" and these exact headers in row 1: lead_name, lead_email, lead_category, sequence_number, stats_id, email_subject, sent_time, open_time, click_time, reply_time, open_count, click_count, is_unsubscribed, is_bounced.
  3. Configure credentials: Add your Smartlead API key and connect your Google account in n8n's credential management.
  4. Set your Campaign ID: In the HTTP Request node, replace {campaign_id} with your actual Smartlead campaign ID.
  5. Map the Google Sheet: Point the Google Sheets node to your new sheet and the "EngagedLeads" tab. Set the "Matching Column" to stats_id.
  6. Test & Activate: Execute the workflow once manually to verify data flows correctly, then activate the schedule trigger for automatic daily updates.

Key Benefits

Eliminate Manual Reporting: Save 5-10 hours per week previously spent on manual data exports and spreadsheet updates. This time can be redirected to analyzing results and optimizing campaigns.

Improve Sales Response Time: With engagement data updating automatically, sales reps can identify and contact "hot" leads (high opens/clicks/replies) within minutes instead of days, significantly increasing conversion rates.

Centralize Your Data: Break down data silos by having your email performance data live alongside other business metrics in Google Sheets, ready for combined analysis in Looker Studio or other BI tools.

Scale Campaign Analysis: Easily track performance across multiple campaigns and sequences without switching tabs or running complex exports. Compare subject line performance, sequence effectiveness, and team performance in one place.

Build Custom Alerts & Triggers: Use the clean data in Sheets to power other automations—like sending a Slack notification when a lead replies, or creating a CRM task when a lead clicks a key link.

Frequently Asked Questions

Common questions about cold email analytics and automation

Tracking engagement metrics like opens, clicks, and replies is crucial for sales teams to measure campaign effectiveness, prioritize follow-ups, and understand lead intent. Without automation, manually compiling this data from Smartlead into a spreadsheet is time-consuming and error-prone, leading to missed opportunities and delayed responses.

Automated tracking ensures your team acts on fresh data. For example, a lead who opens an email three times and clicks a pricing link is significantly warmer than one who doesn't open at all. This workflow surfaces those signals instantly.

The most important metrics are open rate, click-through rate, reply rate, unsubscribe rate, and bounce rate. Opens indicate interest, clicks show deeper engagement with your content, replies signal high intent, while unsubscribes and bounces help clean your list.

Tracking these per lead and per sequence step gives you actionable insights for optimization. For instance, if your open rate is high but reply rate is low, your subject lines might be good but your email body or call-to-action needs work.

Automation creates a single source of truth that updates in real-time. This eliminates manual exports and copy-pasting, reduces errors, and allows you to build live dashboards in Google Sheets or connect to BI tools like Looker Studio.

Sales and marketing teams can instantly see performance trends without logging into Smartlead. You can create pivot tables to analyze performance by campaign, sequence step, or lead source, and share these insights company-wide with view-only access.

Absolutely. Once your engagement data is in Google Sheets, you can use n8n to connect it to CRMs like HubSpot or Salesforce. For example, you can automatically tag leads as 'Hot' if they opened 3+ emails and clicked a link, or create a task for a sales rep when a lead replies.

This creates a seamless lead scoring and follow-up system. You can also trigger Slack notifications, add leads to specific email sequences, or update custom fields in your CRM based on engagement behavior, creating a truly responsive sales process.

While Smartlead provides dashboards, n8n gives you complete control over your data. You can combine email metrics with data from other sources (like website visits or CRM status), customize calculations, set up custom alerts, and build reports tailored to your specific business processes.

It breaks data out of silos for a holistic view. For instance, you could correlate email engagement with demo attendance or purchase history from your CRM, giving you a 360-degree view of lead engagement that no single platform provides.

For most sales teams, a daily sync is sufficient to keep data fresh without hitting API limits. For high-volume campaigns or teams needing near real-time alerts, you can run the workflow every few hours.

The template includes pagination to handle large datasets reliably during each sync. Consider your team's workflow: if sales reps check leads first thing each morning, a nightly sync ensures updated data. If they need instant notifications, consider more frequent runs combined with alerting automations.

Yes, GrowwStacks specializes in building tailored automation solutions. We can create custom workflows that connect Smartlead with your CRM, add lead scoring logic, set up Slack alerts for high-intent leads, or build comprehensive dashboards that combine email metrics with other sales data.

Every business has unique processes. We can adapt this template to include custom fields, integrate with your internal tools, add conditional logic for different lead segments, or create automated reporting emails for your leadership team. Book a free consultation to discuss your specific needs.

  • Connect email engagement to your existing CRM or marketing stack
  • Build custom lead scoring models based on engagement patterns
  • Create automated daily/weekly performance reports for stakeholders

Need a Custom Cold Email Analytics Automation?

This free template is a starting point. Our team builds fully tailored automation systems for your specific business needs.

Get Free Consultation → Browse More Workflows