ManualTrigger Automate

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.

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.

1. 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.