OpenMart + Twenty CRM n8n Workflow: Local Prospect Finder

Find local businesses in OpenMart and auto-build review-ready prospects in Twenty CRM

The OpenMart + Twenty CRM n8n Workflow: Local Prospect Finder manually searches OpenMart for local businesses in your chosen niche and location, then imports only new companies into Twenty CRM—with a follow-up review task created for each newly added prospect.

What this workflow does

This workflow is designed for a targeted, deduplicated prospect import cycle:

• Manual run with search settings: You trigger the workflow and set the search query, city/state/country, result limit, and a review task due date via reviewTaskDueInDays.
• Validates inputs: If required fields or the limit are invalid, it stops and returns an error message.
• Searches OpenMart: It pulls local business results that include contact info and a valid website, then normalizes entries and keeps only those with a usable website domain.
• Deduplicates by domain: Prospects are de-duplicated using website domain. If nothing qualifies, it stops early with a “no usable businesses” report.
• Checks existing Twenty CRM companies: It loads all existing companies from Twenty CRM and compares domains to avoid duplicates.
• Creates new companies + tasks: For candidates not already in Twenty CRM, it creates the company and adds a review task using the search context and your due date.
• Final import summary: Reports how many prospects were created vs. already existed, with per-company outcomes.

Use cases

• Run weekly/local campaigns to build a fresh Twenty CRM prospect list for a specific city and niche.
• Importer-style workflows for SaaS operators who need clean CRM entries without duplicates.
• Automation engineers creating repeatable n8n lead sourcing and task creation flows.

Technical details

• OpenMart API credential configured in the OpenMart search node.
• Twenty CRM API credential configured to list companies, create companies, and create tasks.
• Uses n8n nodes including if, set, code, split out, aggregate, and `sticky note` for workflow logic and clarity.

To deploy, update the search parameters (query, city, state, country, limit, and reviewTaskDueInDays) in the workflow.