This n8n workflow automates the process of extracting, updating, and analyzing campaign and lead data across multiple platforms, including Postgres, HubSpot, and Google Sheets. Designed for marketing and sales teams, it streamlines data collection, synchronization, and reporting to enhance campaign performance tracking.

The workflow begins with a schedule trigger to run at set intervals. It retrieves campaign data from an API (SmartLead), fetching all campaigns and then extracting specific details for each campaign via HTTP requests. This data is processed through custom JavaScript code nodes that parse CSV and JSON inputs, transforming raw data into structured formats suitable for database operations.

Key steps include upserting campaign details into a Postgres database, updating lead activities, and synchronizing lifecycle stages and counts with HubSpot and Google Sheets. The workflow intelligently checks for missing or outdated data, such as missing HubSpot lifecycle stages, to decide whether updates are necessary.

It facilitates real-time reporting and analytics by consolidating data from multiple sources into a central database and populating Google Sheets for visualization. Such automation helps marketing and sales teams maintain accurate, current insights into campaign effectiveness, lead engagement, and pipeline health.

This setup is especially useful for continuously monitoring multi-channel campaigns, optimizing outreach strategies, and maintaining clean data across CRMs and marketing platforms.