Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Content Writing & Generation

Content Writing & Generation

Plan SEO content from Google Trends with Apify, OpenAI and Google Sheets

Every week, finds rising Google Trends searches around your topics, reads related news with OpenAI, and writes ranked content ideas to a Sheets calendar and an email digest.

What it does

## 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.

The steps

  1. Every Monday at 8:00
  2. Get ideas now (form)
  3. Your settings
  4. Get rising searches
  5. Find rising searches
  6. Skip searches already covered
  7. Pick this week's searches
  8. Anything rising?
  9. Nothing new this week
  10. Find the news behind each search
  11. Score trends and build the AI brief
  12. Write content ideas
  13. OpenAI Chat Model
  14. Ideas format

19 steps in total.

Similar automations