FlowKit

PDF guide · 28 pages A4 · October 2026 edition

The Data Handling Manual

Items and item linking, Split Out, Aggregate, Merge and loops, AI output parsing, files and binary data, deduplication and persistent state: worked recipes with the input, the settings and the real output

€29VAT included · one-time

Cover of the PDF guide “The Data Handling Manual”

28-page A4 PDF (1.5 MB), 10 chapters, paginated chapter list. Instant download, corrected editions included.

Get the guide€2914-day money-back guaranteeSecure payment by Stripe · card, Apple Pay or Google Pay · One-time payment · Instant download

After payment

  • Next page: the link to download your PDF.
  • The same link is also sent to you by email.
  • Lost the link? Find my purchases (by your payment email).
  • 14-day guarantee: an email to admin@tech-bharat.com is enough.
  • No calls, no texts: everything happens by email.

Most broken n8n workflows are data problems: three items where you expected one, an expression reading the wrong item, an AI answer that slips past a loose schema, a CSV column that comes back as text, a deduplication history that fills up. This manual solves them one recipe at a time, each with its input, the node settings as they appear in the editor and the output obtained on n8n 2.45.6 on 29 October 2026, including the behaviours the documentation does not spell out.

A4 pages
28A4 pages
chapters
10chapters
latest edition
Oct 2026latest edition

For you if

  • You build n8n workflows and lose time on “Multiple matches found”, empty fields after a Merge or a node that runs once too often
  • You turn AI answers into fields that feed a Switch, a database or a customer email
  • You import files, deduplicate leads or keep state between executions and want it to hold for months

14-day money-back guarantee

One email is enough for a full refund, no questions asked. Download right after payment, link also emailed to you.

What you get

What is inside the guide

  • 29 recipes, 28 pages

    10 chapters with a paginated table of contents; each recipe gives the input, the settings and the real output.

  • Items and item linking

    Execute Once, .item versus .first(), pairedItem in the Code node, the silent null after a Merge Append, with the exact error messages.

  • Split Out and Aggregate

    Array to items, all items into one item, parallel lists, batches of N with Loop Over Items, totals per group with Summarize.

  • Merge without surprises

    Inner, left, right, full and anti-join on the same data, SQL Query and its reserved word, the position trap.

  • AI output you can trust

    Structured Output Parser from an example versus a JSON Schema: what each accepts and refuses, the output wrapper, Auto-Fix Format.

  • Files and binary data

    CSV, XLSX and JSON round trips, the invisible byte-order mark, getting numbers back, base64 to file and back.

  • Duplicates and state

    Remove Duplicates within a batch and across runs (and its history cap), Compare Datasets, getWorkflowStaticData, Data Tables.

  • Cheat sheet and checklist

    One page of answers with recipe numbers, and an eleven-step debugging checklist.

Actual chapter list

10 chapters, pages 5 to 28

  1. 01Read this manual on one pagep. 5
  2. The ten rules to remember5
  3. The sample data5
  4. How to read a recipe6
  5. 02Items and item linkingp. 7
  6. Recipe 1 — Count what a node really receives7
  7. Recipe 2 — Read an earlier node after a regrouping7
  8. Recipe 3 — Keep the link from a Code node8
  9. Recipe 4 — The silent null after a Merge Append9
  10. 03Lists and items: Split Out and Aggregatep. 10
  11. Recipe 5 — Split an array into items10
  12. Recipe 6 — Split and keep a parent field10
  13. Recipe 7 — Aggregate all items into one item11
  14. Recipe 8 — Aggregate individual fields into parallel lists11
  15. Recipe 9 — Aggregate items into batches of N12
  16. Recipe 10 — Totals per group (Summarize)12
  17. 04Joining two flows: Mergep. 13
  18. Recipe 11 — Keep only the matches (inner join)13
  19. Recipe 12 — Enrich one side (left and right join)13
  20. Recipe 13 — Keep everything, or only what does not match13
  21. Recipe 14 — Join and total with SQL14
  22. Recipe 15 — The position trap, and waiting for two branches14
  23. 05Loops and batchesp. 16
  24. Recipe 16 — Loop Over Items, step by step16
  25. 06Turning AI output into reliable fieldsp. 17
  26. Recipe 17 — Schema from a JSON example: types only17
  27. Recipe 18 — JSON Schema: enums, bounds, optional fields18
  28. Recipe 19 — Read the result, and decode the error messages18
  29. Recipe 20 — When parsing fails anyway19
  30. 07Files and binary datap. 20
  31. Recipe 21 — Items to CSV and back20
  32. Recipe 22 — Get your types back after a file21
  33. Recipe 23 — Items to a JSON file: one file or one per item21
  34. Recipe 24 — Base64 string to file, and back21
  35. 08Duplicates and dataset comparisonp. 23
  36. Recipe 25 — Remove duplicates within a batch23
  37. Recipe 26 — Remove items processed in previous executions23
  38. Recipe 27 — What changed since yesterday (Compare Datasets)24
  39. 09Persistent state between executionsp. 25
  40. Recipe 28 — A cursor in workflow static data25
  41. Recipe 29 — An “already processed” table with Data Tables25
  42. 10Cheat sheet and debugging checklistp. 27
  43. Cheat sheet27
  44. Debugging checklist, in order27
  45. Sources28

Preview

Two real pages of the PDF

Chapter list page of the guide “The Data Handling Manual”
Page 3: chapter list (click to enlarge)
An inside page of the guide “The Data Handling Manual”
Page 11 (click to enlarge)

Compare before you buy

What already exists, and what this guide adds

