Your First No-Code AI Automation in 30 Minutes (Make or Zapier)

Updated: November 2026 · Prices checked: November 2026

Most people never build their first automation because they start too big. This guide gives you one small, useful workflow you can finish in about 30 minutes. A lead fills in your form, AI writes a short summary, the lead goes into a sheet and you get an email you can act on in ten seconds. I show it in Make and in Zapier, so you can follow whichever tool you already have.

What you will build

Four steps. Nothing more.

1. Trigger: a new answer arrives in your Google Form. Google saves it as a new row in the form’s response sheet.
2. AI step: a model reads the lead and writes two lines: who it is and what they want, then how urgent it is and the next step.
3. Sheet step: the lead and the summary go into a clean “Leads” tab you use as a mini CRM.
4. Email step: you get an email with the summary in the subject line and the full details below.

Why this one? It saves time on every single lead. It is easy to test. And it teaches the three things every automation has: a trigger, a transformation and an action. Once you have built this, you can build almost anything else in these tools.

Not sure which tool to pick? Our comparison of Make vs Zapier on the same automation shows the price gap. For this guide, either works.

Five minutes of preparation

1. Create the form. In Google Forms add: Name, Email, Company, Budget (short answer) and Message (paragraph). Keep it short. Every extra field lowers how many people finish it.
2. Link a sheet. In the form’s Responses tab, click “Link to Sheets” and create a new spreadsheet. Every answer now lands there as a row.
3. Add a “Leads” tab. In the same spreadsheet, add a second tab called Leads with these headers in row 1: Date, Name, Email, Company, Budget, Message, Summary, Status.
4. Send yourself two test answers. One serious lead with a budget. One vague one-liner. You will need both for testing.
5. Open an account. Make (free) or Zapier. Use the same Google account you used for the form.

Already use a website chat or form tool? It works the same way as long as it can send data to Make or Zapier. If you get many leads from chat, see what a free AI chatbot like Tidio really gives you.

Build it in Make

In Make, a workflow is called a scenario. Each step is a module.

1. Create a new scenario. Click the big plus and search for Google Sheets. Choose Watch New Rows. Connect your Google account, pick the response spreadsheet and the first tab. When Make asks where to start, choose to start from now on, so old rows are ignored.
2. Add the AI step. Click the small plus to the right and search for Make AI Toolkit. Choose Ask anything or Summarize text. Select Make’s AI Provider and the Small model. This works on every plan and you do not need an OpenAI account. Paste the prompt from the next section and map the form fields into it.
3. Add the sheet step. Add Google Sheets, Add a Row. Pick the same spreadsheet and the Leads tab. Map Date, Name, Email, Company, Budget and Message from the trigger, and Summary from the AI step. Type “New” into Status.
4. Add the email step. Add Gmail, Send an Email. To: your own address. Subject: “New lead: ” plus the first line of the summary. Body: the full summary, then all form fields.
5. Run once. Click Run once, then submit a fresh test answer to the form. Watch each module turn green. Click the bubble above each module to see what went in and out.
6. Set the schedule. Click the clock on the trigger. On the free plan, choose every 60 minutes. The reason is in section 6.

One detail worth knowing: if you would rather use your own OpenAI or Claude key, Make allows that only on paid plans. Then you pay the provider for tokens and Make for the operation.

Build it in Zapier

In Zapier, a workflow is a Zap. The free plan allows only two steps, so you need Professional for the full version. If you just want to try the idea for free, build the first two steps only (form row to email) and add the AI later.

1. Create a Zap. Trigger: Google Sheets, New Spreadsheet Row. Pick the response spreadsheet and its first worksheet. Click Test trigger and choose one of your test rows.
2. Add AI by Zapier. Choose a standard model. Paste the prompt from the next section and insert the form fields. On Zapier’s task rates page, a standard-model AI step costs 1 task. Advanced models cost 3 and premium 5.
3. Add Google Sheets, Create Spreadsheet Row. Choose the Leads worksheet. Map the fields and the AI output. Type “New” in Status.
4. Add Gmail, Send Email. To: you. Subject: “New lead: ” plus the summary’s first line. Body: summary plus all fields.
5. Test each step, then publish the Zap.

