Generate full SEO blog posts with research and images using Gemini

Find Your AI Training Job
Chat with DigiNo Toucan and get matched to remote roles in one minute.

Niche site operators and affiliate marketers need a constant flow of original, SEO-ready content but have no bandwidth to produce it. This AI automation handles the full pipeline from topic discovery to published post, so you can deliver a hands-off content service at scale.

What This Automation Does

Scans Google Search and RSS feeds daily to surface trending, low-competition topics in a client's niche and cross-references existing posts in Supabase to prevent duplicates
Generates detailed topic briefs including target keywords, search intent, and competitor content gaps before a single word of the article is written
Writes complete, structured blog posts with proper HTML markup, a strong hook, and actionable body copy using Gemini AI, avoiding generic filler language
Saves each finished post with its custom-generated image directly to the client's Supabase database, ready for immediate publication

Tools Used

n8n
Google Gemini
Supabase
Groq

Work faster

Stop Typing and Start Speaking With Typeless

Typeless turns what you say into clean, formatted text in any app on Mac, Windows, Linux, iOS and Android, which it rates at 4x faster than typing. It strips filler words, keeps only your final phrasing when you change your mind mid-sentence, and works in 100+ languages. Emails, AI prompts, client messages and docs, done by voice.

Try Typeless →

Where to Get Hired for This Skill

On Contra, top freelancers across this stack have earned 163 combined verified reviews from real client projects.

Source: Contra freelancer search · refreshed 30 May 2026

Start Earning as a Freelancer on Contra

Contra is a commission-free professional network for independents. Browse live AI automation work and keep what you earn.

Join Contra Free →

How To Build It

Connect Supabase to the research layer

Link the client's Supabase project so the automation can read all existing blog post titles before researching new topics, ensuring every new article targets a gap rather than duplicating content already on the site.

Configure niche topic sources and RSS feeds

Point the research agent at the RSS feeds and Google Search queries relevant to the client's niche so it surfaces only trending topics with genuine search demand, not random content ideas.

Set up the Gemini research and brief agent

Wire Gemini to analyse competitor content and SERP data gathered in the previous step, then output a structured brief per topic that includes primary keywords, audience intent, and a differentiation angle the client's site can own.

Build the writing agent with SEO output rules

Configure the writing agent using the structured brief as its input and instruct it to produce full HTML-formatted articles with a compelling hook, logical section flow, and a natural tone, with Groq handling speed-sensitive generation tasks.

Route finished posts and images into Supabase

Set the final stage to push each completed article and its generated image into the correct Supabase table columns so posts land in the client's database publication-ready, with no manual copy-paste required.

Pitfalls

Gemini's output tone can drift across a 30-post batch, especially when topic briefs vary in specificity. A consistent system prompt with explicit voice rules and a few example excerpts from the client's existing content keeps outputs on-brand throughout the run.
Supabase free-tier row limits and API rate caps will silently fail if a high-volume batch hits the ceiling mid-run. Confirm the client's Supabase plan supports the expected monthly post volume before going live.
RSS feed URLs go stale or change format without warning, which breaks the topic discovery step entirely. Build in a fallback source and a basic validation check so the research agent does not proceed with an empty topic pool.

FAQ

Can I build this without coding?

Almost entirely. The workflow is low-code and the main configuration is connecting accounts and writing prompt instructions. The only exception is a small code block used for data formatting, which you can copy directly from the template without needing to write it yourself.

How long does it take?

Most freelancers get a working version running within a day or two. The bulk of the time goes into writing strong prompt instructions for the research and writing agents, not technical setup. Plan for an extra day of test runs to validate output quality before delivering to a client.

What can I charge?

Pricing is best structured as a monthly retainer tied to a fixed post volume, since the value to the client is predictable, hands-off content delivery rather than your hours. Position it around the outcome, not the tool.

Which tool is required vs optional?

Supabase and Google Gemini are both required. Supabase is the storage layer the entire output pipeline depends on, and Gemini drives the core research and writing agents. Groq is used to accelerate certain generation steps but could be swapped for another fast inference provider if needed.

This is original DigiNo analysis. The underlying automation pattern is a community workflow template – view the original on n8n.