Библиотека / Написание и генерация контента
Написание и генерация контента
Планирование SEO-контента по Google Trends с помощью Apify, OpenAI и Google Sheets
Каждую неделю находит растущие запросы в Google Trends по вашим темам, с помощью OpenAI читает связанные новости и записывает ранжированные идеи контента в календарь Google Sheets и email-дайджест.
Что делает
## Plan weekly content from rising Google Trends and news with Apify, OpenAI and Google Sheets Every week, find the searches that are starting to grow around your topics, read the news explaining why, and get ranked content ideas in a Google Sheets calendar and a clean email digest. Publish what people are about to look for, before your competitors do. ### Who's it for - Bloggers, YouTubers and creators planning their next pieces - SEO and content marketing teams building an editorial calendar - Agencies and small businesses that want timely, data-backed posts ### How it works 1. Runs every Monday, or anytime from a form (type a few topics, get ideas a minute later). 2. The Google Trends API Actor returns the searches rising around your topics. Google's spam-like breakouts are filtered out, and searches already covered in previous weeks are skipped. 3. The Google News Scraper Actor finds the latest articles behind each search, with their real URLs. 4. Each search gets a priority score from the data: search growth, press coverage and the topic's momentum. 5. OpenAI writes one idea per search through a structured output parser: title, format, target search, why now and a 3-point outline. 6. The ideas are added to your Google Sheets content calendar (with a Status column) and sent in a designed email, ranked by priority. ### How to set up 1. Create a free Apify account and copy your API token (Settings → API & Integrations). 2. In Get rising searches, create a *Bearer Auth* credential with the token. Select the same credential in Find the news behind each search. 3. Connect OpenAI in OpenAI Chat Model (n8n's free OpenAI credits work). 4. In Add to content calendar, connect Google Sheets and pick an empty spreadsheet: columns are created on the first run. 5. Connect Gmail in Send ideas by Gmail, edit Your settings and click *Execute workflow*. ### Requirements - An Apify account. A weekly run costs about $0.06, covered by the free plan's monthly credits. - An OpenAI account (one gpt-5-mini call per run). - Google Sheets and Gmail accounts. ### How to customize the workflow - Change the prompt in Write content ideas to match your brand voice, or swap the model for Claude, Gemini or Mistral. - Write the ideas in any language and for any country. - Send the digest to Slack, Notion or Trello instead of Gmail.
Шаги
- Every Monday at 8:00
- Get ideas now (form)
- Your settings
- Get rising searches
- Find rising searches
- Skip searches already covered
- Pick this week's searches
- Anything rising?
- Nothing new this week
- Find the news behind each search
- Score trends and build the AI brief
- Write content ideas
- OpenAI Chat Model
- Ideas format
Всего шагов: 19.
Похожие автоматизации
Веб-скрейпинг и исследованияОтслеживание локальных поисковых трендов Google Trends в SheetsШагов: 10Написание и генерация контентаАнализ трендов Reddit в Excel с помощью OpenAIШагов: 11Публикации в соцсетяхСоздание трендового контента для соцсетей с OpenAIШагов: 36Автоматизация эл. почтыTurn TikTok trends into Instagram and Facebook posts with Apify, Gemini, and PostWireШагов: 20