ManualTrigger Automate

For the ManualTrigger Automate workflow, streamline your company research process by automating data collection from Google Sheets and web sources. This workflow integrates AI capabilities to gather essential company information, including domain, LinkedIn URL, pricing plans, and API availability. It runs on a schedule every 2 hours or can be triggered manually, ensuring timely updates and efficient data management. Save time and enhance your research accuracy with automated insights tailored to your needs.

7/8/2025
22 nodes
Complex
schedulecomplexlangchainsplitinbatchesgooglesheetssticky noteschedule triggerautomationadvancedcron
Categories:
Schedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
LangChainSplitInBatchesGoogleSheetsSticky NoteSchedule Trigger

Target Audience

  • Business Analysts: Those who need to gather and analyze company data for market research.
    - Marketing Teams: Professionals looking to enrich their leads with detailed company information.
    - Sales Teams: Sales representatives who want to understand potential clients better.
    - Data Scientists: Individuals interested in automating data collection processes for further analysis.
    - Entrepreneurs: Startups seeking insights into competitors and market trends.

    • Problem Solved

    This workflow automates the process of gathering company information from various online sources, solving the problem of time-consuming manual research. It provides structured data on companies, such as their LinkedIn URL, domain, market type, lowest pricing plan, and API availability. By automating these tasks, users can focus on analysis rather than data collection.

    Workflow Steps

  • Trigger: The workflow can be triggered manually or automatically every 2 hours.
    - Data Retrieval: It starts by fetching rows from a Google Sheets document that need enrichment based on the enrichment_status.
    - Looping: The workflow processes each row one by one, allowing for detailed research on each company.
    - AI Research: Utilizes LangChain's AI capabilities to gather information about the company, including its domain, LinkedIn URL, and more.
    - Web Scraping: Employs tools like SerpAPI and ScrapingBee to obtain additional data from the web, ensuring comprehensive insights.
    - Data Structuring: The results are parsed into a structured format for easy interpretation and analysis.
    - Update Google Sheets: Finally, it updates the original Google Sheets document with the enriched data, marking the enrichment status as done.

    • Customization Guide

  • Input Customization: Users can modify the input parameters to specify different companies or change the data fields they want to enrich.
    - AI Prompts: Adjust the AI prompts in the AI company researcher node to tailor the type of information gathered based on specific business needs.
    - Data Output: Customize the output format in the Structured Output Parser to suit different reporting requirements.
    - Schedule Adjustments: Change the scheduling frequency in the Schedule Trigger to run the workflow at different intervals as needed.
    - Integration Modifications: Users can replace or add new integrations based on their preferred tools or platforms, ensuring flexibility in the workflow.