{"product_id":"n8n-imprify-api-imprint-leads-in-google-sheets-manual","title":"n8n: Imprify API Imprint Leads in Google Sheets (Manual)","description":"\u003ch3\u003eImprify API imprint lead enrichment directly in your Google Sheets (Manual n8n workflow)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you take website URLs from Google Sheets, look up the corresponding company imprint\/contact details using the \u003cstrong\u003eImprify EU Impressum Lead Data API\u003c\/strong\u003e on RapidAPI, and write the enriched fields back into the same spreadsheet—manually triggered, row by row.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e You start the automation by manually executing the workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRead URLs from Google Sheets:\u003c\/strong\u003e The workflow pulls rows from your selected worksheet and uses the \u003cstrong\u003e“Website URL”\u003c\/strong\u003e column as the input.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCall the Imprify API (RapidAPI):\u003c\/strong\u003e For each URL, it sends an HTTP request to the \u003cstrong\u003eImprify EU Impressum Lead Data API\u003c\/strong\u003e to extract imprint and contact information.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate the matching row:\u003c\/strong\u003e It matches the returned results to the correct record by \u003cstrong\u003e“Website URL”\u003c\/strong\u003e and updates the row with extracted fields such as \u003cem\u003ecompany name, address, email, phone, and register IDs\u003c\/em\u003e (and any destination columns you’ve set up, e.g., USt-ID or HRB).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnrich a lead list in Google Sheets by pulling legal imprint data from company websites.\u003c\/li\u003e\n  \u003cli\u003ePopulate missing compliance fields (e.g., imprint email, phone, and register identifiers) for SaaS sales ops or procurement teams.\u003c\/li\u003e\n  \u003cli\u003eData cleanup and validation cycles: run the workflow on demand whenever new URLs are added to your sheet.\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 \/ integrations:\u003c\/strong\u003e Manual Trigger, Google Sheets, HTTP Request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI:\u003c\/strong\u003e Imprify EU Impressum Lead Data API on RapidAPI (host header: \u003ccode\u003eimprify-eu-impressum-lead-data-api.p.rapidapi.com\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Connect Google Sheets OAuth2, select the spreadsheet\/worksheet, ensure a \u003cstrong\u003e“Website URL”\u003c\/strong\u003e column exists, and replace \u003ccode\u003eYOUR_RAPIDAPI_KEY\u003c\/code\u003e in the HTTP request headers.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850571407539,"sku":"N8N-18299","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/L5s8NzzKkIN1OpmJnPey__cfMnYHJ4.png?v=1786871066","url":"https:\/\/buyflowscripts.com\/products\/n8n-imprify-api-imprint-leads-in-google-sheets-manual","provider":"N8N Commerce","version":"1.0","type":"link"}