Which tool to choose
- Simple automations between common apps (Gmail, calendar, spreadsheets, Slack): Zapier is the easiest, you describe in words what you want and it builds the connection.
- Automations with multiple conditions and branches ("if the customer is Italian do X, otherwise Y"): Make shows the flow as a visual map and handles branching logic better.
- You just want the AI to repeat a text task (replying in a fixed format, summarizing): sometimes an assistant with a saved instruction is enough, with no platform in between.
How to do it
- Find the right task to automate. It must have three characteristics: you do it often, it always follows the same steps, and it has clear rules. If it's different every time or requires your judgment, don't automate it.
- Write the automation in words, before touching the tool. The operational syntax, to paste into Zapier's builder:
When a new email with a PDF attachment arrives in the Invoices folder, save the attachment to Google Drive in the current month's folder and add a row to the Expenses spreadsheet with sender, date and file name.
- Connect the accounts you need. The platform asks for permission to access Gmail, Drive, the spreadsheet: you authorize only the necessary ones and nothing more.
- Insert the AI where light judgment is needed. Example: a step that asks the AI to read the email and classify it ("urgent / normal / spam"), so the automation sorts it accordingly.
- Test with a fake case before letting it run. Almost all platforms have a button to test the flow once: use it, check that the result is right, then activate it.
A concrete example
Anna receives dozens of registration forms by email every week and copies them by hand into a spreadsheet. She creates a Zap: when an email with the subject "Registration" arrives, an AI step extracts the name, email and chosen course from the text, and a subsequent step writes them into the spreadsheet. She tests it with a fake email: the fields end up in the right columns. She activates it. From that moment the forms register themselves; all that's left for Anna is a check at the end of the week. Two hours of copy-pasting turned into five minutes of verification.
When it does NOT work (and how to fix it)
If the automation does the wrong action on all the cases at once
An active flow repeats the error on every occurrence, in series. Remedy: keep the first few days in "notify me before acting" mode if the platform allows it, or check the first ten results by hand before trusting it. An error caught on the tenth case is better than on the hundredth.
If the AI classifies or extracts the data badly
This happens when the emails or forms aren't uniform. Remedy: give the AI examples in the instruction step ("here are three typical emails and how they should be classified") and ask it to write "uncertain" when it isn't sure, so you handle those cases yourself instead of getting them wrong automatically.
If you can't find how to connect a specific app
Not all apps are supported, and the menus change. Remedy: search for the app's name in the platform's catalog; if it isn't there, often a generic connection exists via email or through a shared spreadsheet as a bridge. Failing that, consider a different platform that supports it.
A tip from someone who actually uses it
Automate only after you've done the task by hand enough times to know all its exceptions. Those who automate a process they don't master build a machine that makes mistakes quickly and that they can't repair. First understand the rules and the odd cases, then teach them to the machine.
Frequently asked questions
How much does it cost to automate without programming?
The platforms have a free plan that's enough for a few simple automations; the more frequent or complex ones move to a monthly subscription. It's best to start from the free tier on a single task: you find out whether it really saves you time before paying.
What happens if the automation breaks and I don't notice?
The platforms notify you by email when a flow fails, but a silent error (badly extracted data) can go unnoticed. Remedy: add a periodic check of your own and, where possible, a step that sends you a weekly summary of what it did.
Is it true that automating eliminates manual work entirely?
It's the sellers' promise, not the reality. Automation takes away the repetitive part, but adds a new job: watching that it works, handling the exceptions, updating it when the apps change. It shifts the effort from execution to supervision, it doesn't erase it.