Smartlead Campaign and Mailbox Analytics to Google Sheets Dashboard Sync - n8n Workflow

• Sales Operations Managers requiring automated performance reporting.


• Cold Emailing Agencies needing centralized analytics dashboards.


• Digital Marketing Teams looking for continuous tracking of email engagement metrics.


• Users searching for efficient n8n templates for data synchronization and analysis.

This advanced n8n workflow solves the complexity of manual data aggregation for high-volume cold outreach campaigns managed through Smartlead. It establishes a robust, real-time analytics dashboard in Google Sheets by frequently polling four separate Smartlead API endpoints. This complex n8n workflow ensures sales and marketing teams have up-to-the-minute data on critical KPIs, including domain health, individual mailbox performance, and overall campaign metrics (opens, replies, bounces, positive replies). By deploying this comprehensive n8n template, users establish a crucial foundation for detailed performance monitoring and data visualization, significantly reducing manual data handling and ensuring data freshness. The efficiency of this n8n node configuration ensures timely updates across all required data sets.

The system utilizes two periodic n8n trigger nodes to manage data synchronization across four parallel branches at different frequencies, ensuring optimal resource use and data timeliness.

1. Mailbox Health Synchronization (Every 5 Hours):

1. Global & Campaign Performance Synchronization (Every 2 Hours):

1. Import the n8n workflow: Copy the provided JSON code and import it into your n8n instance using the 'New' button and 'Import from JSON' option.


2. Configure Credentials:

1. Adjust Date Parameters: Review the hardcoded start dates (e.g., 2025-07-04) and dynamic end dates (e.g., =2025-08-{{ $json['Day of month'] }}) in the HTTP Request n8n node parameters and adjust them to your desired reporting period.


2. Activate: Save the n8n workflow and set the workflow to 'Active' to start the automated syncing process according to the defined n8n trigger intervals.

This n8n workflow leverages several core n8n node types for scheduling, API integration, data manipulation, and storage:

Schedule Trigger (n8n trigger): Two instances are used. One runs every 5 hours for mailbox health, and the other runs every 2 hours for campaign and global stats, defining the cadence of the entire n8n workflow.
HTTP Request (n8n node): Four instances connect to the Smartlead API. Each is configured to fetch a distinct analytics data set (Domain Health, Email Health, Day-wise Overall Stats, Campaign Overall Stats). Key configuration involves passing the required apikey and dynamic date range parameters.
Split Out (n8n node): Four instances are essential for taking the array structure returned by the Smartlead API and turning it into individual items. This allows the subsequent Google Sheets n8n node to process and update one row per domain, email, or campaign efficiently.
Google Sheets (n8n node): Four instances perform the critical data persistence layer. The operation is set to Append or update row in sheet. This intelligent update feature requires specifying a matching column (e.g., domain, fromemail, date, or id) to prevent creating duplicate entries upon each n8n trigger execution. Data fields are mapped using expressions, such as ={{ $json.sent }}.