Sync PostgreSQL customer changes with HubSpot, Mailchimp, and Slack

by Oneclick AI Squad ✓ · 0 views · created 2026-10-05 · Engineering

What this workflow does

This workflow has 25 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Postgres.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).

1. Postgres: run a query
2. Set Sync Config (Edit Fields (Set)): sets 10 fields: batchSize, leaseSeconds, maxAttempts…
3. Code: runs custom JavaScript code
4. Postgres: run a query
5. Is Requeue Request Valid? (If): checks a condition and branches into true / false
6. Events Claimed? (If): checks a condition and branches into true / false
7. Postgres: run a query
8. Respond - Requeue Validation Error (Respond to Webhook): sends the response back to the webhook caller
9. Code: runs custom JavaScript code
10. Respond - Requeue Result (Respond to Webhook): sends the response back to the webhook caller

…plus 11 more steps. See the full node list below.

Services it uses

Postgres

Before you upgrade to n8n 3.0

Nodes used (12)

• Manual Triggern8n-nodes-base.manualTrigger
• Postgresn8n-nodes-base.postgres
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Switchn8n-nodes-base.switch
• HTTP Requestn8n-nodes-base.httpRequest
• No Operation, do nothingn8n-nodes-base.noOp
• Webhookn8n-nodes-base.webhook
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

Quick overview This workflow captures INSERT/UPDATE/DELETE changes from PostgreSQL via an outbox table and syncs them to HubSpot, Mailchimp, and Slack on a 1-minute schedule, with leasing, retries with exponential backoff, dead-letter alerting, and a webhook…

View the original on n8n.io → Check your own copy