{"product_id":"searchbug-nap-e-lookup-in-n8n-form-to-google-sheets","title":"Searchbug NAP+E Lookup in n8n: Form to Google Sheets","description":"\u003ch3\u003eInstantly run Searchbug NAP+E lookups from an n8n form and log matches to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you submit search details via an \u003cstrong\u003en8n form\u003c\/strong\u003e, query the \u003cstrong\u003eSearchbug NAP+E\u003c\/strong\u003e endpoint (\u003cstrong\u003eapi_nape\u003c\/strong\u003e), and automatically \u003cstrong\u003eappend any returned person\/business matches\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—or return a clear \u003cem\u003e“No records found”\u003c\/em\u003e message when nothing matches.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives a submission from an \u003cstrong\u003en8n form\u003c\/strong\u003e, where you select a search type and enter any known person or business details.\u003c\/li\u003e\n  \u003cli\u003eMaps form inputs into the \u003cstrong\u003eSearchbug NAP+E API parameters\u003c\/strong\u003e, including using the correct \u003cstrong\u003esubtype\u003c\/strong\u003e for phone-only or email-only lookups.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003ePOST\u003c\/strong\u003e request to the Searchbug API and checks the response status and whether any records were returned.\u003c\/li\u003e\n  \u003cli\u003eNormalizes the API response so each match becomes a separate item, while keeping shared metadata (source and found flags).\u003c\/li\u003e\n  \u003cli\u003eTransforms returned fields into a consistent schema (e.g., \u003cstrong\u003ename\u003c\/strong\u003e, \u003cstrong\u003ebusiness\u003c\/strong\u003e, \u003cstrong\u003eaddress\u003c\/strong\u003e, \u003cstrong\u003ephone\u003c\/strong\u003e, \u003cstrong\u003eemail\u003c\/strong\u003e, plus \u003cstrong\u003estatus\/error\u003c\/strong\u003e fields).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends each matched record\u003c\/strong\u003e to a new row in your configured \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet. If the API returns no results, it responds with a \u003cstrong\u003e“No records found”\u003c\/strong\u003e outcome.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVerify and enrich inbound leads by running Searchbug NAP+E queries directly from an n8n intake form.\u003c\/li\u003e\n  \u003cli\u003eSupport data-quality workflows: capture phone\/email from a form, look up matching records, and store results for review in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBuild a lightweight SaaS operator\/admin process to track search outcomes and errors across multiple submissions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ logic:\u003c\/strong\u003e if, set, code, sticky note, form trigger, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchbug credentials:\u003c\/strong\u003e provide \u003cstrong\u003eCO_CODE\u003c\/strong\u003e and \u003cstrong\u003ePASS\u003c\/strong\u003e in the HTTP request body.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e connect OAuth, set the target spreadsheet (Document ID) and worksheet name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet headers:\u003c\/strong\u003e STATUS, SRC, PHFND, ADFND, EMFND, FNAME, LNAME, BNAME, PHONE, ADDRESS, CITY, STATE, ZIP, EMAIL, ERROR.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003ePerfect for n8n users and automation engineers who need \u003cstrong\u003eSearchbug NAP+E lookup\u003c\/strong\u003e automation with reliable Google Sheets logging.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822096113843,"sku":"N8N-18068","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5OCFbcUjXTG62Qho72ceO_vkyM3cjt.png?v=1786526041","url":"https:\/\/buyflowscripts.com\/products\/searchbug-nap-e-lookup-in-n8n-form-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}