{"product_id":"searchbug-contact-info-api-in-n8n-save-results-to-google-sheets","title":"Searchbug Contact Info API in n8n: Save Results to Google Sheets","description":"\u003ch3\u003eSearchbug Contact Info API in n8n: Auto-save contact matches to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eTurn an n8n form submission into verified contact lookup results. This workflow sends your search criteria to the \u003cstrong\u003eSearchbug Contact Info API\u003c\/strong\u003e, then automatically appends any matching people or business records into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—or returns a clear “no records found” message when nothing matches.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives search criteria\u003c\/strong\u003e from an \u003cstrong\u003en8n form trigger\u003c\/strong\u003e (e.g., name, company, address, phone, or email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMaps form fields to Searchbug API parameters\u003c\/strong\u003e and sends a \u003cstrong\u003ePOST\u003c\/strong\u003e request to the \u003cstrong\u003eSearchbug Contact Info API (api_contact)\u003c\/strong\u003e requesting \u003cstrong\u003eJSON output\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the API response\u003c\/strong\u003e by checking the response status and whether any records were returned.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens returned records\u003c\/strong\u003e into consistent columns (including fields like phone, address, and email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e by writing each matched record as a new row in the specified sheet\/tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles empty results\u003c\/strong\u003e by returning a “no records found” message when the API response is empty.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLead enrichment: collect basic contact details from a form, enrich them via Searchbug, and store matches in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSales ops workflows: batch-confirm phone\/email\/address matches and maintain an export-ready spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eData collection tools: capture user inputs in n8n and immediately archive validated contact records for review.\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 form trigger, HTTP request, if, set, split out, and split\/flatten handling (via node flow), plus sticky note for setup clarity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchbug API authentication:\u003c\/strong\u003e set \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 setup:\u003c\/strong\u003e connect an OAuth credential, provide the spreadsheet \u003cstrong\u003eDocument ID\u003c\/strong\u003e, and target the correct sheet\/tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired header columns:\u003c\/strong\u003e FNAME, MNAME, LNAME, BNAME, PHONE, STREET, CITY, COUNTY, STATE, ZIP, EMAIL, DOB, AGE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eThis n8n automation workflow is built specifically to save Searchbug contact matches into Google Sheets with reliable “no matches” handling.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201654451,"sku":"N8N-18173","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/I008PBs-yaDT-BCNcu5Z8_tRa3m3R2.png?v=1786612144","url":"https:\/\/buyflowscripts.com\/products\/searchbug-contact-info-api-in-n8n-save-results-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}