{"product_id":"enrich-website-leads-in-google-sheets-with-weio-api-n8n","title":"Enrich Website Leads in Google Sheets with Weio API (n8n)","description":"\u003ch3\u003eAutomatically enrich website leads in Google Sheets using the Weio API (n8n)\u003c\/h3\u003e\n\u003cp\u003eStop manually hunting for emails and phone numbers. This n8n workflow reads company websites from your Google Sheets, enriches them via the \u003cstrong\u003eWeio Site-Info API\u003c\/strong\u003e, writes results back to the same sheet, and emails you a daily run summary—plus failure alerts when Weio credits or API key access have issues.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 7:00\u003c\/strong\u003e (or you can run it manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads rows from a Google Sheets tab\u003c\/strong\u003e and keeps only entries with:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003enon-empty website\u003c\/strong\u003e, and\u003c\/li\u003e\n      \u003cli\u003eeither \u003cstrong\u003enever-enriched\u003c\/strong\u003e rows or rows enriched earlier than your configured \u003cstrong\u003ere-check window\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicates domains\u003c\/strong\u003e and limits how many lookups occur per run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses sites one-by-one\u003c\/strong\u003e with a configurable pause between requests.\u003c\/li\u003e\n  \u003cli\u003eCalls \u003cstrong\u003eWeio Site-Info\u003c\/strong\u003e at \u003ccode\u003ehttps:\/\/weio.ai\/api\/site-info\u003c\/code\u003e to retrieve site metadata and public contact details such as \u003cstrong\u003erole-based emails\u003c\/strong\u003e, \u003cstrong\u003ephone numbers\u003c\/strong\u003e, \u003cstrong\u003econtact page URL\u003c\/strong\u003e, and \u003cstrong\u003esocial profiles\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops immediately\u003c\/strong\u003e if the Weio response indicates an \u003cstrong\u003eAPI key or credit problem\u003c\/strong\u003e, and sends a \u003cstrong\u003eGmail failure email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates your Google Sheets rows\u003c\/strong\u003e matched by the \u003cstrong\u003ewebsite\u003c\/strong\u003e cell:\n    \u003cul\u003e\n      \u003cli\u003eFull contact columns when found, or\u003c\/li\u003e\n      \u003cli\u003esite facts\/status only when no contacts are available or the site is unreachable\/invalid.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eBuilds an \u003cstrong\u003eHTML run summary\u003c\/strong\u003e (including counts and, when available, \u003cstrong\u003ecredits remaining\u003c\/strong\u003e) and sends it via \u003cstrong\u003eGmail\u003c\/strong\u003e when summary emails are enabled.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnriching SaaS sales lists stored in Google Sheets with emails, phone numbers, and social links.\u003c\/li\u003e\n  \u003cli\u003eRe-checking previously processed domains on a schedule to keep lead data current.\u003c\/li\u003e\n  \u003cli\u003eOperational monitoring: receiving Gmail alerts when Weio API access or credits run into trouble.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif, set, code, wait, gmail, limit\u003c\/strong\u003e nodes\u003c\/li\u003e\n  \u003cli\u003eHTTP request to the \u003cstrong\u003eWeio Site-Info API\u003c\/strong\u003e using n8n \u003cstrong\u003eHeader Auth\u003c\/strong\u003e for the API key\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46157915914419,"sku":"N8N-20374","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vmhxLW846qoj6booEFbW4_QOR3ImsY.png?v=1791018142","url":"https:\/\/buyflowscripts.com\/products\/enrich-website-leads-in-google-sheets-with-weio-api-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}