LocalLoop - Automated hyperlocal newsletter

A fully automated weekly newsletter for the municipality of Avelgem. From scraping to delivery — without any manual intervention.
Automation
AI / OpenClaw
Mailerlite

The Challenge

Small municipalities like Avelgem lack the resources for a dedicated editorial team, yet generate a lot of local news spread across multiple websites. Residents miss relevant information because they don't actively follow all sources.

The Result

A pipeline that automatically scrapes news from 5 local sources every Monday, generates a formatted HTML newsletter using AI, and creates it as a draft in MailerLite — ready to send with a single click.
30+

Subscribers

Local Avelgem residents receiving their weekly digest, with no paid promotion.

5min

Manual time per edition

Each edition takes less than 5 minutes of human time, limited to an optional final review.

6/7

Steps fully automated

The pipeline runs every Monday at 09:00 UTC — scraping, writing, building and deploying without any manual intervention.

How the pipeline works every monday

From cron trigger to MailerLite draft — the full chain runs autonomously, with only a final human review.

1

Cron trigger

macOS crontab runs localloop-monday.sh
Automatic
2

Scrape sources

OpenClaw fetches news from 5 local websites
AI Agent
3

Generate newsletter

Claude writes HTML based on TEMPLATE.html
Claude AI
4

Verify links

verify-summary.sh checks every link for HTTP 200
Automatic
5

Mailerlite draft

HTML is created as a draft campaign via API
API V3
6

Cloudflare deploy

Wrangler deploys live preview + cache purge
Automatic
7

Review draft and send

Open Mailerlite check the draft and click send, done
Manual

Discover my
other projects

From high-performance Webflow builds to smart AI apps. Explore a curated selection of my recent work.