AI content creation and auto WordPress publishing with Pexels API image workflow
VerifiedAutomates AI content generation and WordPress publishing from Google Sheets triggers.
What this workflow does
This n8n workflow uses Google Sheets as a content queue, an AI Agent powered by Google Gemini to produce full articles and search terms, and HTTP Request actions to handle external API calls for images and WordPress publishing.
It is designed for bloggers and content teams who want to streamline idea tracking, AI-assisted writing, and direct site updates without manual intervention at each step.
Who is this for?
Bloggers, content marketers, and small marketing teams who regularly publish to WordPress and want to reduce manual writing and image sourcing.
What problem it solves
Creating, illustrating, and publishing blog posts is time-consuming; teams must repeatedly generate ideas, write articles, find images, and update status trackers.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
Weekly niche blog publishing
Pulls an unprocessed topic from Google Sheets, generates a full article with Gemini, sources a Pexels image, and publishes it as a new WordPress post with featured image.
Idea generation when stuck
User submits a broad theme via form; AI Agent creates multiple new topic ideas, Structured Output Parser formats them as JSON, and rows are added to the Google Sheet for later use.
Batch content pipeline
Runs through multiple 'not generated' rows in the sheet, updates each with post ID and date after WordPress publishing, keeping the tracker accurate without manual entry.
How the workflow works
The 6 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
- 3Wordpresswordpress
- 4AI Agent@n8n/n8n-nodes-langchain.agent
- 5Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
- 6Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Apps & integrations used
How to set up AI content creation and auto WordPress publishing with Pexels API image workflow
- 1Import the workflow JSON into n8n and connect your Google Sheets credentials.
- 2Add your WordPress site URL, username, and application password to the Wordpress node.
- 3Store a Pexels API key in the HTTP Request node used for image search and download.
- 4Connect the Google Gemini Chat Model node with your API key.
- 5Activate the Form Trigger and test both the 'generate content' and 'add ideas' paths.
- 6Map the Google Sheets columns for prompt, Generated status, post ID, and date fields.
How to customize this workflow
- →Swap Google Gemini for any other supported chat model in the AI Agent node.
- →Replace the Form Trigger with a Schedule Trigger for fully hands-off daily runs.
- →Add an approval step before the Wordpress node to review AI output.
- →Extend the sheet with extra columns and update the Set prompt node to include them.
AI content creation and auto WordPress publishing with Pexels API image workflow: pros & cons
Pros
- +End-to-end automation from idea to published post
- +Central Google Sheets hub keeps ideas and status visible
- +Pexels integration adds relevant featured images automatically
- +Structured Output Parser keeps topic lists clean and usable
Cons
- –Requires valid API keys for Gemini, Pexels, and WordPress
- –AI output still benefits from human review for brand voice
- –Pexels image selection is keyword-based and may need occasional swaps
Frequently asked questions
It fetches content ideas from Google Sheets, uses Google Gemini to write articles and keywords, downloads matching images via Pexels, and publishes everything to WordPress while updating the sheet.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.