{"product_id":"n8n-workflow-unify-acquisition-data-to-postgres-sheets-pm-bi","title":"n8n Workflow: Unify Acquisition Data to Postgres (Sheets + PM + BI)","description":"\u003ch3\u003eUnify acquisition data into a single Postgres source of truth (hourly)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls acquisition records from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, a \u003cstrong\u003ePM tool API\u003c\/strong\u003e (Asana\/Monday\/ClickUp), and a \u003cstrong\u003edashboard\/BI export API\u003c\/strong\u003e, normalizes them into one shared schema, merges and deduplicates the results, and writes the consolidated dataset into \u003cstrong\u003ePostgres\u003c\/strong\u003e—with optional internal dashboard refresh and \u003cstrong\u003eSlack\u003c\/strong\u003e alerts when conflicts are detected.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e using scheduled triggers to start a complete sync.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches acquisition rows from Google Sheets\u003c\/strong\u003e and maps key fields into a shared acquisition schema (including \u003cem\u003esource\u003c\/em\u003e, \u003cem\u003erecord_id\u003c\/em\u003e, \u003cem\u003eowner\u003c\/em\u003e, \u003cem\u003estatus\u003c\/em\u003e, \u003cem\u003eamount\u003c\/em\u003e, \u003cem\u003elast_updated\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the PM tool API over HTTP\u003c\/strong\u003e and maps task\/deal fields into the same common schema.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the dashboard\/BI export API over HTTP\u003c\/strong\u003e and maps metric\/pipeline fields into the shared schema as well.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCombines, validates, and deduplicates\u003c\/strong\u003e the three normalized datasets into a single stream.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites consolidated records to Postgres\u003c\/strong\u003e (the unified “source of truth” table).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers an internal dashboard refresh\u003c\/strong\u003e endpoint and \u003cstrong\u003eposts to Slack\u003c\/strong\u003e when conflicts are detected.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep CRM\/pipeline reporting consistent by merging acquisition data from Sheets, your PM tool (Asana\/Monday\/ClickUp), and BI exports.\u003c\/li\u003e\n  \u003cli\u003eDetect and resolve data conflicts when the same acquisition appears with mismatched fields across sources.\u003c\/li\u003e\n  \u003cli\u003eProvide SaaS operators and automation engineers a reliable, hourly ETL-style pipeline feeding a Postgres analytics table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth), HTTP requests to PM tool APIs (Asana\/Monday\/ClickUp), HTTP requests to dashboard\/BI export APIs, Postgres, Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes \/ components:\u003c\/strong\u003e set, code, merge, slack, postgres, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e normalize → merge → dedupe\/validation → write to Postgres → refresh dashboard → Slack conflict alerts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45878611935411,"sku":"N8N-18558","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lV8Ud_QT2GJw8DHptWxkE_vogMHbgd.png?v=1787389596","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-unify-acquisition-data-to-postgres-sheets-pm-bi","provider":"N8N Commerce","version":"1.0","type":"link"}