Turn a list of website domains into clear company insights. The flow reads each domain, scans the homepage, and uses AI to summarize the value proposition, industry, and market. Results are written back to the same Google Sheets row so teams can act fast.

The run starts on click. It pulls rows from Google Sheets, processes domains in batches, and follows redirects to reach the live homepage. The HTML is extracted, cleaned, and shortened. OpenAI then produces a compact JSON summary. That JSON is parsed into fields and merged with the original item so the right row gets updated by Domain. A short wait between batches controls the pace and avoids hitting rate limits.

You need a Google Sheet with a Domain column and an OpenAI API key. Set your credentials in n8n Cloud, confirm the sheet name and document link, and choose a batch size and wait time that fit your list. Expect faster research, consistent summaries, and a clean sheet that supports prospecting, ICP research, and competitor reviews.

• Manual start so you control when the enrichment runs
• Reads domains from Google Sheets and matches updates by the Domain column
• Fetches each homepage with HTTP Request and follows redirects automatically
• Extracts HTML and cleans the text to remove extra spaces and line breaks
• Uses OpenAI to return a structured JSON with value proposition, industry, and market
• Parses the JSON into separate fields for reliable sheet updates
• Merges AI output with the original row to keep context
• Updates Google Sheets with targeted field mappings for each row
• Split In Batches controls throughput and helps stay within limits
• Wait node adds a short pause between batches to reduce rate limit errors

• Reduce manual website review from minutes per site to under 30 seconds
• Automate up to 80 percent of research tasks for prospect lists
• Improve data quality by standardizing value proposition and industry fields
• Handle up to 10 times more domains with batch processing and wait control
• Connect website content and Google Sheets in one repeatable workflow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In Google Sheets, prepare a sheet with a Domain column and any other columns you want to fill such as Value Proposition, Industry, and Market.
4. In the n8n credentials manager, create a Google Sheets OAuth2 credential. Name it clearly, grant access to the target sheet, and save.
5. Double click the Read Google Sheets node and select your Google Sheets credential. Choose the correct document link and sheet name.
6. Open the Split In Batches node and set a batch size that fits your list and rate limits. A small number helps when testing.
7. Open the HTTP Request node and confirm the URL uses the Domain field. Keep follow redirects enabled for more reliable page loads.
8. Check the Clean Content code node. It trims and shortens the page text so the AI gets a clear summary.
9. In the credentials manager, create an OpenAI API Key credential. Get the key from your OpenAI account API page and paste it into n8n.
10. Open the OpenAI node, select your credential, and keep temperature low for consistent JSON. Review the prompt and keep it in JSON format.
11. Open the Update Google Sheets node. Select the same document and sheet as the reader. Set Column to Match On to Domain and map fields to Value Proposition, Industry, and Market.
12. Click Execute Workflow to run a small test. If rows do not update, confirm the Domain values match exactly and that the sheet name and gid are correct.
13. If you see HTTP errors or blocks, try smaller batches or increase the Wait time. For AI parsing issues, make sure the prompt requests strict JSON and that max tokens are sufficient.