Topic to Full SEO Blog Article in Google Docs | Gemini AI + Google Sheets

Writing blog content takes hours. This Make scenario does it for you: add a topic to your Google Sheet, set the status to "To write", and get a fully structured, ready-to-edit article in your Google Drive within a minute. Each article includes an H1 title, a clear H2/H3 structure, an engaging introduction, natural keyword integration, a FAQ section with 4-5 common questions, and a conclusion with a call to action. The scenario also writes the final title, an SEO-friendly slug and a meta description (150 characters max) back into your sheet, along with a direct link to the Google Doc. HOW IT WORKS 1. Add a topic, language and target audience to your Google Sheet. Keywords are optional: if you leave them blank, the AI picks the most relevant ones. 2. Set the status to "To write". 3. The scenario sends your brief to Google Gemini, which writes the full article. 4. A Google Doc is created in the folder of your choice. 5. Your sheet is updated with the status, Doc link, final title, slug, meta description and date. If something goes wrong, the row is marked "Error" and the scenario moves on to the next one, so one failed row never blocks the rest. WHAT'S INCLUDED - The Make blueprint (JSON), ready to import REQUIREMENTS - A Make account (the free plan works for testing) - A Google account (Sheets, Docs, Drive) - A Google Gemini API key (free tier available at Google AI Studio) GOOGLE SHEET STRUCTURE Create a Google Sheet with these headers in row 1, in this exact order. The scenario reads and writes by column position, so the order matters more than the names. - Column A: Topic (filled by you) - Column B: Language (filled by you) - Column C: Target audience (filled by you) - Column D: Keywords (optional) (filled by you) - Column E: Status (you enter "To write", the scenario sets "Written" or "Error") - Column F: Doc URL (filled by the scenario) - Column G: Final title (filled by the scenario) - Column H: Slug (filled by the scenario) - Column I: Meta description (filled by the scenario) - Column J: Written at (filled by the scenario) SETUP (ABOUT 10 MINUTES) 1. Create your Google Sheet with the headers above. 2. Import the blueprint into Make (Create a new scenario > ... > Import Blueprint). 3. Connect your Google account in the Google Sheets and Google Docs modules, then select your sheet and Drive folder. 4. Open the "Generate article with Gemini" module and replace PASTE_YOUR_GEMINI_API_KEY_HERE with your API key. 5. Add a test row, set its status to "To write", and run the scenario once. Then schedule it. GOOD TO KNOW - Articles can be written in any language: just enter it in the Language column. - Processes up to 5 rows per run (adjustable in the first module). - The status must be exactly "To write" (case-sensitive). Adding a dropdown in column E helps avoid typos. - Avoid double quotes (") in your sheet cells, as they can break the request sent to Gemini.