{"product_id":"apify-verified-contact-finder-in-n8n-google-sheets-email-roles","title":"Apify Verified Contact Finder in n8n: Google Sheets Email Roles","description":"\u003ch3\u003eFind verified website contact details in your Google Sheets—powered by Apify inside n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads domains from your Google Sheets, uses \u003cstrong\u003eApify’s Verified Website Contact Finder\u003c\/strong\u003e to extract published contact information, and automatically writes back `role` email results—or flags cases that need human review—so your lead lists stay accurate.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts manually\u003c\/strong\u003e when you run the workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads domains from Google Sheets\u003c\/strong\u003e by selecting rows where the \u003cem\u003estatus column is empty\u003c\/em\u003e, then queues the next domains to process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBatches domains\u003c\/strong\u003e into a single list and sends them to the \u003cstrong\u003eApify Verified Website Contact Finder\u003c\/strong\u003e actor to retrieve published emails, phones, and social links.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies results per domain\u003c\/strong\u003e based on success, the presence of \u003cem\u003erole-based emails vs personal emails\u003c\/em\u003e, and specific error outcomes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets rows\u003c\/strong\u003e with:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eRole email outcomes\u003c\/strong\u003e: writes role emails, phones, socials, and sets a \u003ccode\u003erole_found\u003c\/code\u003e status when role-based addresses exist.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ePersonal-only outcomes\u003c\/strong\u003e: writes personal emails and sets \u003ccode\u003epersonal_only_review\u003c\/code\u003e when only personal addresses are found.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eNo-contact outcomes\u003c\/strong\u003e: sets \u003ccode\u003eno_contact_published\u003c\/code\u003e when the site publishes no contact details.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eRetry handling\u003c\/strong\u003e: clears the status to retry later when the site is unreachable or errors occur.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild and maintain a \u003cstrong\u003erole-based contact database\u003c\/strong\u003e (e.g., support, sales, partnerships) from domains in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eIdentify domains where only \u003cstrong\u003epersonal emails\u003c\/strong\u003e are available so a team can review manually.\u003c\/li\u003e\n  \u003cli\u003eAutomatically mark unreachable or contact-less sites for \u003cstrong\u003elater reprocessing\u003c\/strong\u003e, reducing wasted manual work.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: install \u003ccode\u003e@apify\/n8n-nodes-apify\u003c\/code\u003e and configure an \u003cstrong\u003eApify OAuth2\u003c\/strong\u003e credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: configure a \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e credential and set your spreadsheet ID and sheet\/tab name in each Google Sheets step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: code, merge, filter, switch, aggregate, and sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerfect for n8n automation engineers and SaaS operators who want verified website contact extraction and clean, status-driven Google Sheets updates.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962074947763,"sku":"N8N-19195","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XDZoGoZV3JolPeITPa_N2_HMPzAEwL.png?v=1788599904","url":"https:\/\/buyflowscripts.com\/products\/apify-verified-contact-finder-in-n8n-google-sheets-email-roles","provider":"N8N Commerce","version":"1.0","type":"link"}