{"product_id":"n8n-property-search-google-sheets-log-via-searchbug-api","title":"n8n Property Search → Google Sheets Log via Searchbug API","description":"\u003ch3\u003eSearch properties from n8n and log results to Google Sheets using the Searchbug API\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures property search criteria from an n8n Form, queries the \u003cstrong\u003eSearchbug Property Search API (api_prop)\u003c\/strong\u003e for matching records, and automatically \u003cstrong\u003eappends detailed property fields to a Google Sheets tab\u003c\/strong\u003e—so you can review and track search outcomes in one place.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects input\u003c\/strong\u003e: Receives a submission from an \u003cstrong\u003en8n Form\u003c\/strong\u003e where users choose a search type, enter a search value, and provide a location.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMaps search type to Searchbug SRCH code\u003c\/strong\u003e: Converts the selected search type into Searchbug’s SRCH codes:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eA\u003c\/strong\u003e for address\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eP\u003c\/strong\u003e for parcel ID\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eO\u003c\/strong\u003e for owner name\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Searchbug\u003c\/strong\u003e: Sends a \u003cstrong\u003ePOST\u003c\/strong\u003e request to the \u003cstrong\u003eSearchbug Property Search API endpoint\u003c\/strong\u003e and retrieves the property record as JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results to Google Sheets\u003c\/strong\u003e: Appends returned property details (including fields such as \u003cstrong\u003eowner, parcel, values, mailing address, and land data\u003c\/strong\u003e) as a new row in your specified spreadsheet\/tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal property research\u003c\/strong\u003e: Analysts submit address\/parcel\/owner queries via a form and receive logged results in Google Sheets immediately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperational tracking\u003c\/strong\u003e: Maintain a searchable history of property lookups with mailing and land-related fields for follow-up work.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS workflows\u003c\/strong\u003e: Use this n8n property search automation to connect customer search requests to structured reporting in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: set, sticky note, form trigger, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal API\u003c\/strong\u003e: Searchbug Property Search API (\u003cstrong\u003eapi_prop\u003c\/strong\u003e) using mapped SRCH codes (A\/P\/O)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eAdd your \u003cstrong\u003eSearchbug CO_CODE\u003c\/strong\u003e and \u003cstrong\u003ePASS\u003c\/strong\u003e values to the HTTP request body parameters.\u003c\/li\u003e\n      \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e credentials and set your \u003cstrong\u003eDocument ID\u003c\/strong\u003e and target \u003cstrong\u003eworksheet\/tab name\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eCreate a header row in the target tab matching the property fields written by the Google Sheets append step.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eGet a reliable \u003cstrong\u003en8n property search → Google Sheets log\u003c\/strong\u003e pipeline powered by the \u003cstrong\u003eSearchbug API\u003c\/strong\u003e, with results automatically appended as new rows.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899951014067,"sku":"N8N-18713","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wMM9RiiC4V2kE4YcDbYus_xBc0QRlW.png?v=1787735233","url":"https:\/\/buyflowscripts.com\/products\/n8n-property-search-google-sheets-log-via-searchbug-api","provider":"N8N Commerce","version":"1.0","type":"link"}