Quick Overview
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. An n8n automation workflow template by Oka Hironobu.
Oka Hironobu
web
free
Others in the same category, ranked by how often they are opened.
