Quick overview This workflow runs on a schedule, pulls “Pending” company domains from Google Sheets, uses Tomba to find email addresses for each domain, filters for high-scoring personal contacts, logs the results to an enrichment sheet, and marks each processed domain as Done. How it works Runs on a schedule to check a Google Sheets “Company domains” tab for rows where the status is set to “Pending”. Processes the pending rows one domain at a time to avoid handling the whole list in a single run. For each domain, queries the Tomba API to retrieve up to 50 email addresses associated with the company domain. Filters the returned results to keep only personal emails with a quality score of 90 or higher and extracts key contact fields (name, email, position, company, domain). Appends the filtered contacts to a Google Sheets “Enrichment” tab. Updates the original domain row in Google Sheets to set the status to “Done” and continues with the next pending domain. Setup Connect Google Sheets credentials and update the spreadsheet and sheet references for both the source “Company domains” tab and the destination “Enrichment” tab.
Tags
Google SheetsRelated workflows
See all Google Sheets→WTrack YouTube Trends by Country and Language with RapidAPI & Google Sheets
📈 YouTube Trend Finder Workflow using n8n & RapidAPI Description: Easily discover trending YouTube videos by country and language using this automated n8n workflow. The flow leverages the YouTube Trend Finder API and logs insights to Google Sheets — ideal for content creators, marketers, and researchers. 🔗 Node-by-Node Explanation | Node Name | Type | Description | |-----------------------------|--------------------|-----------------------------------------------------------------------------| | 1. On form submission | Form Trigger | Captures user input for country and language through a web form. | | 2. Trend Finder API Request | HTTP Request | Sends a request to YouTube Trend Finder API with the form data. | | 3. Re format output | Code | Extracts and reshapes API response data like title, link, and tags. | | 4. Google Sheets | Google Sheets | Appends the trending video data into a structured spreadsheet. | 🎯 Use Cases 🔍 Content Research: Find top-trending videos in any region or language for idea inspiration. 📈 Marketing Intelligence: Track video trends to tailor your video marketing strategy. 📰 Trend Monitoring: Journalists and analysts can quickly surface viral video top
WTrack Website Traffic with Semrush API and Log Results to Google Sheets
Automated Seo Website Traffic Checker with Google Sheets Logging (Seo) Description: This workflow uses the Website Traffic Checker Semrush API to analyze website traffic and performance. It collects data through a user-submitted website URL and stores the results in Google Sheets for easy access and reporting. Ideal for SEO analysis and data tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. Triggers the workflow when a website URL is submitted via the form interface. 2. Check webTraffic Sends a request to the Website Traffic Checker Semrush API to gather traffic data for the submitted website. Uses the provided URL to fetch real-time traffic statistics using the Semrush API. 3. Re format output Extracts and reformats the raw traffic data from the API response. Cleans and structures the traffic data for easy readability and reporting. 4. Google Sheets Appends the formatted traffic data into a Google Sheet for storage and further analysis. Stores the data in a Google Sheets document for long-term tracking and analysis. Benefits of This Flow: Real-Time Data Collection:** Collects real-time website traffic data dire
WAutomate SEO Keyword Analysis with RapidAPI and Log to Google Sheets
Automated Keyword Analysis and Google Sheets Logging Automate keyword research with n8n and log essential SEO data like search volume, trends, competition, and keyword difficulty directly into Google Sheets. Simplify your SEO efforts with real-time insights. Node-by-Node Explanation 1. On form submission (Trigger) Purpose:** Triggers the workflow when a user submits the form with "country" and "keyword" as inputs. Explanation:** This node initiates the process by accepting user input from the form and passing it to the next node for analysis. 2. Keyword Analysis (HTTP Request) Purpose:** Sends a request to an external SEO API to analyze the provided keyword, fetching data like search volume, trends, and competition. Explanation:* This node calls the *Keyword Research Tool API** with the country and keyword inputs from the form, retrieving essential keyword data for further processing. 3. Re-format output (Code) Purpose:** Processes and reformats the API response into a structured format suitable for logging into Google Sheets. Explanation:** Extracts and organizes the keyword data (e.g., competition, CPC, search volume) into a format that can be easily mapped to Google Sheets colum