Enrich Website Leads in Google Sheets with Weio API (n8n)

Automatically enrich website leads in Google Sheets using the Weio API (n8n)

Stop manually hunting for emails and phone numbers. This n8n workflow reads company websites from your Google Sheets, enriches them via the Weio Site-Info API, 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.

What this workflow does

• Runs daily at 7:00 (or you can run it manually).
• Reads rows from a Google Sheets tab and keeps only entries with:
  • a non-empty website, and
  • either never-enriched rows or rows enriched earlier than your configured re-check window.
• De-duplicates domains and limits how many lookups occur per run.
• Processes sites one-by-one with a configurable pause between requests.
• Calls Weio Site-Info at https://weio.ai/api/site-info to retrieve site metadata and public contact details such as role-based emails, phone numbers, contact page URL, and social profiles.
• Stops immediately if the Weio response indicates an API key or credit problem, and sends a Gmail failure email.
• Updates your Google Sheets rows matched by the website cell:
  • Full contact columns when found, or
  • site facts/status only when no contacts are available or the site is unreachable/invalid.
• Builds an HTML run summary (including counts and, when available, credits remaining) and sends it via Gmail when summary emails are enabled.

Use cases

• Enriching SaaS sales lists stored in Google Sheets with emails, phone numbers, and social links.
• Re-checking previously processed domains on a schedule to keep lead data current.
• Operational monitoring: receiving Gmail alerts when Weio API access or credits run into trouble.

Technical details (n8n)

• if, set, code, wait, gmail, limit nodes
• HTTP request to the Weio Site-Info API using n8n Header Auth for the API key