Quick Overview
This workflow collects a topic, audience, and keyword in an n8n form, researches the topic with Wikipedia, writes and SEO-edits a ~500-word article using Google Gemini, then logs the result to Google Sheets and emails the finished article via Gmail.
How it works
- Receives an article request through an n8n form that captures the recipient email, topic, audience, and SEO keyword.
- Uses a Google Gemini agent with the Wikipedia tool to research the topic and return structured notes with key points, numbers, and misconceptions.
- Uses Google Gemini to draft a ~500-word article based only on the research notes for the specified audience and topic.
- Uses Google Gemini to edit and optimize the draft, naturally incorporating the provided keyword and generating an SEO title and meta description.
- Extracts the article body, title, meta description, and requester email from the editor output into separate fields.
- Appends the final article details to a Google Sheets spreadsheet and sends the completed article to the requester via Gmail.
Setup
- Add credentials for the Google Gemini (PaLM) API, Google Sheets OAuth2, and Gmail OAuth2.
- Select the target Google Sheets spreadsheet and set the sheet/tab name (for example, an “Articles” tab) in the logging step.
- Open the form URL for the trigger and use it as the entry point to submit article requests.