OptionWhat it gives youWhat is missing or what it costs
n8n documentationThe exact reference for each node, free.One page per node; behaviours found by running them (the CSV byte-order mark, the deduplication history cap, the parser’s misleading error) are not written there.
Forum threads and blog postsA quick answer to one question.Often written for older node versions (Item Lists, Function, Split in Batches), rarely with the output shown.
Asking an AI assistantInstant and free.Plausible settings with no execution behind them; parameter names from earlier n8n versions.
This manualRecipes run on n8n 2.45.6, settings and outputs printed, traps flagged.€29 once, corrected editions included, 14-day guarantee.

In pictures

Hand taking notes in a notebook
Hand taking notes in a notebook. Photo: geekcalendar, CC BY 2.0
Desk cluttered with books, files and a screen
Desk cluttered with books, files and a screen. Photo: trec_lit, CC BY 2.0
Fountain pen on a page of handwritten notes
Fountain pen on a page of handwritten notes. Photo: vidalia_11, CC BY 2.0

Illustrative photos, published by their authors under a free licence.

The Data Handling Manual — €29

One-time payment, PDF downloaded straight away, corrected editions included. Full refund for 14 days.

Get the guide€2914-day money-back guaranteeSecure payment by Stripe · card, Apple Pay or Google Pay · One-time payment · Instant download

After payment

  • Next page: the link to download your PDF.
  • The same link is also sent to you by email.
  • Lost the link? Find my purchases (by your payment email).
  • 14-day guarantee: an email to admin@tech-bharat.com is enough.
  • No calls, no texts: everything happens by email.

Payment and delivery

Pay with confidence, import right away

  • Checkout by Stripe

    Card, Apple Pay or Google Pay on Stripe's checkout page: your card details never touch our servers.

  • Instant access

    ZIP link on the confirmation page, copy by email, purchases findable at any time.

  • One-time payment, VAT included

    No subscription, invoice by email, updates included.

  • 14-day money-back guarantee

    Full refund on a simple email to admin@tech-bharat.com, no questions asked.

How it works

  1. You pay on Stripe

    By card, Apple Pay or Google Pay, on Stripe's checkout page: your card details never touch our servers. One-time payment, invoice sent by email.

  2. You download right away

    The PDF link appears on the confirmation page and is also emailed to you; it stays valid for later editions.

  3. Something wrong? We refund you

    For 14 days, full refund on a simple email to admin@tech-bharat.com, no questions asked.

Seller: LACANGEL GROUP (SAS, Paris, France, VAT FR21995268018). Prices VAT included. Terms of sale

Free, on the blog

Articles that lead into this guide

FAQ

Frequently asked questions

Which n8n version was used?

n8n 2.45.6, the stable release on 29 October 2026, on an empty instance. Every output in the guide was obtained by running the recipe; another version may differ, and corrections are carried into the next edition.

Is it a translation of the French manual?

An adaptation: same subject, rebuilt around worked recipes, with new chapters on AI output parsing, files and deduplication. The French “Manuel des données” covers dates, the Code node and error handling in more depth.

Does it work on n8n Cloud?

Yes for everything except the self-hosted settings it mentions (the data table size variable). The nodes and their behaviour are the same.

Is it part of the English guides library?

No: it is sold on its own, outside the English guides library.

How is the guide delivered?

As an A4 PDF file, downloadable right after payment from the confirmation page; the link is also emailed to you and stays available from the “Find my purchases” page. Readable on desktop, tablet and phone, and printable (the checklists are meant to be ticked).

What if the guide is not right for me?

14-day commercial guarantee: full refund on simple email request to admin@tech-bharat.com, no questions asked (terms and conditions, article 6).

In the same collectionOther PDF guides

PDF guide · 28 pages

Choosing Your Automation Tool

n8n, LangChain, Activepieces, Pipedream, Windmill, Flowise, Dify: licences quoted from the official texts, billing units converted, five typical situations and a migration checklist

€24VAT included

See the guide

PDF guide · 30 pages

Server-Side Automation

Execute Command, SSH, SFTP and Python: running commands in Docker, custom images, remote jobs, file transfers, native Python with pandas and numpy, and Docker networking, in recipes run on n8n 2.45.7

€29VAT included

See the guide

PDF guide · 29 pages

Files and Binary Data

Uploads, downloads, binary data modes, large files, archives and object storage: 14 recipes run on n8n 2.46.4

€29VAT included

See the guide

PDF guide · 27 pages

Reliable Workflows

Idempotency, workflow state, deduplication, locks, retries and error handling: 13 recipes run on n8n 2.46.6, with the failures reproduced

€29VAT included

See the guide

PDF guide · 29 pages

Selling Automation Services

Offers, pricing, contracts and hosting for clients: n8n’s licence quoted, fixed price, retainer and hourly, shared or dedicated instances, EU contract and data processing clauses, quote and monthly report templates

€24VAT included

See the guide

PDF guide · 27 pages

Server-Side Conversion Tracking

Meta Conversions API, Google Ads Data Manager API, GA4 Measurement Protocol and LinkedIn Conversions API from your workflows: 12 recipes run on n8n 2.46.6 against a local validating server

€29VAT included

See the guide

PDF guide · 17 pages

Connect Any API

n8n’s HTTP Request and Webhook nodes in depth: authentication, pagination, rate limits, errors, HMAC signatures and de-duplication, every behaviour tested on n8n 2.45.7

€24VAT included

See the guide

PDF guide · 16 pages

WhatsApp and Telegram Bots

Create, connect and run a bot with n8n: BotFather, Meta Cloud API, the 24-hour window, templates, October 2026 WhatsApp pricing, scoped AI, duplicates and outages

€24VAT included

See the guide