n8n

A portfolio of my automation projects, built with n8n to connect tools, APIs and AI and turn real-world processes into practical automated workflows.

Table of Contents

Newsletter Intelligence Pipeline

n8n · Gmail API · OpenAI API · Google Sheets · JavaScript · AI Image Analysis

Case

Turning years of newsletter data into structured marketing intelligence.

A mailbox containing years of newsletters represents a large amount of potentially valuable marketing data, but the information is:

  • unstructured
  • difficult to search systematically
  • time-consuming to analyse manually
  • spread across hundreds or thousands of individual emails

The challenge is therefore not simply to analyse one newsletter, but to create a repeatable pipeline capable of processing a large historical dataset.

The case is about demonstrating how unstructured information can be converted into structured data through automation and AI.

Results

The workflow creates one structured marketing analysis per newsletter, combining text, visual content and newsletter metadata in a consistent format.

This makes it possible to turn a large archive of unstructured newsletter data into a structured marketing intelligence dataset that can be searched, compared and analysed systematically.

The completed workflow can analyse a newsletter and convert its content into structured marketing intelligence at an estimated cost of approximately $0.01 per newsletter analysed.

The analysis captures marketing objectives, target audience, value proposition, key messages, calls to action, persuasion techniques, copywriting style, promotional strategy, brand positioning and visual strategy – including strengths, weaknesses and key marketing insights.

Example of the structured analysis:

Workflow

Gmail → duplicate check → email extraction → text analysis + image analysis → AI synthesis → structured JSON → Google Sheets

[ View on GitHub ]

Workflow overview:

Workflow details:

Automated SEO Content Pipeline

n8n · OpenAI · Google Sheets · WordPress · REST API · Yoast SEO · Docker · AI Image Generation · Custom WordPress Plugin

Case

Built an automated content publishing pipeline that transforms a single unpublished entry in Google Sheets into a complete WordPress article.

The workflow generates the article, SEO metadata and two AI-generated images, publishes everything to WordPress and automatically updates the Yoast SEO fields.

Results

The completed workflow can produce an article with over 2,000 words, two original AI-generated images and SEO metadata at an estimated cost of approximately $0.26 per article.

See the live result in [Lab → Tools].

Workflow

Google Sheets → n8n → OpenAI → article + images → WordPress → Yoast SEO → Google Sheets

[ View on GitHub ]

Setting Up a Self-Hosted n8n Automation Platform

n8n · Docker · Docker Compose · WSL · PowerShell · Self-Hosting

Case

Built a self-hosted n8n automation platform using Docker, creating a persistent environment for building, testing and running automation workflows.

The setup covers the deployment of n8n, persistent data storage and the basic infrastructure required to run the platform independently.

Results

A working self-hosted n8n environment with persistent workflow data, providing a foundation for building and testing automation projects.

Workflow