← Daily AI recipesBusiness✓ Verified Aug 3, 2026

Prepare SEO content for 7 articles ahead with a single prompt in Gemini

In one evening: gather keywords → get meta tags, titles, and structure for a week of publications

  1. 1.Open Google Gemini in your browser and sign in with any Google account. If the service is unavailable in your region - enable a VPN.

    The free plan does not require a credit card. Do not paste trade secrets or personal data into the chat - Gemini may use texts for training.

    Google Gemini ↗About this tool
  2. 2.Open Google Search Console → «Search results». Sort queries by impressions, then pick 5-7 phrases with high impressions but low CTR (below 2%) - this is your best chance for growth.

    No Search Console? Take phrases from the free «Related searches» section in Google Search or from search bar autocomplete.

    Google Search Console ↗
  3. 3.Return to Gemini and paste the prompt below. Replace [YOUR_KEYWORDS] with the list of phrases from step 2 - one per line. Replace [YOUR_NICHE] with your site's topic, e.g. «fitness blog» or «electronics store».

    The prompt is in English - Gemini follows English instructions more accurately, but generates content in Russian via the Language parameter.

    Google Gemini ↗About this tool
    Prompt
    Act as a senior SEO strategist. For each target keyword below, produce a complete content brief.

Niche: [YOUR_NICHE]
Language: Russian

For EVERY keyword output this block:
---
Keyword: <keyword>
1. SEO Title (max 60 characters)
2. Meta Description (max 155 characters, include a call to action)
3. H1
4. 5-7 H2 sections (logical article structure)
5. 3 long-tail variations to include naturally
6. 3 FAQ questions with short answers (for featured snippets)
7. Internal linking suggestions (which existing topics to link to)
---

Keywords:
[YOUR_KEYWORDS]
    What this prompt doesThe prompt asks Gemini to generate a complete SEO brief for each keyword: title, meta description, article structure, related queries, and an FAQ block. Replace [YOUR_KEYWORDS] with your list of phrases (one per line) and [YOUR_NICHE] - with your site's topic.
  4. 4.Copy the result into Google Sheets. Create columns: Keyword | SEO Title | Meta Description | Status. Set the status to «Ready to write» for all rows.

    In Sheets press Ctrl+Shift+V to paste without formatting - text will fall neatly into cells.

    Google Sheets ↗
  5. 5.To expand any article into a full draft, open a new Gemini chat and paste the prompt below. Replace [H1] with the article title, [H2_SECTIONS] - with the list of sections from step 3, [WORD_COUNT] - with the desired length, e.g. 1500.

    Generate one article at a time - this way Gemini does not cut off the response. If the text breaks off, type «Continue» in the same chat.

    Google Gemini ↗About this tool
    Prompt
    Write a complete article in Russian based on this brief.

H1: [H1]
Sections to cover:
[H2_SECTIONS]

Length: [WORD_COUNT] words.
Style: actionable, concrete examples, no fluff.
Include a key takeaway at the end of each section.
Add an FAQ section at the bottom.
Format: Markdown.
    What this prompt doesAsks Gemini to write a complete article based on the prepared brief. Replace [H1] with the title, [H2_SECTIONS] - with the list of sections (copy from step 3 result), [WORD_COUNT] - with the desired word count.
💰 What it costs to followprices as of 2026-08
  • freeGoogle Gemini (free tier)Unlimited messages per day, no credit card required. There is a rate limit for a short period of time - if you hit it, wait a couple of minutes.
  • freeGoogle Search ConsoleCompletely free for site owners. Requires verified domain ownership.
  • freeGoogle SheetsFree with any Google account. Total storage limit - 15 GB across all Google services.
Try it and be the first to check in

AI services change fast - interfaces and free limits may differ from what's described.