Automate Google Trends Daily: Apify + Sheets + Slack (n8n)

Automate your daily Google Trends watch with Apify, Google Sheets, and Slack—no duplicates

This n8n workflow runs the Apify Google Trends Scraper once a day, saves every newly spiking trend to Google Sheets, and sends a top 10 digest to Slack—so you always know what’s trending without repeating the same items.

What this workflow does

• Runs daily at 9am using an n8n Schedule Trigger.
• The Apify node executes the orbots/google-trends-scraper Actor in trending mode (“Run actor”).
• The workflow waits for the Apify run to finish, then retrieves the dataset items.
• Prevents duplicates between runs by setting onlyNew = true, so the Actor returns trends it has never delivered before (and you don’t append the same trend twice).
• Appends each new trend to Google Sheets as a row including: term, estimated search volume bucket, growth, category, active/ended status, started/ended timestamps, duration, and a Google Trends link.
• A Code node sorts newly found trends by estimated volume and builds a top 10 digest.
• Posts one Slack message per day with the digest. If there are no new trends, it appends nothing, sends nothing, and costs nothing.

Use cases

• Monitor emerging search interests for content planning and SEO opportunities.
• Give your team a daily “what’s spiking” update in Slack.
• Track trending topics over time with a clean Google Sheets log.
• Operationalize trend research for SaaS/product decisions using scheduled automation.

Technical details

• Schedule Trigger: daily at 9am
• Apify integration: @apify/n8n-nodes-apify using Apify API token or OAuth2
• Google Sheets: Append trends to the selected spreadsheet and sheet
• Code node: sort by estimated volume + build top 10 digest
• Slack: Send digest to a specified channel