<aside> 📌

❓What this setup does:

This integration will automate the process of researching competitors’ websites, extracting relevant data, and analyzing it to create a professional company overview, service catalog, and company analysis.

</aside>

⚙️ Services Used:

• Google Sheets: Stores the data you need.
• FireCrawl: Crawls competitor websites and extracts relevant information.
• OpenAI: Analyzes the extracted data to generate a structured company overview and analysis.
• Make.com: Automates the workflow.

🧑‍💻 Step-by-Step Setup:

1. Google Sheets:
   • Create a Google Sheet with the following columns:
     • WebsiteCompany
     • OverviewCompany
     • ServicesCompany
     • Updates
     • Conclusion
2. FireCrawl Setup:
   • Use Make.com to send website URL to FireCrawl.
   • FireCrawl scrapes the website content.
3. OpenAI Integration:
   • Send the scraped content from FireCrawl to OpenAI through Make.com.
   • OpenAI generates summaries and overviews based on the scraped data.
4. Make.com Workflow:
   • Trigger: Starts when a new URL is added to the automation.
   • FireCrawl: Scrapes content from the URL.
   • OpenAI: Analyzes the scraped data and generates a summary.
   • Google Sheets: Saves the generated output back into the sheet.

<aside> 📌

How This Can Help:

• Efficiency: Automates competitive research, saving hours of manual work.
• Data-Driven Insights: Provides structured and useful insights for better business decisions.
• AI-Enhanced Analysis: Generates professional, high-quality reports and overviews from raw website data. </aside>

TEMPLATE ⬇️

competitor_research_template.json

Or you can download from Google Drive