Your First Automation: Build It, Break It, Switch It Off

T05-L01 · Automation · Level 1 User · 11-minute read, plus 45 minutes of doing

The same six things, every Monday

Every Monday you copy the same details from one place to another. In the lab it is the freezer log: during the week you scribble box IDs, freezer positions and contents on a glove box or in your notebook, and on Monday you type them into your own log sheet. By then one note is missing, and you spend ten minutes opening freezer doors to find box 14.

In a company it is the call log. You take a dozen customer calls a week and note them on paper. On Friday you type customer, topic and "needs a follow-up?" into a spreadsheet. Half the time you can no longer tell whether a call needed a follow-up.

The copying is dull, and it happens too late. An automation fixes both: you enter the details once, at the moment they happen, and a workflow writes them into your log with the time attached. This book builds that workflow with n8n. You are at Level 1 User: the log is yours, so if the workflow breaks, only you are affected. That makes this a good place to break it on purpose.

After this you can

• Take one repeated copy-and-paste job through the four quadrants to a working trigger and action.
• Build a form-to-table workflow in n8n Cloud and test it with a real entry before switching it on.
• Read the run history and tell a successful run from a failed one, even when the form said thank you.
• Switch the workflow off, and say where it runs when your laptop is closed.

Before you start

• Books: T01-L01 · From Idea to Working Result: The Four-Quadrant Method for the four-quadrant method, and T01-L03 · Build the Smallest Thing Your Colleagues Can Run Without You for choosing the simplest tool.
• An n8n Cloud trial account. Sign up at n8n.io. You get your own workspace in the browser; nothing to install.
• One repeated copying job from your own week, with three or four details you copy each time.
• About an hour: 11 minutes to read, 45 to do.

Last verified 23 September 2026. n8n Cloud has a free 14-day trial with 1,000 runs and no credit card. After that, the cheapest plan costs 24 € a month. If you don't upgrade, n8n deletes the trial workspace. Details for experts at the end of this book.

The idea in one page

An automation has two parts. A trigger decides when it starts: a form is submitted, a file appears, it's Monday at 8:00. An action does the work: add a row, send a message, save a file.

In n8n each part is a node, a box on the screen. A workflow is a set of nodes joined by lines on the editor page.

Each form you build has two web links. The Test URL works only while you are testing; the Production URL works once the workflow is switched on.

Every time the trigger fires, n8n makes one execution, one run through the workflow. The Executions tab lists them with a status: Success, Failed, Running or Waiting. That list is your run history. It is the only honest answer to "did it work?"

A workflow has two modes, and mixing them up causes most beginner trouble:

Three facts change how you work:

1. It runs on n8n's servers. Once published, a Cloud workflow keeps working when your laptop is closed. That's the point, and it's also why you need to know how to stop it.
2. The trigger's reply tells you nothing about the rest. A form set to answer as soon as it is submitted says thank you before the workflow has done anything. If a later node fails, the person filling in the form never knows.
3. The off switch is Unpublish. Find it before you publish, not while something is misfiring.

Which tool? This book uses n8n: a visual editor, strong enough to grow with you, and it can later run on your own server. Make is a visual middle ground with many ready-made connectors, the links to other apps. Zapier connects the most apps with the least setup, but offers less control. All three teach the same ideas; what you learn here carries over.

Worked example: a log that fills itself

The method comes from T01-L01 · From Idea to Working Result: The Four-Quadrant Method: start with the problem, explore it, then pick the tool and build the smallest version. Here it is on the freezer log, then on the call log.

Lab: the freezer-box log

Structure it. "Every Monday I spend 20 minutes typing last week's freezer notes into my log, and about one box a month goes missing from it. A good result: each box is logged the moment it goes in, with the time, and nothing is lost."

Understand it. She looks at a month of notes. The typing is dull, but the real damage comes from the delay: notes written on gloves and scraps don't survive until Monday. She also notices she always writes the same three things: box ID, position ("-80 B, shelf 3") and contents. She never writes the date, and she has needed it twice. Back to Structure it: "Log box ID, position and contents from my phone at the freezer, and stamp the time automatically."

Choose tools. Going down the ladder: typing straight into a spreadsheet on the phone works, but it's fiddly with gloves on, and nothing stops her from skipping a field. A form fixes both. It makes every field required, and the workflow adds the time. n8n's built-in data table holds the log, so she needs no spreadsheet account and no passwords. Nothing here needs AI.

