n8n OpenMart + Google Sheets Prospect Enrichment Workflow

Turn your Google Sheets prospects into enriched, prioritized outreach leads with OpenMart + n8n

This n8n workflow reads businesses from Google Sheets, runs paid OpenMart enrichment to find emails and decision-makers, then outputs a new, dated Google Sheets report with ranked outreach readiness and recommended next steps—so your sales team knows who to contact first.

What this workflow does

• Starts a bulk research batch (manual run) with configurable limits and defaults, plus a required confirmation flag for paid enrichment.
• Loads enabled rows from a specified Google Sheets tab, validates required fields, and deduplicates by domain.
• Honors per-row overrides (up to the configured maximum business cap) before enrichment begins.
• Checks your OpenMart credits and stops the run if no credits are available.
• Submits two OpenMart background jobs per business to identify shared company emails and decision-makers (including email/phone) using your configured titles and location.
• Waits and polls job status (up to two times), then retrieves results—handling timeouts or empty outcomes.
• Extracts contact details such as emails, phone numbers, LinkedIn URLs, and people names/titles.
• Ranks each prospect (A–D) and generates a recommended next step based on the enrichment output.
• Creates a new Google Sheets spreadsheet and appends prioritized results to a “Research” sheet.

Use cases

• Bulk-enriching SaaS or services leads already tracked in Google Sheets.
• Generating a fresh outreach list for a new campaign without manual research.
• Prioritizing prospects by data completeness so reps spend time where it matters.

Technical details

• Integrations: OpenMart (paid enrichment via API + credits) and Google Sheets (OAuth2 access to source sheet and permission to create new spreadsheets).
• n8n nodes / logic: if, set, code, wait, merge, split out.
• Output: a new dated Google Sheets report containing enriched contact fields and A–D priority rankings.