Build a No-Code AI Agent in Make.com: Step-by-Step Guide to Automating Kevin Cookie Company Email Responses from Google Docs and Tally Forms
Key Takeaways
- Repetitive customer questions are a massive time-sink for small businesses, with up to 80% of emails asking the same few questions.
- You can build a no-code AI agent in about 30 minutes to automate email responses 24/7 using tools like Tally, Google Docs, Make.com, and OpenAI.
- The core of the system is a simple Google Doc acting as a "brain" and a carefully crafted AI prompt in Make.com that tells the AI how to find answers and respond.
What if I told you that 80% of your customer service emails are asking the same five questions? Over and over. "What are your hours?" "Do you ship to my location?" "Are the cookies gluten-free?"
It's a soul-crushing time sink for any small business owner, especially a solopreneur. I recently heard about a shop owner who spent three hours every morning just answering these repetitive emails before she could even start packing orders. Three hours is insane.
That's where the magic of no-code AI agents comes in. We're going to build a 24/7, tireless customer service assistant that answers questions instantly. We're building our own digital team member in about 30 minutes.
Today, we're focusing on the fictional "Kevin Cookie Company." By the end of this guide, you'll have a fully functional AI agent that reads questions from a form, finds answers in a Google Doc, and sends a perfectly crafted email response. All without writing a single line of code.
The Mission: Building an AI Agent for Kevin Cookie Company
First, let's get our terms straight. This isn't just another chatbot.
What is a No-Code AI Agent?
An AI Agent, especially in a platform like Make.com, is more than a simple bot that follows a script. It's a context-aware workflow that can access live data, make decisions, and take actions. It can read a document, understand a question, formulate a unique response, and then do something—like send an email or update a CRM.
The Goal: Automatically Answer Customer Questions
Our objective is simple and powerful: 1. A customer submits a question via a Tally form. 2. Our AI agent instantly wakes up. 3. It reads the company's FAQ from a Google Doc. 4. It uses an AI model (like ChatGPT) to find the correct answer and write a polite email. 5. It sends the email to the customer.
The entire process should take less than 10 seconds, and we, the busy cookie moguls, don't have to lift a finger.
The Tools We'll Use: Tally, Google Docs, Make.com, and OpenAI
This tech stack is simple, powerful, and mostly free to get started. * Google Docs: Our agent's "brain" or knowledge base. * Tally Forms: The "ears" to listen for customer inquiries. * Make.com: The "nervous system" that connects everything and orchestrates the workflow. * OpenAI (ChatGPT): The "intelligence" that processes the information.
Step 1: Create Your Knowledge Base in Google Docs
Before our agent can answer questions, it needs to know the answers. This is where we create its source of truth.
Why Google Docs is the Perfect 'Brain' for Your AI
This approach is so incredibly accessible. Anyone can edit a Google Doc; you don't need a complex database. For most small businesses, a well-structured document is more than enough to handle common inquiries.
You can get more sophisticated with vector databases and custom Q&A systems, but that's the code-heavy, professional league. For our purposes today, a simple Google Doc is the perfect, powerful starting point.
Structuring Your Document with Clear Q&A Pairs
This is the most critical part of this step. Structure it clearly so the AI can easily parse the information. I recommend a simple Question/Answer format.
Example: Kevin Cookie Company's FAQ (Hours, Ingredients, Locations)
Here’s what Kevin's Google Doc might look like:
Kevin Cookie Company - FAQ
Q: What are your store hours? A: We are open Monday to Friday from 9 AM to 6 PM, and Saturdays from 10 AM to 4 PM. We are closed on Sundays.
Q: Do you offer gluten-free cookies? A: Yes! Our "Cloud Nine Coconut Macaroon" is completely gluten-free. Please note that it is prepared in a kitchen that also handles flour, so we cannot guarantee against trace amounts of cross-contamination.
Q: Where do you ship? A: We currently ship anywhere within the United States. International shipping is not available at this time.
Q: What are the main ingredients in your chocolate chip cookie? A: Our classic chocolate chip cookie contains flour, butter, brown sugar, white sugar, eggs, vanilla extract, baking soda, salt, and semi-sweet chocolate chips.
Simple, right? That’s all you need.
Step 2: Set Up the Customer Inquiry Funnel with Tally Forms
Next, we need a way for customers to ask questions. A simple contact form is perfect.
Creating a Simple and Effective Contact Form
I'm a big fan of Tally.forms because its free tier is ridiculously generous. Create a new form and give it a title like "Ask Us Anything!"
Essential Fields: Name, Email, and 'Your Question'
Keep it minimal. We only need three things: 1. Name (Short text field) 2. Email (Email field - this is crucial for the reply!) 3. Your Question (Long text field)
That's it. Publish the form and grab the shareable link.
Step 3: Build the Automation Core in Make.com
This is where it all comes together. Log in to your Make.com account and let's build the scenario.
Scenario Overview: A Visual Map of Our AI Agent
Our Make.com scenario will have four main modules. It’s a visual representation of the workflow:
Tally -> Google Docs -> OpenAI -> Gmail
Module 1: The Trigger - 'Watch New Responses' in Tally
Click the big plus sign and search for Tally. Select the "Watch New Responses" trigger. Connect it to your Tally account and choose the form you just created.
Module 2: The Search - 'Get Content of a Document' from Google Docs
Add another module. Search for Google Docs and choose "Get the Content of a Document." Connect your Google account and find the FAQ document you created in Step 1.
Module 3: The Brain - 'Create a Completion' with OpenAI (ChatGPT)
This is the magic step. Add an OpenAI module and select "Create a Completion." Now, we need to craft the perfect prompt.
Crafting the Perfect AI Prompt to Find and Formulate Answers
This prompt is the "job description" we give to the AI. In the prompt field, you're going to combine static instructions with dynamic data from the previous modules.
You are a friendly and helpful customer service agent for Kevin Cookie Company.
Here is our internal FAQ document:
[Drag the 'Content' pill from the Google Docs module here]A customer named
[Drag the 'Name' pill from the Tally module here]has asked the following question:[Drag the 'Your Question' pill from the Tally module here]Your task is to: 1. Read the FAQ document carefully. 2. Find the answer to the customer's question within the FAQ. 3. Draft a polite and helpful email response that answers their question. Start the email with "Hi [Name],". 4. If the answer is not in the FAQ, write an email that says you've received their question and that a human team member will get back to them shortly.
Only output the final email response. Do not include any other text.
This prompt gives the AI its persona, the context (the FAQ), the user's query, and a fallback for unknown questions.
Module 4: The Action - 'Send an Email' via Gmail/SMTP
The final step. Add a Gmail module and choose "Send an Email."
* To: Drag the Email pill from the Tally module here.
* Subject: Re: Your question for Kevin Cookie Company
* Content: Drag the Choices[].Text pill from the OpenAI module here.
And you're done. Your four-step AI agent is built.
Step 4: Testing and Launching Your AI Agent
Don't just turn it on and hope for the best. We need to test it.
Running a Test with a Sample Question
In Make.com, click the "Run once" button. Then, go to your live Tally form and submit a question you know is in the FAQ, like "What are your hours?".
Debugging: What to Do if the Response is Wrong
If something goes wrong, don't panic. Click on the magnifying glass above each module to inspect the data. * Wrong Answer? Your prompt might be confusing, or your Google Doc isn't structured clearly enough. * No Email Sent? Check your Gmail module setup and ensure you mapped the recipient's email correctly. * Error on OpenAI? Your API key might be invalid, or you might be out of credits.
Activating Your Scenario for 24/7 Automation
Once you've tested it, just toggle the switch on the scenario from "Off" to "On." That’s it. Your agent is now live, standing by 24/7 to handle customer inquiries.
Conclusion: Your New AI-Powered Team Member
You just built an autonomous agent that frees up hours of your time, provides instant responses, and ensures accuracy by using a single source of truth. This is the kind of practical, high-impact automation that changes the game.
Recap of What You've Built
You've successfully connected a web form to an AI brain that uses your own documentation to automatically and intelligently reply to customer emails. This isn't science fiction; it's a real system you built in minutes.
Next Steps: How to Make Your Agent Even Smarter
This is just the beginning. From here, you could add routers in Make.com to forward complex questions to a human or log every inquiry in a Google Sheet. Once you've mastered this workflow, you can explore other no-code platforms to build even more specialized agents.
Go build something amazing. Your future, less-stressed self will thank you.
Recommended Watch
💬 Thoughts? Share in the comments below!
Comments
Post a Comment