Call · 30 min
AI systemsMattia Esposito8 November 20267-minute read

How to create an automation. An event, a few actions, and a test before you switch it on.

The automations that fail usually work: they do exactly what they were told, even when the case is different from the one expected. Here is the fourteen-question checklist to close before you switch one on, and the right tool for each task.

In brief

You create an automation starting from a single task: the event that starts it, the conditions, the actions in order, where it writes the result and what it does when data is missing. Before switching it on, you test it on real cases and decide who switches it off.

The tool depends on the task. An Excel macro repeats steps inside a sheet; a Power Automate flow starts from an event, which Microsoft defines as what sets it off, such as an email arriving; WhatsApp Business has welcome messages, away messages and quick replies.

Below is the checklist in Word and PDF, in Italian and English, with a completed example on supplier invoices arriving by email, to download without leaving an email address.

Written by: Mattia Esposito, AI and marketing consultant, founder of Itria AI. From Puglia, based in Turin since 2023, he works remotely in Italy and abroad. LinkedIn profile.

Which process to automate first is on the page about which process to automate first; how to write the process step by step is in the guide on how to create a workflow. This page builds the first automation.

The checklist for your first automation, to download

Fourteen questions in five groups: the task, the trigger and the actions, the odd cases, oversight, the test. If an answer is missing, the automation isn’t ready. The completed example answers them all for a common task: saving the courtesy copies of supplier invoices that arrive by email and logging them in a sheet.

Completed checklist for an automation that saves supplier invoices arriving by email, with the fourteen answers
FileContentsLink
ItalianWord, to fill in

The fourteen questions, each with a hint alongside.

checklist-automazione-it.docx

EnglishWord, to fill in

The same checklist in English.

checklist-automazione-en.docx

ItalianPDF

The copy to print.

checklist-automazione-it.pdf

ExamplePDF, filled in, in Italian

The fourteen answers for supplier invoices, with a fictitious company.

checklist-automazione-esempio-it.pdf

How to create an automation in five moves

Five moves, in the order of the checklist, and the most neglected is the fourth: deciding what the automation does when the case isn’t the expected one. An automation doesn’t get tired and doesn’t hesitate: if a sender is unknown or an attachment is wrong, it carries on, unless someone has told it to stop.

MoveThe questionIn the example
1. The task

Which task, how often, how long, who does it today?

About sixty invoices a week, two minutes each.

2. The trigger

What starts it?

An email with an attachment to the invoices mailbox.

3. Conditions and actions

When does it run, what does it do, where does it write?

If it’s a PDF from a known supplier, it saves it and adds a row to the sheet.

4. The odd cases

What does it do if data is missing, who does it alert if it stops?

Unknown sender: it forwards the email to accounts.

5. Oversight and testing

What does a person approve, how is it switched off, which cases is it tested on?

The previous week’s sixty emails, four from unknown senders.

Which tool to use

Choose the tool for the task, not the other way round. A task inside a single program is automated with that program’s own features; a task that moves between programs needs a flow; a task where text has to be read and understood needs an AI system.

ToolWhen to use itAn example
Mail rules

Moving or labelling emails by sender and subject.

One supplier’s emails into a folder.

Excel macro

Repeating the same steps inside a sheet.

Giving the same format to dates written in different ways.

Automated flow

Connecting different programs, starting from an event.

An email with an attachment, saved to a folder and logged in a sheet.

WhatsApp Business

Replying out of hours or to a first message.

Away message, welcome message, quick replies.

AI agent

Reading text that changes every time and drafting a reply.

A quote request written in their own way by every customer.

A person

Deciding, signing, handling a new case.

The off-list price, the complaint.

How to automate an Excel file

With a macro, recorded once and replayed whenever you need it. Microsoft explains that Excel’s macro recorder records the steps, such as typing, clicking cells and commands, formatting and importing data, and saves them in VBA, Visual Basic for Applications.

The example in Microsoft’s guide is a typical office one: dates arriving in different formats, all to be brought to the same format. You record the macro once while applying the format, then replay it. The limit is the same for every macro: it works inside Excel, and repeats its steps even when the file has changed.

