How to Use ChatGPT Agent (2025): Competitor & Market Research + Excel (Step-by-Step)

Описание: Use ChatGPT Agent for deep competitor & market research and get customized spreadsheet as output

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

In this tutorial, I show how to enable ChatGPT Agent Mode in a Plus account, what the 40 agent requests/month limit means in practice, and how to link external resources (e.g., calendar) before running two startup-ready workflows:

Deep competitor analysis with customer likes/dislikes and a clean spreadsheet export, and

Market opportunity (TAM/SAM/SOM) with an Excel model you can tweak via formulas.

What you’ll learn: ChatGPT Agents/Agent Mode (2025), step-by-step setup, autonomous research, competitive analysis, market research, TAM/SAM/SOM, Excel/Spreadsheets, automation, and how Agents compare to Deep Research for data-backed deliverables.

1. Competitor research prompt:

I am a startup founder who wants to identify my main competitors and analyze the customers of my competitors
Instructions Based on the description of my startup, please engage in a deep competitor analysis to identify companies with a similar value proposition. Create an excel sheet that provides name of the competitor, webpage, location, description of the offering, and essential core differences between my value proposition and the value proposition of the competitor For the identified competitors, search for customer reviews on different platforms to better understand what customers like about the existing offerings and what customers do not like of the existing customers. Based on this analysis create a spreadsheet that lists all the strengths and weaknesses of the existing offerings. For every strength and weakness provide explicit quotes from customers that you were able to identify and provide suggestions on the implications for my startup
Startup description [add description startup]

2. Market research prompt:

I am a startup founder how wants to get a good understanding of the TAM, SAM and SOM for my startup. Below, you get a detailed understanding of my startup. Can you help me doing market opportunity research on my startup by executing the following steps:

Step 1. I want to target conferences, events and business meetings with at least 500 participants that are organized in Germany in 2026. Go to the internet and conduct research to provide a great estimation of the number of conferences, events and business meetings

Step 2. Based on the initial research try to create an analytic approach for TAM, SAM and SOM and highlight your underlying assumptions and calculations. You can engage in coding for the data analytics

Step 3. Generate an spreadsheet that shows TAM, SAM and SOM. It should also contain formulas that allow playing with underlying assumptions to do scenario analyses

Chapters

0:00 Intro & what we’ll cover (ChatGPT Agents + 2 use cases)
1:01 Enable Agent Mode (Plus limit, connect resources)
1:54 Use Case 1 — Competitor analysis: prompt & setup
3:51 Use Case 1 — Results: spreadsheet & customer quotes
4:53 Use Case 2 — Market opportunity (TAM/SAM/SOM) setup
5:48 Use Case 2 — Excel model & tweakable assumptions
6:38 Key learnings: give clear instructions; when Agents shine vs Deep Research
7:40 Outro & next steps