{"product_id":"check-german-handelsregister-suppliers-with-apify-google-sheets","title":"Check German Handelsregister Suppliers with Apify \u0026 Google Sheets","description":"\u003ch3\u003eCheck German Handelsregister suppliers automatically—using Apify and Google Sheets from your n8n form\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes a supplier name submitted via a form, searches Germany’s official \u003cstrong\u003eHandelsregister\u003c\/strong\u003e through \u003cstrong\u003eApify\u003c\/strong\u003e, selects the best match, logs the normalized result to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and shows the outcome back on the confirmation page.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives input from an n8n form\u003c\/strong\u003e (company name, optional register number, and an exact or keyword search choice).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries Apify’s “Germany Handelsregister Scraper”\u003c\/strong\u003e to retrieve up to five matching companies from the official Handelsregister.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles failures safely\u003c\/strong\u003e: if the register request fails, it prepares a “check failed” result so the run is not recorded simply as “no match.”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the best match\u003c\/strong\u003e: when results are returned, it prefers an exact company name match, then extracts key fields such as legal form, register court\/number, status, address, capital, EUID, and other matching data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a normalized row to Google Sheets\u003c\/strong\u003e so you can audit checks over time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDisplays a completion message\u003c\/strong\u003e on the form confirmation page showing either matched company details, “No match found,” or that the register did not answer.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVerify supplier identities during onboarding by checking whether a company exists in the German Handelsregister.\u003c\/li\u003e\n  \u003cli\u003eEnrich CRM or compliance datasets with legal form, register court\/number, status, and address.\u003c\/li\u003e\n  \u003cli\u003eBuild a self-serve “company check” flow for SaaS users that returns results instantly and stores them for reporting.\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: Code, Form, Sticky Note, Form Trigger, Google Sheets, and \u003ccode\u003e@apify\/n8n-nodes-apify\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: uses Apify’s Germany Handelsregister Scraper actor with your Apify API token credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: OAuth credentials, configured to append to your selected spreadsheet and sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet setup\u003c\/strong\u003e: create a header row matching the workflow output fields (e.g., checkedAt, query, matchFound, companyName, legalForm, registerCourt, registerNumber, status).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154102145203,"sku":"N8N-20043","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/riPAfchwqhFFoqYJPidBE_cjQ5Tc93.png?v=1790933724","url":"https:\/\/buyflowscripts.com\/products\/check-german-handelsregister-suppliers-with-apify-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}