{"product_id":"openmart-twenty-crm-n8n-workflow-local-prospect-finder","title":"OpenMart + Twenty CRM n8n Workflow: Local Prospect Finder","description":"\u003ch3\u003eFind local businesses in OpenMart and auto-build review-ready prospects in Twenty CRM\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eOpenMart + Twenty CRM n8n Workflow: Local Prospect Finder\u003c\/strong\u003e manually searches OpenMart for local businesses in your chosen niche and location, then imports \u003cem\u003eonly new\u003c\/em\u003e companies into \u003cstrong\u003eTwenty CRM\u003c\/strong\u003e—with a follow-up review task created for each newly added prospect.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis workflow is designed for a targeted, deduplicated prospect import cycle:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual run with search settings:\u003c\/strong\u003e You trigger the workflow and set the search query, city\/state\/country, result limit, and a \u003cstrong\u003ereview task due date\u003c\/strong\u003e via \u003cem\u003ereviewTaskDueInDays\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates inputs:\u003c\/strong\u003e If required fields or the limit are invalid, it stops and returns an error message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches OpenMart:\u003c\/strong\u003e It pulls local business results that include contact info and a valid website, then normalizes entries and keeps only those with a \u003cstrong\u003eusable website domain\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates by domain:\u003c\/strong\u003e Prospects are de-duplicated using website domain. If nothing qualifies, it stops early with a \u003cstrong\u003e“no usable businesses”\u003c\/strong\u003e report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks existing Twenty CRM companies:\u003c\/strong\u003e It loads all existing companies from Twenty CRM and compares domains to avoid duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates new companies + tasks:\u003c\/strong\u003e For candidates not already in Twenty CRM, it creates the company and adds a review task using the search context and your due date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinal import summary:\u003c\/strong\u003e Reports how many prospects were created vs. already existed, with per-company outcomes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRun weekly\/local campaigns to build a fresh Twenty CRM prospect list for a specific city and niche.\u003c\/li\u003e\n  \u003cli\u003eImporter-style workflows for SaaS operators who need clean CRM entries without duplicates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers creating repeatable n8n lead sourcing and task creation flows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenMart\u003c\/strong\u003e API credential configured in the OpenMart search node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwenty CRM\u003c\/strong\u003e API credential configured to list companies, create companies, and create tasks.\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e, and `sticky note` for workflow logic and clarity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTo deploy, update the search parameters (query, city, state, country, limit, and \u003cem\u003ereviewTaskDueInDays\u003c\/em\u003e) in the workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45994997842099,"sku":"N8N-19430","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/92r4gHNFtru-fZJ9UikgU_s4eM98Ku.png?v=1789031148","url":"https:\/\/buyflowscripts.com\/products\/openmart-twenty-crm-n8n-workflow-local-prospect-finder","provider":"N8N Commerce","version":"1.0","type":"link"}