{"product_id":"n8n-weekly-customer-data-sync-check-hubspot-freee-backlog-slack","title":"n8n Weekly Customer Data Sync Check (HubSpot, freee, Backlog, Slack)","description":"\u003ch3\u003eWeekly customer data sync check across HubSpot, freee, Backlog—and one Slack report\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every week to compare customer and billing data between \u003cstrong\u003eHubSpot\u003c\/strong\u003e, \u003cstrong\u003efreee\u003c\/strong\u003e, and \u003cstrong\u003eBacklog\u003c\/strong\u003e, then posts a \u003cstrong\u003esingle formatted mismatch report\u003c\/strong\u003e to \u003cstrong\u003eSlack\u003c\/strong\u003e (or confirms that everything matches).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly\u003c\/strong\u003e (every Monday at 9:00) or can be run manually.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads comparison settings\u003c\/strong\u003e, including lifecycle stage filters, link\/tag prefixes, and relevant IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches HubSpot companies\u003c\/strong\u003e for the configured lifecycle stages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches freee partners\u003c\/strong\u003e, then batch-reads the corresponding \u003cstrong\u003eHubSpot\u003c\/strong\u003e companies using the stored HubSpot link values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks billing\/invoices in freee\u003c\/strong\u003e within a configured lookback window, and—if enabled—reads a target \u003cstrong\u003eBacklog\u003c\/strong\u003e project and recent issues.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares records\u003c\/strong\u003e to find mismatches such as missing links, deleted HubSpot records, differing names\/phones, duplicate partner links, and invoices without matching Backlog tags.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts one Slack message\u003c\/strong\u003e to your configured channel with links to affected HubSpot records, or a “no mismatches found” result.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConfirm that every \u003cstrong\u003efreee partner\u003c\/strong\u003e is correctly linked to the right \u003cstrong\u003eHubSpot company\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eDetect \u003cstrong\u003edata drift\u003c\/strong\u003e after lifecycle stage updates in HubSpot (e.g., missing or deleted companies).\u003c\/li\u003e\n  \u003cli\u003eVerify that \u003cstrong\u003efreee invoices\u003c\/strong\u003e are properly reflected in \u003cstrong\u003eBacklog issues\u003c\/strong\u003e via tags.\u003c\/li\u003e\n  \u003cli\u003eGive your team one weekly, actionable \u003cstrong\u003eSlack\u003c\/strong\u003e notification instead of scattered checks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHubSpot\u003c\/strong\u003e: HubSpot app token\/service key to read account info and companies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003efreee\u003c\/strong\u003e: OAuth2 credentials with read access to partners and invoices (freee company ID required).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBacklog (optional)\u003c\/strong\u003e: Backlog HTTP Query Auth (API key), space URL, and project key; invoice task checking can be disabled.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: posts results to a configured Slack channel ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: set, code, slack, sticky note, http request, manual trigger.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359723671731,"sku":"N8N-22219","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/APf2t-Yc78LkOGybYBAuk_8eGMHsnw.png?v=1793696896","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-customer-data-sync-check-hubspot-freee-backlog-slack","provider":"N8N Commerce","version":"1.0","type":"link"}