Manuel Villmer
Back to the projects

Case study · 2026

One hub for articles, sources and the book catalog

Clientwater.day

An online magazine about water education needed to manage a fast-growing multilingual collection of content and publish a library of books on its website. I built the content hub, the AI-assisted book library and the nightly website sync.

Book library in Airtable with a book record showing AI subject tags, their explanation and an audit
SectorWater education magazine
ProjectOctober 2025 to July 2026, five phases
Built withAirtable, Make, Webflow, Apify, Airtable AI, Fillout

The problem

Articles, water facts, social posts, images, videos, sources and studies in four languages kept growing,

and every source and image credit had to hold up when someone asked.

The magazine also wanted a library of books on water, published on its website and kept current without manual exports.

The goal

Answer source and copyright questions quickly and help the editors find content.

The scope

  1. 01A content hub with search across every content type and language
  2. 02Sources and studies as linked records, so credits appear on the public page
  3. 03A book library filled from online sources, with AI extracting each book’s details
  4. 04Topic tags from the magazine’s own content matrix, each with an AI explanation, audit and re-run
  5. 05A nightly sync of tags and books to the Webflow site, with affiliate links and a broken-link check
  6. 06A related database for a second water organization, with a review workflow and input forms
  7. 07Written documentation and video walkthroughs for each part of the system
Image library in Airtable with an image record and the content it is used in
Image library with credits and usage links. Client details are blurred.
Gallery of book covers in the Airtable book library
The book library as the editors see it.

Key decisions

  1. 01Tags sync before books, so no book page links to a tag the website does not have yet.
  2. 02Removing a book from the website is a lasting switch, separate from a one-time forced sync.
  3. 03Only records changed since the last run are sent, and each record keeps its Webflow item ID.
  4. 04Duplicates are caught by ISBN before they enter the library.
  5. 05Terms in the second database live in one central taxonomy, so they can move and have more than one parent.
Content matrix in Airtable with content cards grouped by theme
Content matrix by theme. Client details are blurred.

“Everything was beautifully based on a fixed price project, and he is capable of meeting agreed deadlines. Manuel is also one of those developers who really thinks things through and actively offers solutions that go beyond the requirements, sometimes even implementing them as part of the project.”

Oliver Wegner · Founder, water.day

Your workflow is different again. Show it to me.

Book a free 30-minute call(opens in a new tab)