Build it. Seven steps, about 35 minutes.

1. Make the table. After you log in, n8n shows its Overview page. Open its Data tables tab, click the small arrow on the button at the top right and choose Create Data table. Name it freezer_log and choose From scratch. Then add four columns of type String, which means plain text, with these names:

   Copy

   box_id   position   contents   logged_at
   

2. Add the trigger. On the Overview page, click Create Workflow and name the workflow Freezer log. You now see the canvas: an empty grid where the boxes go, with a large plus sign in the middle marked Add first step…. Click it, type form into the search box and choose On form submission.

   n8n puts a form box on the canvas and opens it as a large panel. The settings run down the middle of the panel, one below the other. At the very top are two web links to your form, a test one and a real one; you need them later. Work down from there:

   • The first setting, Authentication, decides who may fill in the form. Choose n8n User Auth: only someone logged in to your n8n can submit.
   • In the title box, type Freezer log. This is the heading people see on the form.
   • Below the title is the list of questions. Click Add Form Element three times, once each for box_id, position and contents. Each click adds a small card. Type the question's name into its top two boxes: Field Label is the text the person sees, and Field Name is the name the next box reads, so spell it exactly the same. Leave the type at Text, and turn on the Required Field switch on the card.
   • Near the bottom, leave Respond When at Form Is Submitted: the form thanks the person straight away.

   Close the panel. The form box now sits alone on the canvas.

3. Add the action. On the right edge of the form box is a small plus sign. Click it, search for Data table and choose Insert row. A new box appears, joined to the form by a line, and its panel opens.

   In this panel, pick your table first: open the table setting, choose From list, then freezer_log. Below it, a setting asks how to fill the columns. Choose Map Each Column Manually, so you decide what goes where. One input box now appears for each column of your table. Hover over each box, switch it from Fixed to Expression, and type the matching line:

   Copy

   box_id     {{ $json.box_id }}
   position   {{ $json.position }}
   contents   {{ $json.contents }}
   logged_at  {{ $json.submittedAt }}
   

   The double braces tell n8n to read the value from the form entry instead of writing that text literally. n8n calls this an expression. submittedAt is the time stamp the form adds to every entry. Close the panel.

4. Test with a real entry. Click Execute Workflow. n8n opens the test form. Enter a real box, for example:

   Copy

   box_id     B-014
   position   -80 B shelf 3
   contents   plasmid preps, week 38
   

   Submit, then go back to the editor. Double-click the Data table box: the right side of its panel shows the row it wrote. Open the table in the Data tables tab and check all four cells, including the time. If a cell shows the double-brace text itself, that value was typed as fixed text rather than as an expression. Fix it and run the test again.

5. Switch it on. Click Publish at the top of the canvas, then Publish again in the window that opens. Double-click the form box, switch the links at the top of its panel to Production URL, and copy it. Bookmark it on your phone, and log in to n8n in that phone browser, because of the authentication you chose. Submit one real box from the freezer. In the workflow's Executions tab you now see a run marked Success, and the row is in the table.

6. Break it on purpose. Between the form and the Data table node, add a Stop and Error node, which makes the run fail on purpose (hover over the connecting line to insert a node there). Set Error Type to Error Message and type Deliberate test failure. Publish again. Submit a test box through the Production URL. The form thanks you as usual. Now look at Executions: the run is Failed, and the table has no new row. This is the failure you would never notice from the phone.

7. Fix it, then find the off switch. Delete the Stop and Error box. Reconnect the other two: drag from the grey dot on the right of the form box to the left side of the Data table box. Then publish. Then open the small arrow next to the Publish button and find Unpublish. Decide now: if you'll use the log this week, leave it published. If not, unpublish it. Either way, you know where the switch is.

What it taught her: the thank-you page can lie. For a log only she uses, checking the Executions tab once a week is enough. If colleagues start using the form, she'll need a warning message when a run fails. That's the next trip round the quadrants (T05-L04 · Make an Automation Safe to Fail Before It Touches Real Systems).

Company: the call log

Structure it. "I type about twelve call notes into a spreadsheet every Friday, and half of them don't say whether I promised a follow-up. A good result: each call logged within a minute of hanging up, and a follow-up flag on every one."

