{"product_id":"n8n-openmart-google-sheets-prospect-enrichment-workflow","title":"n8n OpenMart + Google Sheets Prospect Enrichment Workflow","description":"\u003ch3\u003eTurn your Google Sheets prospects into enriched, prioritized outreach leads with OpenMart + n8n\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eStarts a bulk research batch (manual run)\u003c\/b\u003e with configurable limits and defaults, plus a required confirmation flag for paid enrichment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads enabled rows\u003c\/b\u003e from a specified Google Sheets tab, validates required fields, and \u003cb\u003ededuplicates by domain\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHonors per-row overrides\u003c\/b\u003e (up to the configured maximum business cap) before enrichment begins.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eChecks your OpenMart credits\u003c\/b\u003e and stops the run if no credits are available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSubmits two OpenMart background jobs per business\u003c\/b\u003e to identify shared company emails and decision-makers (including email\/phone) using your configured titles and location.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWaits and polls job status\u003c\/b\u003e (up to two times), then retrieves results—handling timeouts or empty outcomes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts contact details\u003c\/b\u003e such as emails, phone numbers, LinkedIn URLs, and people names\/titles.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRanks each prospect (A–D)\u003c\/b\u003e and generates a \u003cb\u003erecommended next step\u003c\/b\u003e based on the enrichment output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreates a new Google Sheets spreadsheet\u003c\/b\u003e and appends prioritized results to a “Research” sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBulk-enriching SaaS or services leads already tracked in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eGenerating a fresh outreach list for a new campaign without manual research.\u003c\/li\u003e\n  \u003cli\u003ePrioritizing prospects by data completeness so reps spend time where it matters.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e OpenMart (paid enrichment via API + credits) and \u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth2 access to source sheet and permission to create new spreadsheets).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes \/ logic:\u003c\/b\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003esplit out\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOutput:\u003c\/b\u003e a new dated Google Sheets report containing enriched contact fields and A–D priority rankings.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45994990567603,"sku":"N8N-19431","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7shvP9yGLe58jXvb2pE5j_7eDoWBXm.png?v=1789031122","url":"https:\/\/buyflowscripts.com\/products\/n8n-openmart-google-sheets-prospect-enrichment-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}