Data extraction and content analysis from websites to Google Sheets

• Extract and analyze company information from multiple websites.
• Automatically update Google Sheets with structured data from web content.
• Utilize AI to generate insights from extracted website data.

Initiate the workflow manually to start the process. Read a list of domains from Google Sheets. Send HTTP requests to each domain to fetch HTML content. Extract relevant data using HTML parsing techniques. Analyze the content with OpenAI to generate insights. Update Google Sheets with the processed data.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Connect your Google Sheets account to n8n.
3. 3
   Set up the OpenAI credentials for content analysis.
4. 4
   Customize the Google Sheets document ID and sheet name.
5. 5
   Run the workflow by clicking 'Execute Workflow'.