Bibliothek / Texterstellung & Content-Generierung
Texterstellung & Content-Generierung
SEO-Content mit Google Trends, Apify, OpenAI und Google Sheets planen
Findet wöchentlich steigende Google-Trends-Suchen zu deinen Themen, liest verwandte Nachrichten mit OpenAI und schreibt priorisierte Content-Ideen in einen Sheets-Kalender und eine E-Mail-Zusammenfassung.
Was sie bewirkt
## 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.
Die Schritte
- 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
Insgesamt 19 Schritte.
Ähnliche Automatisierungen
Web Scraping & RechercheLokale Suchtrends aus Google Trends in Sheets erfassen10 SchritteTexterstellung & Content-GenerierungReddit-Trends mit OpenAI analysieren und in Excel speichern11 SchritteSocial-Media-VeröffentlichungTrendbasierte Social-Media-Inhalte mit OpenAI erstellen36 SchritteE-Mail-AutomatisierungTurn TikTok trends into Instagram and Facebook posts with Apify, Gemini, and PostWire20 Schritte