Understand it. He compares a month of paper notes with his inbox. The missing follow-up flags are the real cost: two customers waited a week for a callback he had promised. The typing is a minor cost. Back to Structure it: "Log customer, topic and follow-up yes/no right after the call. The follow-up answer can't be skipped."

Choose tools. The same skeleton as the lab: a form, a data table, no AI. The one change is the follow-up field: a Dropdown element with yes and no, marked required, so the question can't be left blank.

Build it. He follows the same seven steps with a table called call_log and the columns customer, topic, follow_up and logged_at. He keeps the form link open in a browser tab next to his phone software. In step 6 he sees the same thing: the form says thank you, the run is Failed, and no row appears. What it taught him: he'd rather know within the hour, because a lost call note means a customer waiting. His next trip round the quadrants is a failure message, and after that a Monday summary of every open follow-up (T05-L02 · Put AI in the Middle of a Workflow, and Check Every Answer).

In both cases the automation is small: one trigger, one action. The value came from Understand it: the problem was never really the typing.

What goes wrong

Switching it on before testing. Symptom: you publish, submit from your phone, and the table fills with rows that read {{ $json.position }}. Fix: always run Execute Workflow with a real entry first, and check every cell of the result before you click Publish.

Testing with the wrong link. Symptom: you submit the form and nothing appears in the Executions tab, or the editor sits waiting. Fix: the Test URL works only while the editor waits after Execute Workflow. The Production URL works only after Publish. Use the right one for what you're doing.

Trusting the thank-you page. Symptom: weeks later you find gaps in the log, although every submission "went through". Fix: look at the Executions tab, filtered to Failed, once a week. When other people depend on it, set an error workflow, a second workflow that runs when this one fails, in the workflow's Settings (three-dot menu, top right) so a failure notifies you (T05-L04 · Make an Automation Safe to Fail Before It Touches Real Systems).

A trigger that fires on everything. Symptom: runs you didn't expect, or your trial's 1,000 executions shrinking fast. Fix: prefer triggers you control, like a form. A "whenever anything changes" trigger on a busy folder or inbox fires on every change. Filter it before you publish.

Forgetting where it runs. Symptom: you close the laptop and assume the automation has stopped, or you're surprised that it has kept running for weeks. Fix: a published Cloud workflow runs on n8n's servers. Only Unpublish stops it.

Building on a trial account. Symptom: day 15, your workspace is gone, and so is your log. Fix: before the trial ends, either choose a plan or download the workflow and copy the table's rows somewhere you keep. Never put the only copy of anything important on a trial account.

Do it yourself (45 minutes)

Use your own repeated copying job, not the freezer or the call log.

1. Structure it (5 min). Write one sentence: what you copy, how often, and what a good result looks like. List the three or four details you copy every time.
2. Understand it (10 min). Look at the last few weeks of that job. Where does it actually go wrong: the typing, the delay, or a detail that's often missing? Rewrite your sentence if you learned something.
3. Choose tools (5 min). Could a spreadsheet or a template do it? If a form plus a log is the simplest thing that solves what you found, continue. Keep personal data about other people out of your practice log (T12-L01 · Decide What You May Paste Into AI at Work).
4. Build it (25 min). Follow the seven steps with your own fields. Test with a real entry, publish, submit once for real, break it with Stop and Error, look at the failed run, then fix it and decide whether to leave it on.

Exit check

What you hand in: a screenshot of your workflow's Executions tab showing at least one Success and one Failed run, plus one line: "The off switch is ___, and while it's published it runs on ___."

It passes when the failed run left no row in your table, and you can explain in one sentence why the form still said thank you.

Rule to remember

Know how to stop it before you start it.

Details for experts

Checked on 23 September 2026. You don't need this to follow the book; it's for setting things up or answering a colleague.

Further reading and tools

Next books

• T01-L03 · Build the Smallest Thing Your Colleagues Can Run Without You: when an automation is the right choice, and when a template is enough.
• T05-L02 · Put AI in the Middle of a Workflow, and Check Every Answer: adding a model step, and checking its output before you use it.
• T05-L04 · Make an Automation Safe to Fail Before It Touches Real Systems: failure alerts, retries and a way to take over by hand.
• T12-L01 · Decide What You May Paste Into AI at Work: what may go into a form or a cloud service.

Tools

• n8n: Taught. The Cloud trial is enough for this book.
• Make, Zapier: Catalogued. Same trigger-and-action ideas, different trade-offs.