Zapier checks the sheet for new rows every 2 minutes on Professional. On the free plan it is every 15 minutes. Checking does not use tasks on Zapier. Only successful actions do.

The prompt that makes the summary useful

A vague prompt gives you a vague summary. Tell the model exactly what to write, how long, and what to do when data is missing. Copy this and adjust the words in capitals:

Three rules make this work:

• Fixed format. Two lines, word limits. You can scan it on your phone.
• No invention. “Use only the facts below” stops the model from guessing a budget.
• Your own urgency rule. If you want, add one line: “High means budget over €5,000 or a deadline within 30 days.” Now the label means something.

Run your two test leads through it. The serious one should come out High or Medium. The vague one should say “not given”. If not, tighten the prompt before you switch anything on.

Test it, switch it on, know the cost

Here is the trap most beginners hit in Make. A scheduled trigger like Watch New Rows uses one operation every time it checks, even when there is nothing new. Make’s own help pages say so. Check every 15 minutes and that is 96 checks a day, about 2,880 credits a month, before a single lead arrives. The free plan has 1,000.

The maths: On Make Free, check every 60 minutes: about 720 credits a month for checks. Each lead then uses about 3 more credits: the AI step, the new row and the email, plus a tiny token charge for the AI. With the Small model, Make counts 18,080 input tokens and 2,260 output tokens per credit, so a short lead summary adds well under one credit. That leaves room for roughly 80 to 90 leads a month at €0. On Make Core (about €7.74 a month billed yearly, 10,000 credits) you can check every 15 minutes and still handle 100 leads with about 3,200 credits used. On Zapier, checks are free and each lead uses 3 tasks, so 100 leads use 300 of the 750 tasks on Professional, about €17.19 a month billed yearly.

Before you switch on for real, do this short checklist:

• Submit one more test lead from your phone. Time how long it takes to reach your inbox.
• Open the Leads tab. Check every column is in the right place.
• Turn on error emails. Both tools can notify you when a run fails.
• Write down, in one line, what this automation does and where it lives. Future you will thank you.

Mistakes that break first automations

• Renaming columns. If you change a header in the sheet, the mapping can break. Lock the header row and leave it alone.
• Testing on real data. Use a copy of the sheet while you build. A wrong mapping can overwrite rows. We have seen what happens when AI tools touch real files without a backup in the story of the professor who lost a year of notes.
• Checking too often. On Make, a 1-minute schedule on a quiet form burns credits for nothing. Match the schedule to how fast you really reply.
• Trusting the AI label blindly. Read the full message for the first two weeks. Adjust the prompt when the urgency is wrong.
• Personal data everywhere. Leads are personal data. Keep the sheet private, share it only with people who need it, and delete old leads you no longer need.
• No cap on AI spend. If you later switch to your own API key, set a monthly limit in your provider account. Our playbook for cutting your AI bill covers how.

Once this runs for a week, add one improvement at a time. Good next steps: a filter that only emails you High leads, an automatic thank-you email to the lead, or a weekly digest of all leads. Want to skip the builder for small ideas? IFTTT.ai builds an automation from one sentence.

Read also: Make vs Zapier vs n8n: Which Automation Tool to Choose (2026) · Make vs Zapier: The Same Automation for €0 Instead of €214 a Year · IFTTT.ai Builds Your Automation From One Sentence – Free to Start

Sources: Make pricing · Make Help: Operations · Make Help: Credits · Zapier pricing · Zapier task usage rates · Zapier Google Sheets integration

II

About the author

Ivan Ivanov

Founder ofHawkValue

If it doesn’t save you time or money, you won’t see it here

• Facts, not hypeEvery price and number is checked against the official source
• Always the real priceYou see what it costs before you click
• I say when it’s weakEven when it’s OpenAI or Google

All articles by Ivan →