How to Build a Company Research Agent (Open AI Agents SDK + Serper + Groq) — Fast and Free!

Build a Web-Searching AI Agent for FREE (Groq + Serper + Excel) — step-by-step

👉 Check out my channel for free GenAI applications:
‪@GenAI_Nerd_Channel‬

In this tutorial, I show you how to build a scalable “company research” agent that can collect public info
from the internet and generate structured company descriptions (JSON) — for one company or for hundreds
in a single run.

What you’ll learn in this video:
What “agents” really are (and why they scale better than single prompts)
How to combine 3 building blocks: (1) Groq LLM, (2) Serper web search tool, (3) clear agent instructions
How to build the web-search tool (Serper) so your agent can “Google” autonomously
How to run everything in VS Code / Jupyter, read API keys safely, and control token usage + rate limits
How to process an Excel list of companies with a loop (pandas + tqdm) and export results back to Excel



🔁 Related video (more agent + Excel workflows):
How to Use ChatGPT Agent (2025): Competitor & Market Research + Excel (Step-by-Step)
   • How to Use ChatGPT Agent (2025): Competito...  

✔ Link to notebook and excel file

Notebook: https://drive.google.com/file/d/1Z06w...
Excel: https://docs.google.com/spreadsheets/...

🔑 Need a Groq API key first?
Get Groq API
   • Get Groq API to use Llama and Mistral at z...  

#AIAgent #WebSearch #Groq #Serper #AgentsSDK #Python #VSCode #ExcelAutomation #genai

00:00 Introduction to Building an Information-Collecting Agent
00:45 Understanding Agents in Generative AI
02:10 Setting Up the Agent: Meet Robert
04:11 Getting Started with Microsoft Visual Studio Code
05:58 Installing Necessary Packages and API Keys
13:44 Defining the Agent and Its Tools
17:50 Executing the Agent for the First Company
19:43 Scaling Up: Running the Agent for Multiple Companies
25:58 Final Thoughts and Next Steps