Get Job Alerts
One email when a teaching platform opens hiring or a new AI training project drops. No weekly filler.
Job alerts
Get Job Alerts
One email when a platform on this site starts hiring, checked by hand. No spam, leave any time.
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
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.
Get Job Alerts
One email when a teaching platform opens hiring or a new AI training project drops. No weekly filler.
Job alerts
Get Job Alerts
One email when a platform on this site starts hiring, checked by hand. No spam, leave any time.
Generate AI video ads from product images with Google Veo 3