{"product_id":"n8n-workflow-check-searchbug-reassigned-numbers-to-google-sheets","title":"n8n Workflow: Check Searchbug Reassigned Numbers to Google Sheets","description":"\u003ch3\u003eAutomatically check whether submitted phone numbers are reassigned—and log the result to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes a phone number and a consent\/contact reference date from an n8n form, queries Searchbug’s \u003cstrong\u003eReassigned Numbers Database\u003c\/strong\u003e (api_rnd) for reassignment status, then appends both the raw outcome and a plain-English interpretation to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form submissions\u003c\/strong\u003e from an n8n form containing a phone number and a consent\/contact reference date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and normalizes inputs\u003c\/strong\u003e: strips the phone number down to digits only and formats the date as \u003cstrong\u003eYYYY-MM-DD\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Searchbug api_rnd\u003c\/strong\u003e using an HTTP POST request with the cleaned phone number and reference date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInterprets the API response\u003c\/strong\u003e: extracts the reassigned status (\u003cstrong\u003eYES\/NO\/NO_DATA\/ERROR\u003c\/strong\u003e) and adds a \u003cstrong\u003ehuman-readable meaning\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs everything to Google Sheets\u003c\/strong\u003e by appending a new row, including submitted\/cleaned values, API fields, raw response, and a created timestamp.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eQuality checks for SaaS or compliance workflows that need to validate whether a phone number has been reassigned.\u003c\/li\u003e\n  \u003cli\u003eOperational tracking: keep an audit trail of API results (status, raw API response, and timestamps) for each submission.\u003c\/li\u003e\n  \u003cli\u003eWorkflow automation for customer onboarding or consent capture, where you must record the reassigned-number outcome tied to a consent\/contact date.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tools\u003c\/strong\u003e: set, sticky note, form trigger, HTTP request, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchbug integration\u003c\/strong\u003e: HTTP POST to the \u003cstrong\u003eReassigned Numbers Database\u003c\/strong\u003e endpoint (api_rnd) using headers \u003cstrong\u003eCO_CODE\u003c\/strong\u003e and \u003cstrong\u003ePASS\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: append-row step to a target spreadsheet\/worksheet with headers such as Submitted Phone, Cleaned Phone, Consent Date, Reassigned Status, API Phone, API Date, Status Meaning, Raw API Response, and Created At\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Create a sheet tab (e.g., “Reassigned Numbers”) with the required headers, then configure your Searchbug credentials in the HTTP request step.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738497441971,"sku":"N8N-17551","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rkvS-xtwCqzHJaMRff6AX_WxGesm4D.png?v=1785229599","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-check-searchbug-reassigned-numbers-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}