Data extraction and analysis from Google Sheets to OpenAI

• Automate data extraction from websites listed in Google Sheets.
• Generate insights about companies using AI analysis.
• Update Google Sheets with AI-generated data for easy access.

Initiate the workflow by reading data from Google Sheets. Split the data into batches for processing. Fetch HTML content from each domain using HTTP requests. Extract and clean the content for analysis. Analyze the cleaned content with OpenAI to derive insights. Parse the AI-generated JSON response and update Google Sheets.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets account to the workflow.
3. 3
   Set up the OpenAI credentials for analysis.
4. 4
   Configure the document ID and sheet name for reading and updating data.
5. 5
   Test the workflow by clicking 'Execute Workflow'.