Enrich company data from Google Sheet with OpenAI Agent and ScrapingBee

This workflow demonstrates how to enrich data from a list of companies in a spreadsheet. While this workflow is production-ready if all steps are followed, adding error handling would enhance its robustness.

Important notes

- Check legal regulations: This workflow involves scraping, so make sure to check the legal regulations around scraping in your country before getting started. Better safe than sorry! - Mind those tokens: OpenAI tokens can add up fast, so keep an eye on usage unless you want a surprising bill that could knock your socks off! 💸

Main Workflow

Node 1 - Webhook This node triggers the workflow via a webhook call. You can replace it with any other trigger of your choice, such as form submission, a new row added in Google Sheets, or a manual trigger.

Node 2 - Get Rows from Google Sheet This node retrieves the list of companies from your spreadsheet. here is the [Google Sheet Template you can use](https://docs.google.com/spreadsheets/d/1AIzJGxdMmwMDuHyRqGyX-E0QYbyxWKlSMn-awlHH19s/). The columns in this Google Sheet are:

- Company: The name of the company - Website: The website URL of the company These two fields are required at this step.

- Business Area: The business area deduced by OpenAI from the scraped data - Offer: The offer deduced by OpenAI from the scraped data - Value Proposition: The value proposition deduced by OpenAI from the scraped data - Business Model: The business model deduced by OpenAI from the scraped data - ICP: The Ideal Customer Profile deduced by OpenAI from the scraped data - Additional Information: Information related to the scraped data, including: - Information Sufficiency: - Description: Indicates if the information was sufficient to provide a full analysis. - Options: "Sufficient" or "Insufficient" - Insufficient Details: - Description: If labeled "Insufficient," specifies what information was missing or needed to complete the analysis. - Mismatched Content: - Description: Indicates whether the page content aligns with that of a typical company page. - Suggested Actions: - Description: Provides recommendations if the page content is insufficient or mismatched, such as verifying the URL or searching for alternative sources.