Publish SEO-optimised WordPress blog posts with Google Gemini

See What's Earning in AI Automation Freelancing.
DigiNo helps new AI automation freelancers earn faster by tracking what clients actually pay for.

SEO content agencies need a steady stream of polished, optimised blog posts without burning hours on research and rewriting. This AI automation handles topic generation, source research, human sign-off, and WordPress publishing in one connected workflow.

What This Automation Does

Generates relevant blog topic ideas using Google Gemini, matched to an agency's service niche
Pulls recent source articles via Tavily so every post is grounded in fresh, real-world content
Pauses for a human reviewer to approve the chosen topic via Telegram before any content is written
Publishes the AI-rewritten, SEO-ready post to WordPress with a generated featured image, then logs every entry to Google Sheets

Tools Used

Google Gemini
OpenAI
WordPress
Telegram
Google Sheets
n8n

Where to Get Hired for This Skill

On Contra, top freelancers across this stack have earned 504 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

Configure the scheduled publishing trigger

Set the frequency at which the workflow fires so topic generation and publishing happen on a consistent cadence that matches the client's editorial calendar.

Connect Gemini for topic and content generation

Authenticate Google Gemini and supply a prompt that reflects the client's niche, so every topic suggestion and rewritten draft stays on-brand and targets the right search intent.

Wire Tavily to pull live source articles

Integrate Tavily so the workflow automatically retrieves recent, relevant articles for each generated topic, giving Gemini accurate source material to rewrite rather than generating from scratch.

Set up Telegram for human review and approval

Route the shortlisted topics and source articles to a Telegram message so the reviewer can pick the preferred piece before any rewriting or publishing begins, keeping editorial control in human hands.

Link WordPress and Google Sheets for publishing and audit

Authenticate WordPress so the finished post, featured image, and dynamic category are published automatically, then confirm each published entry is logged to Google Sheets as a time-stamped audit trail for the client.

Pitfalls

Gemini prompt drift: if the topic generation prompt is too broad, output topics that miss the client's niche will slip through and waste the human review step, so prompts need to be tightened and tested per client before go-live.
Tavily rate limits: high publishing frequencies can exhaust API quotas mid-run, causing the workflow to stall after topic generation with no fallback, so build in error-handling logic and monitor usage against the plan tier.
WordPress OAuth token expiry: long-running retainer setups frequently break when access tokens expire silently, and the workflow publishes nothing without surfacing a clear error, so schedule a recurring credential health check.

FAQ

Can I build this without coding?

Almost entirely. The workflow is low-code and built through a visual interface. The only area requiring light coding knowledge is adjusting the structured output parser or writing conditional logic for edge cases, both of which are well-documented inside the workflow.

How long does it take to build?

Core setup takes 15 to 30 minutes once all API credentials are ready. Factor in extra time if you need to wait for Tavily or Google API approvals, and budget another session to test the full end-to-end run before handing it to a client.

What can I charge for this service?

Pricing is yours to set based on your market and the value you deliver. A transparent Google Sheets audit trail and a fixed monthly post volume make it straightforward to package as a retainer, which clients tend to find easier to approve than one-off projects.

Which tools are required versus optional?

WordPress, Google Gemini, Tavily, Telegram, and Google Sheets are all active in the core workflow. OpenAI is an optional alternative for featured image generation and can be swapped out or removed if the client prefers to stay within the Google ecosystem.

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