Kütüphane / İçerik Yazımı ve Üretimi
İçerik Yazımı ve Üretimi
Apify, OpenAI ve Google Sheets ile Google Trends'ten SEO içerik planla
Her hafta konularınızla ilgili yükselen Google Trends aramalarını bulur, ilgili haberleri OpenAI ile okur ve sıralanmış içerik fikirlerini bir Sheets takvimine ve e-posta özetine yazar.
Ne yapar
## 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.
Adımlar
- 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
Toplam 19 adım.
Benzer otomasyonlar
Web Kazıma ve AraştırmaGoogle Trends'ten Yerel Arama Trendlerini Sheets'e Aktar10 adımİçerik Yazımı ve ÜretimiOpenAI ile Reddit Sosyal Trendlerini Excel'e Analiz Et11 adımSosyal Medya YayıncılığıOpenAI ile Trend Odaklı Sosyal Medya İçeriği Oluşturma36 adımE-posta OtomasyonuTurn TikTok trends into Instagram and Facebook posts with Apify, Gemini, and PostWire20 adım