I built 18 free n8n workflows. Here is the one that saved me the most time.
Most automation advice is written for people who already have their stack sorted. This is
not that. This is the specific workflow I reach for first, and why it survives contact with
real data.
The problem
Every automation project dies at the same place: the source data is messier than the demo
assumed. A CSV with three date formats. A webhook that sends a string where you expected a
number. An API that returns 200 with an error body inside it.
You can either write defensive parsing everywhere, which is unmaintainable, or normalise
once at the edge, which is what actually works.
The shape that works
Webhook / Cron trigger
|
v
Normalise node <- the only node that knows your data is ugly
|
v
Validate + branch <- bad rows go to a side branch, not a crash
|
v
Do the work
|
v
Log the outcome <- so the next failure is diagnosable
Three things in that diagram are the whole lesson:
One normalise step, at the edge. Not scattered through the flow. It takes whatever
arrived and emits a known shape. Everything downstream can then assume that shape and stay
readable.
Bad data goes sideways, not down. A branch that catches invalid rows and writes them
somewhere you can look at turns a silent data loss into a list you can fix. The failure
mode you want is a row in a table, not a workflow that quietly processed 980 of 1,000.
Log the outcome. One row per run: timestamp, count in, count out, count rejected. When
something looks wrong a month later, that table answers the question in seconds instead of
an afternoon of re-running.
What I would do differently
Two things, both learned the hard way.
Do not build the alerting first. I have watched people spend a week on a notification
stack before the workflow has processed a single real record. Get the happy path working on
real data, then add alerts for the failure you have actually seen.
Do not over-abstract early. A sub-workflow that handles four cases you have not
encountered is a guess. Duplicate twice, then extract when the third caller appears and you
can see what the real interface is.
The workflows themselves
There are 18 of them, free, no signup: pdf.mauitechhub.com/workflows
They cover the boring parts that are genuinely annoying to rebuild - parsing, normalising,
retrying, logging, deduplicating. Import them, read them, change them. That is what they are
for.
If you hit one that does not do what its description says, tell me. That is a bug and I want
to know.
Top comments (0)