My Full Make.com Blueprint For Automating a Sheets → OpenAI → Ghost Content Pipeline
I wired my entire content pipeline into Make.com so a single row in Google Sheets turns into a published Ghost post. Here is the exact scenario, module by module.
Tags
AI
Make.com Error Handling Patterns That Actually Work
The worst Make.com scenarios are not the ones that crash. They are the ones that silently stop working. Here is how I design every scenario to make failure loud and obvious.
How AI Overviews Actually Work (And How I Get Content Cited)
AI Overviews are not magic. They are structured pattern-matching machines. Here is how I use entity consistency, FAQ schema, and llms.txt to get my content cited.
How I Built an llms.txt For My Clients (And Why It Beats Your Sitemap)
I stopped obsessing over sitemaps and started shipping llms.txt files instead. Here is how I built them for real clients and what actually matters for LLMs.
What Is GEO And Why Your Website Needs It In 2026
SEO was for ranking in search results. GEO is for being understood by AI. Here is why that shift matters for your website in 2026 and what to do first.
My Exact OpenAI Prompt For Blog Posts That Don’t Sound Like AI
After three months of abusing GPT to write my blog, I ended up with a very opinionated system prompt. Here is the exact prompt, the banned phrases, the structure rules, and what actually mattered.
CSS
CSS clip-path Animations I Actually Use For Scroll Reveals
How I use CSS clip-path for scroll reveals and hero transitions without ScrollMagic, GSAP, or a single animation library. Just CSS, a bit of IntersectionObserver, and some opinionated patterns.
CSS Logical Properties: How I Replaced Left/Right Without Breaking Everything
I migrated a real client project from left/right CSS to logical properties without breaking layout or deadlines. This is what actually worked.
Using CSS Custom Properties As Design Tokens (Without A Design System)
How I use plain CSS custom properties as a design token system for real projects. Spacing, color, and motion tokens. No Figma. No toolchain. Just code.
The Scroll-Driven CSS Animation I’m Most Proud Of (After 4 Rewrites)
I built a scroll-driven CSS animation that took four full rewrites before it stopped fighting me. This is the build log, including the ugly parts and the final clean setup.
CSS Container Queries In Production: Where They Shine And Where Media Queries Still Win
I refactored a real production project from media queries to container queries. This is what actually changed, what stayed the same, and where each approach still wins.
Building A Personal Metrics Dashboard With Vanilla JS And CSS Grid
How I built a fast personal metrics dashboard with vanilla JS, CSS Grid, and localStorage. No frameworks, no build tools, just browser-native tech that I actually use.
Frontend
My Full Make.com Blueprint For Automating a Sheets → OpenAI → Ghost Content Pipeline
I wired my entire content pipeline into Make.com so a single row in Google Sheets turns into a published Ghost post. Here is the exact scenario, module by module.
My GEO Audit Checklist For Every New Client (With Real Fixes)
This is the GEO audit I run on every new client site. Schema, llms.txt, entities, FAQ structure, and the real fixes that actually move the needle.
CSS clip-path Animations I Actually Use For Scroll Reveals
How I use CSS clip-path for scroll reveals and hero transitions without ScrollMagic, GSAP, or a single animation library. Just CSS, a bit of IntersectionObserver, and some opinionated patterns.
CSS Logical Properties: How I Replaced Left/Right Without Breaking Everything
I migrated a real client project from left/right CSS to logical properties without breaking layout or deadlines. This is what actually worked.
Using CSS Custom Properties As Design Tokens (Without A Design System)
How I use plain CSS custom properties as a design token system for real projects. Spacing, color, and motion tokens. No Figma. No toolchain. Just code.
How I Evaluate a New Dev Tool (My 3‑Question Filter)
I run every new dev tool through the same 3‑question filter before it touches my real workflow. Here is how Cursor, Tower, and SecondsPro managed to earn their place.
Productivity
What 90 Days Of HRV Data Taught Me About Stress I Thought I Was Managing
I logged HRV every day for 90 days and realised my “I’m fine” story was mostly fiction. The data showed stress patterns I never would have blamed.
Speed vs Correctness: What Youth Baseball Umpiring Taught Me About Production Deploys
Umpiring youth baseball taught me more about production deploys than any DevOps book. Both are about making fast, irreversible calls with incomplete data and living with them.
Why I Still Plan My Week On Paper In 2026
I have tried every productivity stack you see on Twitter, but one thing never moved: a weekly paper planning note. Here is what it does that no app can touch.
My Anti-GTD Todoist Setup: Flat, Fast, and Review-Free
How I run client work, side projects, and life in Todoist without GTD, weekly reviews, or nested hierarchies. A flat, fast setup that survives real work instead of theory.
My Exact OpenAI Prompt For Blog Posts That Don’t Sound Like AI
After three months of abusing GPT to write my blog, I ended up with a very opinionated system prompt. Here is the exact prompt, the banned phrases, the structure rules, and what actually mattered.
The Make.com Modules I Actually Use Every Week (And The Ones I Killed)
I spent a few weekends brutally auditing my Make.com scenarios. These are the modules that actually earn their place every week, and the ones I ripped out as pure complexity.
Biohacking
Intermittent Fasting at 56: What I Changed After 18 Months
After 18 months of intermittent fasting at 56, I stopped pretending 16:8 is a magic template. This is what I kept, what I changed, and what actually works now.
What 90 Days Of HRV Data Taught Me About Stress I Thought I Was Managing
I logged HRV every day for 90 days and realised my “I’m fine” story was mostly fiction. The data showed stress patterns I never would have blamed.
Keeping Fit At 56: Why 70% Effort Beats 100% Hero Workouts
At 56 I stopped chasing soreness and started chasing repeatability. Three sessions at 70% beat five at 100% if you actually want to stay strong for decades.
Why I Track HRV Every Morning (And How It Actually Changes My Day)
I check HRV every morning, but I do not treat it like a gadget stat. I treat it like a traffic light that decides how hard I train, how I work, and how I recover.
Why I Dropped MyFitnessPal And Switched To Eet Meter For Serious Calorie Tracking
I stopped using global calorie tracking apps and moved to the Dutch Eet Meter during a GLI trajectory. This is what actually worked with a real dietitian and real Dutch food.
20-Minute Kettlebell Complexes For Developers Who Sit All Day
How I use 20-minute kettlebell complexes and Seconds Pro to get 3–4 real training sessions a week without wrecking my back or my motivation. Built for developers who sit all day.
Tools
How I Automated My Ghost Member Welcome Flow With Make.com
I wired Ghost into Make.com so new members hit a proper conditional welcome flow instead of a single bland email. Here is the exact scenario, modules, and gotchas.
Make.com Error Handling Patterns That Actually Work
The worst Make.com scenarios are not the ones that crash. They are the ones that silently stop working. Here is how I design every scenario to make failure loud and obvious.
How I Evaluate a New Dev Tool (My 3‑Question Filter)
I run every new dev tool through the same 3‑question filter before it touches my real workflow. Here is how Cursor, Tower, and SecondsPro managed to earn their place.
The Make.com Modules I Actually Use Every Week (And The Ones I Killed)
I spent a few weekends brutally auditing my Make.com scenarios. These are the modules that actually earn their place every week, and the ones I ripped out as pure complexity.
15 Minutes A Day: The Compounding ROI Of Relearning Touch Typing At 57
At 57, I relearned touch typing with 15 minutes a day on TypingClub. The speed bump was nice, but the real ROI came from treating my keyboard as a serious interface problem.
Why I Still Rely On Tower For Git In The Era Of AI Coding
AI tools can write the CSS and scaffold components, but they do not own my Git history. I still rely on Tower because visual Git control is non-negotiable.
Build in Public
20 Years of richardlemon.com – A Website Grows Up
What the Wayback Machine remembers about you – and what it says about where you're going.
How I Automated My Ghost Member Welcome Flow With Make.com
I wired Ghost into Make.com so new members hit a proper conditional welcome flow instead of a single bland email. Here is the exact scenario, modules, and gotchas.
My GEO Audit Checklist For Every New Client (With Real Fixes)
This is the GEO audit I run on every new client site. Schema, llms.txt, entities, FAQ structure, and the real fixes that actually move the needle.
How AI Overviews Actually Work (And How I Get Content Cited)
AI Overviews are not magic. They are structured pattern-matching machines. Here is how I use entity consistency, FAQ schema, and llms.txt to get my content cited.
How I Built an llms.txt For My Clients (And Why It Beats Your Sitemap)
I stopped obsessing over sitemaps and started shipping llms.txt files instead. Here is how I built them for real clients and what actually matters for LLMs.
Speed vs Correctness: What Youth Baseball Umpiring Taught Me About Production Deploys
Umpiring youth baseball taught me more about production deploys than any DevOps book. Both are about making fast, irreversible calls with incomplete data and living with them.
Thoughts
20 Years of richardlemon.com – A Website Grows Up
What the Wayback Machine remembers about you – and what it says about where you're going.
A New Chapter: Biohacking My Way to a Healthier Me
As the year ends, I’m excited to share the beginning of my weight loss journey—a journey I’m
Baseball Analytics For U15 Coaches: Useful Data Without Trackman
How I track exit velocity, strikeout rate, and walk rate for U15 players using pocket radar, paper, and simple routines. No Trackman, no excuses.
How I Run a U12 Baseball Practice With 19 Kids (And Keep Them Focused)
How I structure a 90-minute U12 baseball practice for 19 kids and two assistants without losing my mind. The same attention and feedback tricks I use in code reviews now live on a dusty infield.
Why I Dropped MyFitnessPal And Switched To Eet Meter For Serious Calorie Tracking
I stopped using global calorie tracking apps and moved to the Dutch Eet Meter during a GLI trajectory. This is what actually worked with a real dietitian and real Dutch food.
Launching Crypto Klatsers: From Smart Contract to Live Domain in 24 Hours
Today was a milestone. I successfully launched Crypto Klatsers (KLT), the first unofficial crypto-currency dedicated to the city of Maastricht. It wasn't just about minting a token; it was about building the entire ecosystem from the ground up.