This n8n template shows how anyone can build a simple newsletter-like subscription service where users can enroll themselves to receive messages/content on a regular basis.

It uses n8n forms for data capture, Airtable for the database, AI for content generation, and Gmail for email sending.

How it works
An n8n form is set up to allow users to subscribe with a desired topic and interval of which to receive messages. This information is then added to the Airtable.

A scheduled trigger is executed every morning and searches for subscribers to send messages based on their desired intervals.

Once found, subscribers are sent to a subworkflow which performs the text content generation via an AI agent and also uses a vision model to generate an image.

Both the text and image are attached to an email that is sent to the subscriber. This email also includes an unsubscribe link.

The unsubscribe flow works similarly via the n8n form interface, which when submitted, disables further scheduled emails to the user.

How to use
Make a copy of the sample Airtable.

Make sure the workflow is “activated” and the forms are available and reachable by your audience.

Requirements
– Airtable for Database
– OpenAI for LLM (but compatible with others)
– Gmail for Email (but can be replaced with others)Customizing this workflow
This simple use case can be extended to deliver any types of content such as your company newsletter, promotions, social media posts, etc.

It doesn’t have to be limited to just email—try social messaging, WhatsApp, Telegram, and others.