ManualTrigger Automate

Used in ManualTrigger Automate, this workflow automates company research by integrating AI tools to gather essential business information. It retrieves data such as domain, LinkedIn URL, pricing plans, and market classification, enriching Google Sheets with the findings every 2 hours. The process enhances efficiency, enabling users to make informed decisions quickly and effectively.

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

Target Audience

This workflow is designed for:
- Business Analysts: Those who want to gather comprehensive data about companies to make informed decisions.
- Marketing Professionals: Individuals looking to analyze competitor offerings and market positioning.
- Entrepreneurs and Startups: Founders who need to research potential partners or competitors efficiently.
- Data Scientists: Analysts who require structured data for further analysis and insights.
- Sales Teams: Members who need to enrich leads with valuable insights before outreach.

Problem Solved

This workflow addresses the challenge of efficiently gathering and organizing crucial information about companies from various sources. It automates the research process by:
- Reducing Manual Efforts: Eliminates the need for manual searches and data collection, saving time and resources.
- Providing Structured Data: Outputs data in a structured format, making it easy to analyze and utilize in decision-making processes.
- Ensuring Comprehensive Insights: Combines data from multiple sources, including Google searches and website content, to provide a holistic view of a company’s offerings.

Workflow Steps

  • Trigger: The workflow can be initiated manually or scheduled to run every 2 hours.
    2. Data Retrieval: It fetches rows from Google Sheets that need enrichment based on the enrichment_status column.
    3. Input Preparation: The input data is prepared for processing, including company names or domains.
    4. Loop Over Items: The workflow processes each company input one by one, allowing for detailed analysis.
    5. AI Research: Utilizes AI models to research each company, gathering information such as:
    - LinkedIn URL
    - Domain
    - Market type (B2B or B2C)
    - Cheapest plan offered
    - API availability
    - Enterprise plan details
    - Free trial information
    - Integrations with other tools
    6. Data Merging: Combines the output from the AI research with the original input data.
    7. Update Google Sheets: Finally, it updates the relevant rows in Google Sheets with the enriched data, marking the process as complete.

    • Customization Guide

    Users can customize this workflow by:
    - Modifying Input Sources: Change the Google Sheets document and sheet name to fit your specific data source.
    - Adjusting AI Prompts: Tailor the prompts in the AI company researcher node to focus on different aspects of research or to change the output format.
    - Changing Output Structure: Update the Structured Output Parser to include or exclude specific properties based on your needs.
    - Scheduling Options: Alter the scheduling settings to run more or less frequently, depending on how often you need to refresh your data.
    - Adding Additional Tools: Integrate other APIs or tools that can provide further insights or data points relevant to your research.