n8n Workflow: Unify Acquisition Data to Postgres (Sheets + PM + BI)

Unify acquisition data into a single Postgres source of truth (hourly)

This n8n workflow automatically pulls acquisition records from Google Sheets, a PM tool API (Asana/Monday/ClickUp), and a dashboard/BI export API, normalizes them into one shared schema, merges and deduplicates the results, and writes the consolidated dataset into Postgres—with optional internal dashboard refresh and Slack alerts when conflicts are detected.

What this workflow does

• Runs hourly using scheduled triggers to start a complete sync.
• Fetches acquisition rows from Google Sheets and maps key fields into a shared acquisition schema (including source, record_id, owner, status, amount, last_updated).
• Calls the PM tool API over HTTP and maps task/deal fields into the same common schema.
• Calls the dashboard/BI export API over HTTP and maps metric/pipeline fields into the shared schema as well.
• Combines, validates, and deduplicates the three normalized datasets into a single stream.
• Writes consolidated records to Postgres (the unified “source of truth” table).
• Triggers an internal dashboard refresh endpoint and posts to Slack when conflicts are detected.

Use cases

• Keep CRM/pipeline reporting consistent by merging acquisition data from Sheets, your PM tool (Asana/Monday/ClickUp), and BI exports.
• Detect and resolve data conflicts when the same acquisition appears with mismatched fields across sources.
• Provide SaaS operators and automation engineers a reliable, hourly ETL-style pipeline feeding a Postgres analytics table.

Technical details

• Integrations: Google Sheets (OAuth), HTTP requests to PM tool APIs (Asana/Monday/ClickUp), HTTP requests to dashboard/BI export APIs, Postgres, Slack.
• Workflow nodes / components: set, code, merge, slack, postgres, sticky note.
• Core logic: normalize → merge → dedupe/validation → write to Postgres → refresh dashboard → Slack conflict alerts.