Http Request

Scheduled Smartlead Campaign Leads to Postgres Update

Automate Smartlead.ai lead synchronization to PostgreSQL, instantly updating your database for real-time analysis and improved business decisions.

Http Request
Complex Trigger

This workflow is designed for the scheduled extraction and synchronization of campaign lead data from Smartlead.ai into a PostgreSQL database. It likely begins by fetching campaign IDs and corresponding API keys from a source, then iteratively calls the Smartlead.ai API to export leads for each specified campaign. The `EXTRACT CAMPAIGN DATA` node makes a secure HTTP request to the Smartlead leads-export endpoint, using dynamically provided campaign IDs and API keys. Following the data extraction, the workflow is set up to process these leads, likely in batches using the `Split In Batches` service, before performing an update operation on a PostgreSQL database. This ensures that the local database remains updated with the latest lead information from active Smartlead campaigns, enabling further analysis or integration.

23
Nodes
11
Services
3
Categories
Complex
Type

Get This Workflow

Free n8n workflow template ready to import

Share on social

📄 File Details

0655_Code_Postgres_Update_Scheduled.json
Code
09/04/2025
Ready to Import

Just upload and configure

🔧
Production Ready

Tested and optimized

📚
Documentation

Complete setup guide

Automate Smartlead.ai lead synchronization to PostgreSQL, instantly updating your database for real-time analysis and improved business decisions.

Loading visualization...
Loading target audience...
Loading security notes...
Loading compatibility...

Services & Integrations

Http Request
Split In Batches
Postgres
Merge
Code
Hubspot
If
Schedule Trigger
Sticky Note
Set
Google Sheets
Loading FAQ...

How to Use This Workflow

1

Download the Workflow

Click the "Download Workflow" button above to get the JSON file.

2

Import to n8n

In your n8n instance, go to Workflows → Import and select the JSON file.

3

Configure Credentials

Set up your Http Request and other service credentials in n8n.

4

Activate & Test

Activate the workflow and test it to ensure everything works correctly.

Tags

#code
#http-request
#split-in-batches
#postgres
#complex
#code
#development
#workflow-automation

Ready to transform your business?