You keep opening ChatGPT, typing the same prompt, copying the answer, and pasting it into a spreadsheet or email. It works, but it feels like you’re doing the robot’s job. After reading this you’ll know exactly when the chatbot is fine, when a purpose‑built agent saves you hours, and you’ll have a working example you can copy today.
What most guides get wrong
Most tutorials treat the choice as a binary: either you use the chatbot or you code a complex agent from scratch. They ignore the middle ground where a lightweight automation glues the model to your data without writing a single line of Python. In reality the biggest win comes from connecting the model to a trigger—like a form submission or a new row in Google Sheets—so the AI runs automatically.
Another common mistake is to assume you need the latest, most expensive model for every task. For simple classification or summarization a cheaper, faster model often gives you the same quality at a fraction of the cost. I’ve seen teams burn through credits on GPT‑4 Turbo just to rewrite product descriptions when a fine‑tuned GPT‑3.5 would have done the job.
How do you know when a custom agent is worth the effort?
Ask yourself if the task repeats more than three times a week and if the output needs to land somewhere other than the chat window. If you’re manually copying the answer into a CRM, an email draft, or a task manager, the copy‑paste loop is the cost you’re paying. When the loop appears, building a tiny agent that pulls the input, runs the model, and pushes the result back pays for itself in a few days.
If the task is truly one‑off—like brainstorming a blog outline or checking a quick fact—stick with the chatbot. The overhead of setting up a webhook, an API key, and a workflow outweighs the benefit for a single use.
Concrete named example: lead enrichment agent
Here’s a real workflow I run for a freelance outreach business. When a new lead appears in a Google Sheet, the agent pulls the company name, queries the OpenAI API for a one‑sentence summary of the company’s recent news, and writes the result back to the sheet.
Prompt (sent to the model): “Give me a concise, one‑sentence summary of the latest news about {{company}}. If you can’t find recent news, say ‘No recent public news found.’”
I built this in n8n workflows because it lets me connect Google Sheets, an HTTP request to the OpenAI API, and a Google Sheets update node without writing code. The steps are:
- Google Sheets trigger – watches for new rows in the “Leads” tab.
- Set node – extracts the company name into a variable called {{$json[“company”]}}.
- HTTP Request node – calls https://api.openai.com/v1/chat/completions with the model gpt-3.5-turbo, the prompt above, and a max_tokens of 60.
- Function node – parses the API response and pulls out the message content.
- Google Sheets node – updates the same row, column “News Summary” with the extracted text.
The whole thing runs in under five seconds per lead. I pay $0.006 per 1K tokens for gpt-3.5-turbo, so a typical lead costs less than $0.001. The n8n instance runs on a $5/mo VPS, which is negligible compared to the time saved.
