Skip to content
FlowHubFluxonLab
A
AI Automationfree

Automated Company Research & Lead Enrichment with GPT-4o and Google Sheets

by Candra Rezaadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentCall n8n Workflow ToolCall n8n Workflow ToolGoogle SheetsGoogle SheetsOpenAI Chat ModelOpenAI Chat ModelSerpApi (Google Search)SerpApi (Google Search)Structured Output ParserStructured Output Parser
Share Post Share
MaWhen clicking "Test workflow"When clicking "…SeInputOpenAI Chat ModelOpenAI Chat Mod…TWGet website contentGet website con…TSSerpAPI - Search GoogleSerpAPI - Searc…OPStructured Output ParserStructured Outp…SILoop Over ItemsSeAI Researcher Output DataAI Researcher O…Google Sheets - Update Row with dataGoogle Sheets -…MeMerge dataGet rows to enrichGet rows to enr…ScSchedule TriggerAgAI company researcherAI company rese…TWSearch Google with ScrapingBeeSearch Google w…1234567891011121314
1/5
FLOWS
STEPS · 14
Run manually by an operator

Supercharge your sales and marketing with this AI-powered workflow! 🚀 Stop wasting hours on manual company research. This template deploys an autonomous AI agent that takes a list of company names from a Google Sheet, scours the web to find critical information, and automatically updates your sheet with the enriched data. What it does: Reads a list of companies to research from a Google Sheet. Uses an AI agent equipped with Google Search and web scraping tools. Extracts key data points like LinkedIn URLs, pricing details, integrations, market focus (B2B/B2C), and more. Structures the output into a clean JSON object. Updates the original Google Sheet with the new information. Key Features & Customization: This workflow is built to be easily customized. You can modify the AI's prompt in the "AI company researcher" node and adjust the "Structured Output Parser" to gather any public data point you need, such as recent news, key executives, or their technology stack.

Tags

n8nreference-onlyagentgoogle-sheetslm-chat-open-aioutput-parser-structuredtool-serp-apitool-workflow
Connects
AAI Agentcalln8nworkflowtoolCall n8n Workflow ToolsheetsGoogle SheetsopenaichatmodelOpenAI Chat ModelserpapigooglesearchSerpApi (Google Search)structuredoutputparserStructured Output Parser
CategoryAI Automation
Triggermanual
Complexitycomplex
Nodes14
AddedAug 1, 2025

Related workflows

See all AI Automation
AopenaichatmodelserpapigooglesearchS
free

Slack chatbot powered by AI

This workflow offers an effective way to handle a chatbot's functionality, making use of multiple tools for information retrieval, conversation context storage, and message sending. It's a setup tailored for a Slack environment, aiming to offer an interactive, AI-driven chatbot experience. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team
Bsheetsopenaichatmodel
free

Create and approve AI social posts with OpenAI, Telegram and Blotato

Quick overview This workflow runs daily to generate an AI-written social post and DALL·E image with OpenAI, sends it to Telegram for approval, and—if approved—publishes it to LinkedIn, X, Instagram, Facebook, and Threads via Blotato while logging outcomes to Google Sheets. How it works Runs every 24 hours on a schedule trigger. Uses OpenAI to generate a single content topic (title, angle, and hook) based on your niche, audience, and language settings. Uses OpenAI to write one social post with a separate hashtag line and an image prompt in your specified tone and style. Uses OpenAI Images (DALL·E) to generate a matching image and extracts a shareable image URL. Sends the post text, hashtags, and image link to Telegram and waits for you to approve or skip within the configured time window. If approved, publishes the post with the image to LinkedIn, X, Instagram, Facebook, and Threads using Blotato and appends a “Published” log row to Google Sheets. If skipped or not approved, appends a “Skipped” log row to Google Sheets. Setup Add OpenAI API credentials and ensure the selected chat model and image model in the configuration match models available to your account. Add Telegram credent

by Dr. Firas
AopenaichatmodelserpapigooglesearchS
free

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.

by n8n Team