Smartlead email campaign analytics dashboard with Google Sheets integration
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. H...
Template notes
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: