Build an AI Agent with ChatGPT + n8n (No Code Required)
Ever tried ChatGPT, felt the magic… and then wondered what’s next? You’re not alone. Playing with AI is fun—but building something useful with it? That’s the real game changer.
Here’s the kicker: with a free tool called n8n, you can create your own AI agent in under an hour. No coding required. No long YouTube rabbit holes. Just you, a couple smart clicks, and a custom bot that logs your subscriptions into Google Sheets like a little digital assistant.
By the end of this guide, you’ll go from chatbot dabbler to AI builder—connecting a model, adding memory, strapping on tools, and writing a system prompt that makes your agent act like it actually gets you.
Ready when you are.
What Makes an AI Agent… an Agent?
Let’s flip the script: AI isn’t just about conversation. It’s about doing things for you.
To get from chat to action, your agent needs:
- A brain – That’s your model (like GPT-5) + memory to track context.
- Tools – Google Sheets, Slack, Notion, APIs—places it can take action.
- A brain stem – Aka the system prompt: the ruleset that tells the brain what to do, when.
Once you wire it all up, here’s what happens:
You say something → AI interprets → Uses a tool → Sends you the result.
Now let’s build your first one.
Create Your Automation Playground in n8n
First things first: sign up at n8n.io. You’ll get a 14-day free cloud trial (or go self-hosted if you’re fancy).
Once inside:
- Hit “New Workflow”
- Name it something like “Subscription Agent”
- You’ve got a blank canvas—time to paint.
Step 1: Give Your Agent a Brain
Start by letting the AI talk and remember. Here’s how:
- Add a Chat Trigger
- Click the ➕ icon, search “Chat,” and select Chat Trigger.
- This opens the chat input that will spark each workflow.
- Connect OpenAI Chat Model
- From the Chat Trigger’s connector, search “OpenAI Chat.”
- Create a credential using your OpenAI API key (get one here).
- Choose a budget-friendly model like gpt-4o-mini.
- Add Simple Memory
- Click the “Memory” connector in the AI Agent node.
- Choose Simple Memory and set the “Context window length” to 14.
- This gives your agent about a week’s memory span.
Click Save. Now say “Hello” in the chat panel. Your bot talks back.
Not bad for five minutes’ work.
Step 2: Give It Hands (Tools)
Let’s wire it to Google Sheets so it can track your expenses.
1. Prep Your Sheet
- Open a new Google Sheet (
sheets.new) - Name it “Subscription Tracker”
- Add columns:
Expense | Charge Date | Cadence | Cost | Status - Rename the default tab to “Tracker”
2. Hook Sheets into n8n
- In your workflow, go to the AI Agent node → click Tools → select “Google Sheets”
- Authenticate with Google via pop-up
- Tool setup:
- Resource: Sheet within document
- Operation: Append Row
- Paste your Sheet’s URL + select “Tracker” tab
- For each field:
- Click the ✨ icon → let the model craft dynamic values
- Rename this tool to “Add Entry”
Click Save again. Your AI now can write to the sheet—but it won’t know when to do it just yet.
Step 3: Teach It When + How to Act
You’ve got tools and talent—now cue the rules. Think of this step as writing your agent’s brainstem.
1. Grab Your Workflow Blueprint
- Screenshot your n8n canvas
- Click top-right “…” menu → Download as JSON
2. Get ChatGPT to Draft the System Prompt
Head to ChatGPT (use the latest reasoning model). Then:
- Upload both the screenshot and the JSON export.
- Ask: “Please generate a clear system message for an agent that logs subscriptions using Google Sheets. It should confirm each entry, write Charge Date in ISO format, and use the ‘Add Entry’ tool.
- Let AI help you teach AI. Poetic.
3. Plug the Prompt into n8n
- Back in AI Agent node → under Options, choose System Message → Expression
- Paste the system prompt you got from ChatGPT
- Adjust where needed (e.g., require explicit confirmation, auto-set today’s date)
Now you’ve got a model that knows the “how” and “when.”
Test Drive Time
Try this line in the chat:
“I just subscribed to iCloud for $10 a month.”
If your setup’s humming:
- Agent asks, “Want me to log that?”
- You say “Yes.”
- The row appears in Google Sheets. Boom.
Something weird?
Tweak your system prompt—tiny edits can fix big gaps. The good ones are specific and bossy. Don’t be polite.
Next-Level Upgrades
Once the basics run smooth, try these boosters:
- Duplicate checks
- Add a “Get All Row” tool to scan the Sheet first
- Update your system prompt: “If subscription exists, update instead of duplicate”
- Multi-tool workflows
- Plug in Slack for notifications
- Log entries in both Sheets and Notion
- Add eyes
- Let users drop a receipt image → Use OpenAI or Google Vision to parse text
You’re only limited by what you can describe.
Wrap-Up: Build Once, Automate Forever
When you wire a brain, some memory, and a few tools together—you don’t just have a script. You’ve got an AI agent that acts.
Sure, templatized AI tools can be quick wins. But building your own?
- Keeps your data private
- Gives full control
- Grows as your workflow evolves
Plus, you’ll actually learn how the tech works instead of just riding the wave.
Ready to make AI something you own, not rent?
👉 Learn all this (and more) with beginner-friendly challenges at Tixu.ai—a hands-on AI learning platform built for folks like you.
Leave a Reply