ManualTrigger Automate

For ManualTrigger Automate, streamline your email searches by integrating Google Sheets and Icypeas. This workflow allows you to easily read contact data from your Google Sheet and perform bulk email searches, saving time and enhancing efficiency. Simply execute the workflow to authenticate your Icypeas account and retrieve results directly via email, ensuring a seamless and effective search process.

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

Target Audience

This workflow is designed for:
- Marketing Professionals: Who need to perform bulk email searches for lead generation.
- Sales Teams: Looking to enrich their contact lists with verified email addresses.
- Data Analysts: Who require efficient methods to gather and analyze email data from various sources.
- Small Business Owners: Seeking affordable solutions to connect with potential customers through email outreach.

Problem Solved

This workflow addresses the challenge of bulk email searching by automating the process of retrieving email addresses based on user-provided first names, last names, and company names. It eliminates the need for manual searches, saving time and increasing efficiency in lead generation efforts. By integrating with Icypeas, users can access a powerful API that provides accurate email addresses, thus enhancing their outreach strategies.

Workflow Steps

  • Manual Trigger: The workflow begins when the user clicks the "Execute Workflow" button.
    2. Google Sheets Integration: It reads data from a specified Google Sheet, which contains columns for lastname, firstname, and company.
    3. Authentication to Icypeas: The workflow authenticates the user's Icypeas account using an API key, secret, and user ID. This step ensures secure access to the Icypeas API.
    4. Bulk Email Search Execution: The workflow sends a POST request to the Icypeas API to perform a bulk email search using the data retrieved from the Google Sheet. It includes necessary parameters such as the task type and user information.
    5. Results Handling: After the request is processed, the results will be available in the Icypeas application and sent to the user via email, providing a comprehensive list of email addresses based on the input data.

    • Customization Guide

    To customize this workflow:
    - API Credentials: Replace the placeholders in the "Authenticates to your Icypeas account" node with your actual API Key, API Secret, and User ID.
    - Google Sheet Configuration: Ensure your Google Sheet is set up correctly with the required headers: lastname, firstname, and company. Update the sheetName and documentId parameters in the Reads lastname,firstname and company from your sheet node to point to your specific Google Sheet.
    - Email Search Parameters: Modify the parameters in the Run bulk search (email-search) node if you need to adjust the search criteria or the data being sent to Icypeas.
    - Testing: Conduct tests to ensure the workflow is functioning as expected by running the manual trigger and checking the results in your Icypeas account.