AutomationMart
Home/Browse/Smartlead email campaign analytics dashboard with Google Sheets integration
n8n

Smartlead email campaign analytics dashboard with Google Sheets integration

n8nn8n14 modulesv1.0
Google Sheets

Workflow 1: Domain and Email Health 🩺 This part of the workflow is triggered every 5 hours by the Schedule Trigger1 node. Its purpose is to pull health metrics for both email domains and individual email addresses. How it Works: ++Schedule Trigger:++ The Schedule Trigger1 node initiates the workflow every 5 hours. ++API Requests:++ Two separate HTTP Request nodes, HTTP Request5 and HTTP Request6, make API calls to Smartlead. ++HTTP Request5 calls++ the endpoint for domain-wise health metrics. ++

At a glance

Smartlead email campaign analytics dashboard with Google Sheets integration is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets
Modules
14
Price
Free
Version
v1.0
Smartlead email campaign analytics dashboard with Google Sheets integration workflow diagram

About this workflow

Workflow 1: Domain and Email Health 🩺 This part of the workflow is triggered every 5 hours by the Schedule Trigger1 node. Its purpose is to pull health metrics for both email domains and individual email addresses. How it Works: ++Schedule Trigger:++ The Schedule Trigger1 node initiates the workflow every 5 hours. ++API Requests:++ Two separate HTTP Request nodes, HTTP Request5 and HTTP Request6, make API calls to Smartlead. ++HTTP Request5 calls++ the endpoint for domain-wise health metrics. ++HTTP Request6 calls++ the endpoint for email-wise health metrics. Both requests use the same apikey and a date range from 2025-07-04 to the current day. ++Data Splitting:++ The Split Out5 and Split Out6 nodes take the JSON response from the API calls and split the data into individual items. This is necessary so each row of data can be processed and added to Google Sheets separately. ++Google Sheets Integration:++ Finally, the Append or update row in sheet5 and Append or update row in sheet6 nodes update two different Google Sheets: ++Append or update row in sheet5 adds++ or updates rows in the DomainHealth sheet, matching on the domain column. ++Append or update row in sheet6 adds++ or updates rows in the EmailHealth sheet, matching on the fromemail column. Workflow 2: Global and Campaign-Specific Analytics 📊 This second part of the workflow is triggered every 2 hours by the Schedule Trigger node. Its goal is to get a day-by-day overview of email engagement and campaign-specific performance. How it Works: Schedule Trigger: The Schedule Trigger node starts this workflow every 2 hours. ++API Requests:++ Two HTTP Request nodes, HTTP Request and HTTP Request1, call different Smartlead API endpoints. ++HTTP Request++ retrieves day-wise overall stats for email engagement. ++HTTP Request1 ++retrieves overall stats for each campaign. ++Data Splitting:++ The Split Out and Split Out1 nodes separate the JSON responses into individual data items for processing. ++Google Sheets Integration:++ The Append or update row in sheet and Append or update row in sheet1 nodes then write the data to Google Sheets. ++Append or update row in sheet++ updates the Sheet1 sheet with day-wise metrics, using the date as a matching column. ++Append or update row in sheet1++ updates the CampaignWise sheet with campaign performance metrics, using the campaign id to match rows.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create and publish SEO blog posts using Google Sheets, Gemini/OpenAI, Ideogram, and WordPress

This workflow automates the complete blog publishing process. It removes manual work from content creation, image generation, category management, and WordPress publishing by using AI and n8n. It helps agencies, SEO teams, and content creators manage blogs at scale. Key Features - Scheduled or manual blog publishing - Automated topic research and content writing - AI-generated featured and in-content images using Ideogram - Dynamic WordPress category detection and creation - Automatic media uplo

Free

Create Pipefy cards from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new card in Pipefy.

Free

Find covert collaborations on Instagram with Paid Post Detective

🕵️‍♀️ Detect hidden paid collaborations on Instagram Use this template to identify covert paid partnerships in Instagram posts by analyzing the post caption and coauthors. It helps uncover sponsored content—even when it’s not explicitly declared. The template checks for: Sponsored language or indicators in the caption Coauthor usernames, filtering out cases where the product creator is a coauthor (e.g., influencer promoting their own brand) Explicit sponsorship tags, like Instagram’s native

Free

Create a SendX contact from a new Google Sheets spreadsheet row

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a SendX contact. The template uses [this spreadsheet](https://docs.google.com/spreadsheets/d/1Q35CXAEygggqpsCqJmBhh2oWZZE_tfNzciN4rHNtNPA/edit?usp=sharing).

Free

Handle WhatsApp customer inquiries with AI and intent routing

Handle WhatsApp customer inquiries with AI and intent routing (Whatsapp Chatbot) An intelligent, fully customizable WhatsApp customer support chatbot template that works for ANY business - whether you sell fashion, electronics, food, furniture, cosmetics, or anything else. This workflow combines pre-built responses for common queries with AI for complex questions, creating a cost-effective 24/7 customer support solution that adapts to your specific products and services. Who it's for

Free

Automated stale user re-engagement system with Supabase, Google Sheets & Gmail

Built this workflow because most of our users signed up, then vanished after 30 days. It runs daily, grabs those stale users from Supabase, updates a Google Sheet for tracking, and automatically sends each one a personalized HTML email through Gmail to bring them back. All fully automated — so once it’s set up, it quietly does its job in the background. Currently, it only supports Supabase, but the concept should work with any DB or API if you swap out the request node.

Free

Repurpose viral content into AI visuals and post to Instagram and Facebook with Blotato

Description Automatically turn any viral content URL (Blog, YouTube, TikTok, etc.) into AI-generated visuals and publish them to multiple social platforms with built-in status validation and async processing control. --- Who is this for? This template is ideal for: - Content creators repurposing viral content - Affiliate marketers scaling content distribution - Social media managers handling multi-platform posting - AI automation builders using n8n + Blotato - Teams that want a URL → Visual → Pu

Free

Build a cost engineering RAG with Google Drive, OpenAI and Pinecone

Quick Overview This workflow ingests PDF cost-engineering manuals from Google Drive into a Pinecone vector index using OpenAI embeddings, then answers user questions via an n8n chat webhook using a retrieval-augmented OpenAI agent that responds only with evidence from the indexed documents. How it works 1. Runs every 2 minutes on a schedule. 2. Lists files in a configured Google Drive “incoming” folder and downloads each document. 3. Extracts text from each PDF, splits it into overlapping chunks

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free