ManualTrigger Automate

Used in ManualTrigger Automate, this workflow streamlines email verification by integrating Google Sheets and Icypeas. It allows users to easily read email data from a Google Sheet and perform bulk verifications, enhancing efficiency and accuracy in managing email lists. The manual trigger ensures control over when the process runs, making it user-friendly and effective for batch processing tasks.

7/8/2025
8 nodes
Medium
manualmediumsticky notegooglesheetsapiintegration
Categories:
Manual TriggeredData Processing & AnalysisMedium Workflow
Integrations:
Sticky NoteGoogleSheets

Target Audience

This workflow is ideal for:
- Marketers looking to verify large lists of email addresses to ensure deliverability and maintain a clean mailing list.
- Business Owners who need to validate customer emails for effective communication and avoid spam traps.
- Data Analysts who require accurate email data for analysis and outreach campaigns.
- Developers integrating email verification into applications or services for improved user experience.

Problem Solved

This workflow addresses the challenge of verifying a bulk list of email addresses efficiently. It automates the process of checking the validity of emails using the Icypeas API, reducing manual effort and minimizing errors. This ensures that businesses can maintain a high-quality email list, which leads to better engagement rates and reduced bounce rates.

Workflow Steps

  • Manual Trigger: The workflow starts when the user clicks the "Execute Workflow" button.
    2. Read Google Sheets: It retrieves email addresses from a specified Google Sheet. The first column should contain the header 'email'.
    3. Authenticate with Icypeas: The workflow generates an authentication signature using the API key, secret, and user ID, which are required to access the Icypeas API.
    4. Prepare for Bulk Search: The workflow prepares the data for the bulk email verification request, including the task type and user information.
    5. Run Bulk Search: An HTTP POST request is sent to the Icypeas API to verify the emails. The request includes necessary headers and body parameters.
    6. Receive Results: After processing, results are available in the Icypeas application and sent via email to the user from [email protected].

    • Customization Guide

    To customize this workflow:
    - Google Sheets Configuration: Change the sheet name and document ID in the 'Reads lastname,firstname and company from your sheet' node to point to your specific Google Sheet.
    - Icypeas Credentials: Open the 'Authenticates to your Icypeas account' node and replace the placeholders with your actual API Key, API Secret, and User ID.
    - Email Column: Ensure the Google Sheet's first column contains the header 'email'. Modify the column if necessary to match your data structure.
    - API Request Adjustments: You can modify the body parameters in the 'Run bulk search (email-verif)' node to include additional data or change the task type as needed.