How to automate emails

Mail rules are enough to move or label emails; to do something with the content you need a flow that starts when the email arrives. Microsoft’s Power Automate documentation defines a trigger as an event that starts a cloud flow, and gives receiving an email as its example.

The example flow saves the attachment to a folder and adds a row to a sheet. But if the email has to be read and understood, such as a customer request worded differently every time, a fixed rule isn’t enough: you need a system that reads, classifies and drafts, and a person who approves. The difference is explained on the page about AI agents and chatbots.

Automating WhatsApp Business

Three things can be automated from the app itself: the welcome message, the away message and quick replies. The WhatsApp help centre describes each one. They cover the most common cases: someone writing for the first time, someone writing out of hours, the questions that keep coming back.

Beyond these three cases, replying to customers automatically means using a system that reads the messages and drafts the replies. At that point the question is no longer just technical: the transparency rule towards the person writing comes into play.

When the automation talks to customers

An artificial intelligence system that interacts directly with people must let them know it is a system: Article 50 of Regulation (EU) 2024/1689, the AI Act, requires it, with transparency obligations applying from 2 August 2026. This covers the assistant on a website as much as WhatsApp replies written by an AI.

In Italy the penalties are set by Legislative Decree 179/2026, in force since 23 October 2026: Article 23 punishes failure to comply with Article 50 with fines of up to €15 million or 3% of worldwide annual turnover, and for small and medium-sized businesses the lower of the two applies. This is why question 11 of the checklist asks how the automation introduces itself.

Question 10 asks the other thing that matters: what a person approves. Anything that goes to a customer, involves money or decides something passes through a person before it goes out. That way of working is called human in the loop, and the duty to train people who use AI is on the page about the AI literacy obligation.

Questions and answers

How do you create an automation?

Start from a single task that comes round often: fix the event that starts it, the conditions, the actions in order and where it writes the result, then what it does in the odd cases and who is alerted if it stops.

Before switching it on, test it on real cases, including a few odd ones, and decide who can switch it off.

How do you automate an Excel file?

With a macro: Excel’s macro recorder records the steps, such as formatting cells or importing data, and repeats them whenever you need. The steps are saved in the VBA language.

For tasks that span several programs, such as email and a spreadsheet, you need a flow that starts from an event.

How do you automate emails?

Mail rules move or label emails based on sender and subject. To do more, such as saving an attachment and logging it in a sheet, you need a flow that starts when an email arrives.

If the email has to be read and understood, because every customer writes it differently, you need an AI system with a person approving the replies.

Can you automate WhatsApp Business?

Partly, from the app itself: WhatsApp Business has welcome messages, away messages and quick replies, described in its help centre.

If the automatic replies are written by an AI system, Article 50 of the AI Act requires customers to know they are talking to a system.

What is the difference between automation and artificial intelligence?

A classic automation follows fixed rules: if an email arrives with a PDF, save the PDF. Artificial intelligence is useful where the rule isn’t enough, because the text changes every time and has to be understood.

They often work together: the automation moves the data, the AI reads it and drafts a reply, a person approves.

Notes on sources

  1. Microsoft Learn, Triggers in Power Automate cloud flows, paraphrased from the Italian page; Microsoft Support, Automate tasks with the Macro Recorder. Read on 8 November 2026.
  2. WhatsApp Help Centre: welcome messages, away messages, quick replies.
  3. Regulation (EU) 2024/1689, Article 50, on EUR-Lex; Italian Legislative Decree no. 179 of 7 October 2026, Article 23, paragraphs 2 and 7, on Normattiva, in force since 23 October 2026.
  4. The checklist and the example are built by Itria; the company is fictitious and the minutes are example estimates.
·The next step

Fixed rules move data around. To read it you need a system, and a person who approves.

When the automation has to understand what is written, in a customer’s email or a supplier’s document, an AI agent can read, classify and draft, leaving it for a person to approve. The piece that sorts incoming enquiries classified 96.0% of a hundred enquiries correctly, across four channels and five languages, with a median of 7.3 seconds from enquiry to ready draft: measured on a test bench on 4 September 2026, on a test system.