This n8n workflow automates the process of researching company data by extracting information from websites and online sources, then enriching a Google Sheet with the gathered details. Designed for efficiency, it helps marketers, sales teams, or data analysts gather essential business intelligence with minimal manual effort.

The workflow starts with a manual trigger or scheduled run, selecting companies from a Google Sheet that haven’t been enriched yet. For each company, it uses an AI-powered research node that queries detailed information such as company website, LinkedIn URL, market focus, pricing plans, API availability, enterprise options, free trials, and software integrations.

To gather this data, the workflow employs web scraping and Google search nodes—using services like SerpAPI or ScrapingBee—to fetch and analyze relevant web content. The AI node then interprets and structures this data according to a predefined schema. Results are written back into the Google Sheet, creating a continuously updated database for business insights.

This automated process is ideal for competitive analysis, market research, lead qualification, or updating business intelligence dashboards, saving time and increasing data accuracy.

The setup includes sticky notes that guide users through the customization of prompts, API credentials, and search parameters, making it adaptable to various research needs.

Overall, this workflow exemplifies how n8n can streamline complex research tasks, combining web scraping, AI data extraction, and spreadsheet management into an efficient automation pipeline.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.outputParserStructured, @n8n/n8n-nodes-langchain.toolSerpApi, @n8n/n8n-nodes-langchain.toolWorkflow, googleSheets, manualTrigger, merge, scheduleTrigger, set, splitInBatches, stickyNote