Automate Lead Extraction from Gmail to Google Sheets with Slack Alerts

This workflow is designed to streamline the process of identifying potential business leads from your Gmail inbox. It operates in two modes: a manual trigger for historical emails and a scheduled trigger for new emails. The workflow filters out emails from personal domains, system addresses, and generic inboxes, extracting key details like company name, email address, domain, and subject. These details are then stored in a Google Sheets document, with logic to prevent duplicate entries. Finally, a Slack notification is sent with the lead's information, allowing for quick follow-up.