January 22, 2026

Slack + Google Sheets, trend reports sent daily

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You know the drill. Someone spots a trend on Twitter, another person saves a Reddit thread, and the “final” notes end up scattered across bookmarks, DMs, and half-finished spreadsheets.

This is where Slack Sheets trends automation pays off fast. Marketing managers feel it when the content calendar goes stale. Agency leads feel it when clients ask, “Why didn’t we jump on this?” And founders doing their own marketing, honestly, have no time to play detective.

This workflow pulls fresh trend signals daily, turns them into usable content insights, posts the report to Slack, and logs the same ideas into Google Sheets so your calendar stays current.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Slack + Google Sheets, trend reports sent daily

Click to explore

flowchart LR

    subgraph sg0["Scheduled Trend Pulse Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Scheduled Trend Pulse", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Trend Setup Builder"]
        n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Batch Query Splitter", pos: "b", h: 48 }
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Query Assembly Logic"]
        n4@{ icon: "mdi:cog", form: "rounded", label: "Social Trend Scraper AI", pos: "b", h: 48 }
        n5@{ icon: "mdi:cog", form: "rounded", label: "Google Trends Scraper AI", pos: "b", h: 48 }
        n6@{ icon: "mdi:cog", form: "rounded", label: "Viral Content Analyzer AI", pos: "b", h: 48 }
        n7@{ icon: "mdi:cog", form: "rounded", label: "Reddit Insights Scraper AI", pos: "b", h: 48 }
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Combine Trend Outputs"]
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Trend Insight Engine"]
        n10@{ icon: "mdi:database", form: "rounded", label: "Content Calendar Writer", pos: "b", h: 48 }
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Team Alert Dispatcher"]
        n3 --> n4
        n3 --> n5
        n3 --> n6
        n3 --> n7
        n8 --> n9
        n2 --> n3
        n4 --> n8
        n5 --> n8
        n9 --> n10
        n9 --> n11
        n0 --> n1
        n1 --> n2
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n10 database
    class n1,n3,n9 code
    classDef customIcon fill:none,stroke:none
    class n1,n3,n8,n9,n11 customIcon

The Problem: Trend Research Becomes “Extra Work”

Trend research is supposed to be a quick input to your content plan. In practice, it turns into a daily scavenger hunt across platforms, then another round of “someone please put this in the sheet.” Even when you do capture ideas, they’re inconsistent: no context, no why-now, no suggested angle, no priority. A week later you can’t tell what’s worth posting, and you end up defaulting back to safe, generic content because it’s easier than sorting the mess.

It adds up fast. Here’s where it breaks down.

You lose about an hour a day collecting links, screenshots, and notes across multiple platforms.
Good ideas don’t make it into the content calendar, so they never get assigned, written, or published.
The team sees trends too late, which means you post after the conversation has already moved on.
Manual copy-paste creates errors and missing context, so people stop trusting the “trend doc.”

The Solution: Daily Trend Intelligence, Delivered Where You Work

This n8n workflow runs on a daily schedule and monitors trending topics across multiple sources. It builds a set of search queries for your target industries, then uses AI-powered scraping to pull trend signals from social platforms and search interest data. Next, it combines those sources into a single dataset and generates a cleaned, actionable report: what’s trending, what’s driving engagement, and what content angles are likely to work right now. Finally, it sends that report to Slack for the team to act on, and writes the same items into Google Sheets so your content calendar (or idea backlog) stays up to date without anyone doing admin work.

The workflow starts with a daily trigger in n8n. From there, it batches your queries and runs several scrapers in parallel (social trends, Google Trends, viral content patterns, and Reddit insights). Once everything is merged, a final insight engine formats the recommendations and pushes them to Slack and Google Sheets.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Runs every 24 hours and refreshes your trend inputs automatically.
Scrapes multiple sources with AI so you are not manually hunting for signals.
Merges trend outputs and turns raw links into organized, readable insights.
Posts the report to Slack and logs the same items into Google Sheets.

About an hour back per day for whoever “owns” trend research.
Faster publishing because ideas show up already shaped into angles and hooks.
A content calendar that stays current, even when the team is busy.
Fewer missed opportunities since Slack makes trends hard to ignore.
More consistent strategy discussions because everyone sees the same report.

Example: What This Looks Like

Say you review trends across LinkedIn, Twitter, Instagram, Google Trends, BuzzSumo, and Reddit. If you spend roughly 10 minutes per platform collecting examples and another 30 minutes turning that into a “shareable” summary, you are at about 90 minutes a day. With this workflow, the daily trigger runs automatically, the scraping and analysis happens in the background, and you get a finished report in Slack plus a row set in Google Sheets. Your time drops to a quick 10-minute review and decision.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Slack for delivering the daily report to your team
Google Sheets to log trends into a calendar or backlog
ScrapeGraphAI API key (get it from your ScrapeGraphAI dashboard)

Skill level: Intermediate. You’ll connect accounts, add an API key, and adjust a few configuration fields for your industry and keywords.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

Daily schedule trigger. The workflow starts automatically every 24 hours, so you’re not relying on someone to “remember” to do trend research.

Query setup and batching. A setup step builds the topics and industries you care about, then splits them into manageable batches so the scrapers can run reliably even as you add more queries.

Multi-source scraping and analysis. ScrapeGraphAI nodes pull trend and viral content signals (including Google Trends and Reddit). A combine step merges the outputs, then an insight engine turns it into content opportunities and platform-specific notes your team can actually use.

Slack + Google Sheets output. The final report is sent to Slack for visibility and written into Google Sheets for tracking, planning, and later review.

You can easily modify the target industries and keywords to match your niche, then change the report format to fit your team’s planning style. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

Set the workflow to run on a daily cadence so the trend intelligence pipeline refreshes automatically.

Add the Scheduled Trend Pulse node and open its settings.
Set Rule to an hourly interval with hoursInterval set to 24.
Connect Scheduled Trend Pulse to Trend Setup Builder.

Step 2: Build Trend Configuration and Batch Execution

Prepare the trend configuration and split queries into manageable batches for processing.

Open Trend Setup Builder and confirm the JavaScript Code contains your industry lists, platforms, and content calendar settings.
Keep the generated date and session values as defined in the code for consistent reporting, including the date: '2025-07-25' field.
Connect Trend Setup Builder to Batch Query Splitter to enable batched processing.
Leave Batch Query Splitter settings as default unless you need to control batch size in advanced scenarios.

If you change industries or platforms in Trend Setup Builder, the total query count will shift. Verify totalQueries output during testing.

Step 3: Set Up Query Assembly and Parallel AI Scrapers

Assemble the current query and scrape trend data from multiple sources simultaneously.

In Query Assembly Logic, confirm the batch index is pulled from $('Batch Query Splitter').item.json and the current query is selected from the combined arrays.
Verify that Query Assembly Logic outputs currentQuery, batchIndex, and totalBatches.
Connect Query Assembly Logic to Social Trend Scraper AI, Google Trends Scraper AI, Viral Content Analyzer AI, and Reddit Insights Scraper AI.
Set Social Trend Scraper AI Website URL to {{ $json.currentQuery.search_url }}.
Keep Google Trends Scraper AI Website URL as https://trends.google.com/trends/explore?date=now%207-d&geo=US.
Keep Viral Content Analyzer AI Website URL as https://buzzsumo.com/trending-now.
Set Reddit Insights Scraper AI Website URL to {{ 'https://www.reddit.com/r/' + $json.currentQuery.industry.replace(/\s+/g, '') + '/hot/' }}.

Query Assembly Logic outputs to Social Trend Scraper AI, Google Trends Scraper AI, Viral Content Analyzer AI, and Reddit Insights Scraper AI in parallel.

Credential Required: Connect your ScrapeGraphAI credentials in Social Trend Scraper AI, Google Trends Scraper AI, Viral Content Analyzer AI, and Reddit Insights Scraper AI before running.

Step 4: Combine and Analyze Trend Data

Merge the AI scraping outputs and generate the unified trend intelligence report.

Set Combine Trend Outputs to Mode combine.
Connect Social Trend Scraper AI and Google Trends Scraper AI into Combine Trend Outputs to align multi-source data.
Connect Combine Trend Outputs to Trend Insight Engine.
Review Trend Insight Engine to confirm it merges trending_topics, calculates trend_health_score, and builds recommended_actions.

If the output array order changes, the destructuring in Trend Insight Engine may map the wrong dataset. Keep connections consistent with the current wiring.

Step 5: Configure Output and Team Notifications

Write trend-driven content ideas to Google Sheets and alert the team in Slack.

In Content Calendar Writer, set Operation to append.
Set Document ID to your sheet URL: [YOUR_ID] and Sheet Name to Content_Calendar_2025.
Confirm column mappings use the provided expressions, such as Date {{ new Date().toISOString().split('T')[0] }} and Session_ID {{ $('Trend Insight Engine').item.json.session_id }}.
In Team Alert Dispatcher, set Channel to [YOUR_ID].
Keep the Slack Text message as the expression block that references {{ $('Trend Insight Engine').item.json.trend_health_score }} and other summary fields.
Connect Trend Insight Engine to both Content Calendar Writer and Team Alert Dispatcher.

Trend Insight Engine outputs to both Content Calendar Writer and Team Alert Dispatcher in parallel.

Credential Required: Connect your Google Sheets credentials in Content Calendar Writer and your Slack credentials in Team Alert Dispatcher.

Step 6: Test and Activate Your Workflow

Validate the workflow end-to-end and switch it on for daily trend monitoring.

Click Execute Workflow to run a manual test from Scheduled Trend Pulse.
Verify that Content Calendar Writer appends a new row to Content_Calendar_2025 and includes Session_ID and Trend_Score values.
Check Slack to confirm Team Alert Dispatcher posts the formatted trend report message.
Fix any errors in the scrape or write steps, then re-run until the execution completes without failures.
Toggle the workflow to Active to enable daily automated runs.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Slack credentials can expire or need specific permissions. If things break, check the n8n Slack credential and your Slack app/workspace access first.
If you’re using Wait nodes or external scraping, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
ScrapeGraphAI prompts and defaults can be a little generic. Add your brand voice and “what to prioritize” rules early or you will be editing outputs every morning.

Frequently Asked Questions

How long does it take to set up this Slack Sheets trends automation?

About 15 minutes if your accounts and API key are ready.

Do I need coding skills to automate Slack trend reports to Google Sheets?

No coding is required for the core setup. You will mostly connect accounts, paste an API key, and tweak a few configuration fields.

Is n8n free to use for this Slack Sheets trends workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in ScrapeGraphAI API usage costs based on how many queries you run daily.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. This specific workflow uses community nodes, so self-hosting is typically the safer choice for compatibility. If you go that route, plan for basic server upkeep like updates and backups.

Can I customize this Slack Sheets trends automation workflow for my industry?

Yes, and you should. Most teams customize the “Trend Setup Builder” and “Query Assembly Logic” steps to define industries, keywords, and platforms, then adjust the “Trend Insight Engine” rules so the report outputs the fields you care about (hooks, angles, titles, or priority scores). You can also reduce sources if you want a lighter report, or add more queries if you’re running multiple brands. If you already keep an editorial calendar format in Google Sheets, map the output fields to your existing columns so the workflow fits your process instead of replacing it.

Why is my Slack connection failing in this workflow?

Usually it’s expired credentials or missing permission scopes in your Slack connection inside n8n. Reconnect Slack in n8n, confirm the workflow is posting to the right channel, and double-check that your Slack workspace allows the app to post messages. If it works once and then stops, rate limits can also show up when you expand to lots of queries.

How many trend queries can this Slack Sheets trends automation handle?

If you self-host, there’s no hard execution limit, but your server and your scraping API limits become the real bottleneck.

Is this Slack Sheets trends automation better than using Zapier or Make?

For multi-source trend scraping and “merge + analyze + write” logic, n8n is usually a better fit than Zapier or Make because you can branch, batch, and transform data without paying for every little step. The batching and merging matter here because you’re pulling multiple sources and combining them into one report. Also, this workflow uses community nodes, which Zapier and Make won’t support in the same way. If you only want a simple “Google Trends result to Slack message,” those tools can be fine, but you’ll hit ceilings quickly once you want scoring, prioritization, and structured Sheets logging. If you’re on the fence, Talk to an automation expert and describe your volume and channels.

Once this is running, your trend research stops being a daily scramble and starts showing up like a utility. The workflow handles the repetitive collection and formatting so you can spend your time choosing angles and publishing.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "7328dab9dc5f693edf880ce85fc95c6d0c938a0b557ceecf57d15ff0577fbc87"
},
"name": "Automated Trend Intelligence Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-6441",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
30
],
"parameters": {
"color": 7,
"width": 1310,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "4c951211-1654-49c3-9310-42a7fd25a188",
"name": "Scheduled Trend Pulse",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "",
"position": [
1210,
130
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 24
}
]
}
},
"typeVersion": 1.2
},
{
"id": "c067b4e9-677e-4bac-8e9c-9d4f2a64b337",
"name": "Trend Setup Builder",
"type": "n8n-nodes-base.code",
"position": [
910,
165
],
"parameters": {
"jsCode": "// Content Strategy Configuration & Trend Monitoring Setup\n\nconst contentConfig = {\n  industries: [\n    'artificial intelligence',\n    'digital marketing',\n    'technology trends',\n    'social media marketing',\n    'content marketing',\n    'SEO and search marketing',\n    'e-commerce trends',\n    'startup ecosystem',\n    'remote work trends',\n    'cybersecurity'\n  ],\n  contentTypes: [\n    'blog posts',\n    'social media content',\n    'video scripts',\n    'infographics',\n    'podcasts',\n    'webinars',\n    'case studies',\n    'whitepapers',\n    'newsletters',\n    'tutorials'\n  ],\n  platforms: {\n    'LinkedIn': 'professional audience, B2B content',\n    'Twitter': 'real-time updates, industry news',\n    'Instagram': 'visual content, behind-the-scenes',\n    'YouTube': 'educational content, tutorials',\n    'TikTok': 'trending topics, quick tips',\n    'Facebook': 'community engagement, discussions',\n    'Pinterest': 'visual inspiration, how-to guides',\n    'Reddit': 'community discussions, AMAs'\n  },\n  contentCalendar: {\n    posting_frequency: {\n      'blog': '3 times per week',\n      'social': 'daily',\n      'video': 'twice per week',\n      'newsletter': 'weekly'\n    },\n    content_pillars: [\n      'Industry Insights & Trends',\n      'Educational & How-To Content',\n      'Company News & Updates',\n      'User-Generated Content',\n      'Behind-the-Scenes',\n      'Thought Leadership'\n    ],\n    seasonal_events: [\n      'Q4 2025 Planning',\n      'Back-to-School Season',\n      'Holiday Marketing',\n      'New Year Resolutions',\n      'Industry Conference Season'\n    ]\n  },\n  trendAnalysis: {\n    timeframes: ['24h', '7d', '30d'],\n    engagement_thresholds: {\n      'viral': 100000,\n      'trending': 10000,\n      'emerging': 1000\n    },\n    sentiment_analysis: true,\n    competitor_monitoring: true,\n    influencer_tracking: true\n  }\n};\n\nconst today = new Date('2025-07-25');\nconst trendQueries = [];\n\nObject.keys(contentConfig.platforms).forEach(platform => {\n  contentConfig.industries.forEach(industry => {\n    trendQueries.push({\n      platform: platform,\n      industry: industry,\n      query: `${industry} trends ${platform.toLowerCase()} 2025`,\n      search_url: generateSearchURL(platform, industry),\n      content_focus: contentConfig.platforms[platform]\n    });\n  });\n});\n\nconst keywordQueries = contentConfig.industries.map(industry => ({\n  industry: industry,\n  query: `${industry} keywords trending july 2025`,\n  search_url: `https://trends.google.com/trends/explore?q=${encodeURIComponent(industry)}&date=now%207-d`,\n  analysis_type: 'keyword_volume'\n}));\n\nconst competitorQueries = [\n  'top content marketing campaigns 2025',\n  'viral marketing strategies july 2025',\n  'best performing content types 2025',\n  'social media engagement trends 2025'\n].map(query => ({\n  query: query,\n  search_url: `https://www.buzzsumo.com/search?q=${encodeURIComponent(query)}`,\n  analysis_type: 'competitor_content'\n}));\n\nfunction generateSearchURL(platform, industry) {\n  const baseUrls = {\n    'LinkedIn': `https://www.linkedin.com/search/results/content/?keywords=${encodeURIComponent(industry + ' trends')}`,\n    'Twitter': `https://twitter.com/search?q=${encodeURIComponent(industry + ' trends')}&src=trend_click`,\n    'Instagram': `https://www.instagram.com/explore/tags/${encodeURIComponent(industry.replace(/\\s+/g, ''))}/`,\n    'YouTube': `https://www.youtube.com/results?search_query=${encodeURIComponent(industry + ' trends 2025')}`,\n    'TikTok': `https://www.tiktok.com/search?q=${encodeURIComponent(industry)}`,\n    'Reddit': `https://www.reddit.com/search/?q=${encodeURIComponent(industry + ' trends')}&type=link&sort=hot`\n  };\n  return baseUrls[platform] || `https://www.google.com/search?q=${encodeURIComponent(industry + ' ' + platform + ' trends')}`;\n}\n\nconst sessionId = `trend_monitoring_${Date.now()}`;\nconst timestamp = today.toISOString();\n\nreturn [{\n  json: {\n    sessionId: sessionId,\n    timestamp: timestamp,\n    date: '2025-07-25',\n    config: contentConfig,\n    trendQueries: trendQueries,\n    keywordQueries: keywordQueries,\n    competitorQueries: competitorQueries,\n    totalQueries: trendQueries.length + keywordQueries.length + competitorQueries.length,\n    analysisMode: 'comprehensive'\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "7c882512-5033-4696-8d75-5cb30af4ebea",
"name": "Batch Query Splitter",
"type": "n8n-nodes-base.splitInBatches",
"position": [
620,
185
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "7a1ba928-b4b8-43e3-94b8-312448147e96",
"name": "Query Assembly Logic",
"type": "n8n-nodes-base.code",
"position": [
340,
215
],
"parameters": {
"jsCode": "const items = $input.all();\nconst configData = items[0].json;\nconst batchData = $('Batch Query Splitter').item.json;\n\nconst allQueries = [\n  ...configData.trendQueries,\n  ...configData.keywordQueries,\n  ...configData.competitorQueries\n];\n\nconst currentQuery = allQueries[batchData.index];\n\nreturn [{\n  json: {\n    ...configData,\n    currentQuery: currentQuery,\n    batchIndex: batchData.index,\n    totalBatches: allQueries.length,\n    queryType: currentQuery.analysis_type || 'trend_analysis'\n  }\n}];"
},
"typeVersion": 2
},
{
"id": "c1463a9f-6787-4229-9da2-7c62d2e60880",
"name": "Social Trend Scraper AI",
"type": "n8n-nodes-scrapegraphai.scrapegraphAi",
"position": [
240,
345
],
"parameters": {
"userPrompt": "Analyze current trends and viral content on this platform. Extract trending topics, hashtags, engagement metrics, and content patterns. Provide structured data with: { \"platform\": \"platform_name\", \"trending_topics\": [{ \"topic\": \"AI automation\", \"engagement_score\": 85000, \"trend_velocity\": \"rising\", \"hashtags\": [\"#AI\", \"#automation\"], \"key_influencers\": [\"@techexpert\"], \"content_examples\": [\"example post text\"], \"sentiment\": \"positive\", \"demographics\": \"25-40 professionals\" }], \"viral_content\": [{ \"content_type\": \"video\", \"title\": \"content title\", \"engagement\": 250000, \"shares\": 5000, \"comments_sentiment\": \"positive\", \"key_themes\": [\"innovation\", \"productivity\"] }], \"emerging_trends\": [\"trend description\"], \"content_opportunities\": [\"suggested content ideas\"] }",
"websiteUrl": "={{ $json.currentQuery.search_url }}"
},
"typeVersion": 1
},
{
"id": "214cc4e8-01db-40b0-ae41-65bd2c5a5eba",
"name": "Google Trends Scraper AI",
"type": "n8n-nodes-scrapegraphai.scrapegraphAi",
"position": [
0,
470
],
"parameters": {
"userPrompt": "Extract Google Trends data for content planning. Focus on rising search terms, related queries, and seasonal patterns. Use this schema: { \"trending_searches\": [{ \"keyword\": \"search term\", \"search_volume\": \"100k\", \"growth_rate\": \"+150%\", \"geographic_data\": \"US, UK, CA\", \"related_topics\": [\"related topic\"], \"seasonality\": \"summer peak\", \"competition_level\": \"medium\", \"content_opportunity_score\": 85 }], \"breakout_terms\": [{ \"term\": \"breakout keyword\", \"category\": \"technology\", \"growth\": \"breakout\", \"context\": \"why it's trending\" }], \"related_queries\": [\"what is X\", \"how to X\", \"best X 2025\"], \"geographic_insights\": { \"top_regions\": [\"California\", \"New York\"], \"emerging_markets\": [\"Texas\", \"Florida\"] }, \"content_suggestions\": [\"blog post ideas based on trends\"] }",
"websiteUrl": "https://trends.google.com/trends/explore?date=now%207-d&geo=US"
},
"typeVersion": 1
},
{
"id": "263483cf-4232-4872-84ab-3b2ca5f4fddc",
"name": "Viral Content Analyzer AI",
"type": "n8n-nodes-scrapegraphai.scrapegraphAi",
"position": [
280,
545
],
"parameters": {
"userPrompt": "Analyze trending content and viral posts across social platforms for content inspiration. Extract high-performing content patterns, engagement strategies, and viral elements. Schema: { \"viral_content\": [{ \"title\": \"content title\", \"platform\": \"LinkedIn\", \"engagement_rate\": \"8.5%\", \"shares\": 15000, \"content_format\": \"video/image/text\", \"topic_category\": \"marketing\", \"key_elements\": [\"storytelling\", \"data visualization\"], \"posting_time\": \"Tuesday 2PM\", \"author_profile\": \"industry expert\", \"viral_factors\": [\"trending hashtag\", \"timely topic\"] }], \"content_patterns\": [{ \"pattern\": \"question-based headlines\", \"success_rate\": \"high\", \"best_platforms\": [\"LinkedIn\", \"Twitter\"] }], \"hashtag_performance\": [{ \"hashtag\": \"#ContentMarketing\", \"usage_growth\": \"+25%\", \"engagement_rate\": \"6.2%\" }], \"optimal_posting_times\": { \"LinkedIn\": \"Tuesday-Thursday 8-10AM\", \"Twitter\": \"Daily 12-3PM\" } }",
"websiteUrl": "https://buzzsumo.com/trending-now"
},
"typeVersion": 1
},
{
"id": "0417ea97-40bd-4ee7-bf8a-1abcfe93f259",
"name": "Reddit Insights Scraper AI",
"type": "n8n-nodes-scrapegraphai.scrapegraphAi",
"position": [
90,
615
],
"parameters": {
"userPrompt": "Analyze Reddit discussions to identify emerging topics, pain points, and content opportunities. Focus on highly upvoted posts and engaged discussions. Schema: { \"hot_discussions\": [{ \"title\": \"discussion title\", \"upvotes\": 1200, \"comments\": 89, \"discussion_theme\": \"problem solving\", \"key_pain_points\": [\"specific user problems\"], \"solution_opportunities\": [\"content ideas to address problems\"], \"audience_sentiment\": \"frustrated/excited/curious\", \"emerging_questions\": [\"questions users are asking\"] }], \"community_insights\": { \"active_topics\": [\"trending discussion topics\"], \"user_demographics\": \"target audience insights\", \"content_gaps\": [\"missing information users need\"] }, \"content_opportunities\": [{ \"content_type\": \"tutorial\", \"topic\": \"solving common problem\", \"potential_engagement\": \"high\", \"target_keywords\": [\"how to\", \"best practices\"] }] }",
"websiteUrl": "={{ 'https://www.reddit.com/r/' + $json.currentQuery.industry.replace(/\\s+/g, '') + '/hot/' }}"
},
"typeVersion": 1
},
{
"id": "c25253b7-c6ff-4daf-bebc-b0e540c24741",
"name": "Combine Trend Outputs",
"type": "n8n-nodes-base.merge",
"position": [
540,
500
],
"parameters": {
"mode": "combine",
"options": [],
"mergeByFields": {
"values": [
[]
]
}
},
"typeVersion": 2.1
},
{
"id": "ff06ad98-48d4-4451-852f-16ee9d54704e",
"name": "Trend Insight Engine",
"type": "n8n-nodes-base.code",
"position": [
820,
485
],
"parameters": {
"jsCode": "const allData = $input.all();\nconst configData = allData[0].json;\nconst socialData = allData[1]?.json?.result || {};\nconst trendsData = allData[2]?.json?.result || {};\nconst viralData = allData[3]?.json?.result || {};\nconst redditData = allData[4]?.json?.result || {};\n\nconst trendAnalyzer = {\n  calculateTrendMomentum(engagementScore, growthRate, timeframe) {\n    const engagement = parseInt(engagementScore) || 0;\n    const growth = parseFloat(growthRate?.replace(/[^0-9.-]/g, '')) || 0;\n    const timeMultiplier = timeframe === '24h' ? 3 : timeframe === '7d' ? 2 : 1;\n    return Math.min(100, (engagement / 1000 + growth + timeMultiplier * 10));\n  },\n  \n  identifyContentGaps(socialTrends, searchTrends, discussions) {\n    const gaps = [];\n    const trendingTopics = [...(socialTrends.trending_topics || []), ...(searchTrends.trending_searches || [])];\n    const existingContent = viralData.viral_content || [];\n    \n    trendingTopics.forEach(trend => {\n      const hasContent = existingContent.some(content => \n        content.title?.toLowerCase().includes(trend.topic?.toLowerCase() || trend.keyword?.toLowerCase())\n      );\n      \n      if (!hasContent && trend.engagement_score > 10000) {\n        gaps.push({\n          opportunity_type: 'trending_gap',\n          topic: trend.topic || trend.keyword,\n          potential_reach: trend.engagement_score || trend.search_volume,\n          urgency_score: this.calculateUrgencyScore(trend),\n          content_suggestion: this.generateContentSuggestion(trend),\n          target_platforms: this.recommendPlatforms(trend)\n        });\n      }\n    });\n    return gaps;\n  },\n  \n  calculateUrgencyScore(trend) {\n    let score = 0;\n    if (trend.trend_velocity === 'rising' || trend.growth === 'breakout') score += 40;\n    if (trend.engagement_score > 50000) score += 30;\n    if (trend.sentiment === 'positive') score += 20;\n    if (trend.seasonality && trend.seasonality.includes('peak')) score += 10;\n    return Math.min(100, score);\n  },\n  \n  generateContentSuggestion(trend) {\n    const topic = trend.topic || trend.keyword;\n    const suggestions = [];\n    \n    if (trend.content_type === 'video' || trend.platform === 'YouTube') {\n      suggestions.push(`Video tutorial: \"Ultimate Guide to ${topic} in 2025\"`);\n      suggestions.push(`Short-form video: \"5 ${topic} Tips That Will Blow Your Mind\"`);\n    }\n    \n    if (trend.platform === 'LinkedIn' || trend.demographics?.includes('professional')) {\n      suggestions.push(`LinkedIn article: \"How ${topic} is Transforming Business in 2025\"`);\n      suggestions.push(`Industry insight post: \"${topic} Trends Every Professional Should Know\"`);\n    }\n    \n    if (trend.hashtags?.length > 0) {\n      suggestions.push(`Social media series using ${trend.hashtags.join(', ')}`);\n    }\n    \n    if (trend.related_queries) {\n      trend.related_queries.forEach(query => {\n        suggestions.push(`Blog post: \"${query}\" - Complete Answer Guide`);\n      });\n    }\n    \n    return suggestions.slice(0, 3);\n  },\n  \n  recommendPlatforms(trend) {\n    const platforms = [];\n    \n    if (trend.demographics?.includes('professional') || trend.platform === 'LinkedIn') {\n      platforms.push('LinkedIn');\n    }\n    \n    if (trend.content_type === 'video' || trend.platform === 'YouTube') {\n      platforms.push('YouTube', 'TikTok');\n    }\n    \n    if (trend.trend_velocity === 'rising') {\n      platforms.push('Twitter', 'Instagram Stories');\n    }\n    \n    if (trend.engagement_score > 100000) {\n      platforms.push('Facebook', 'Instagram');\n    }\n    \n    return [...new Set(platforms)];\n  }\n};\n\nconst trendAnalysis = {\n  session_id: configData.sessionId,\n  analysis_date: configData.date,\n  timestamp: new Date().toISOString(),\n  \n  trending_topics: [\n    ...(socialData.trending_topics || []),\n    ...(trendsData.trending_searches || []).map(item => ({\n      topic: item.keyword,\n      engagement_score: parseInt(item.search_volume?.replace(/[^0-9]/g, '')) || 0,\n      trend_velocity: item.growth === 'breakout' ? 'rising' : 'steady',\n      source: 'Google Trends'\n    }))\n  ],\n  \n  viral_patterns: {\n    top_performing_content: viralData.viral_content || [],\n    successful_patterns: viralData.content_patterns || [],\n    optimal_timing: viralData.optimal_posting_times || {},\n    hashtag_performance: viralData.hashtag_performance || []\n  },\n  \n  community_insights: {\n    reddit_discussions: redditData.hot_discussions || [],\n    pain_points: redditData.community_insights?.content_gaps || [],\n    user_questions: redditData.hot_discussions?.flatMap(d => d.emerging_questions || []) || []\n  },\n  \n  content_opportunities: [],\n  content_gaps: [],\n  recommended_actions: []\n};\n\ntrendAnalysis.content_opportunities = [\n  ...(socialData.content_opportunities || []),\n  ...(trendsData.content_suggestions || []),\n  ...(redditData.content_opportunities || [])\n];\n\ntrendAnalysis.content_gaps = trendAnalyzer.identifyContentGaps(\n  socialData,\n  trendsData,\n  redditData.hot_discussions || []\n);\n\ntrendAnalysis.recommended_actions = [\n  {\n    priority: 'high',\n    action: 'Create content for trending gaps',\n    details: trendAnalysis.content_gaps.filter(gap => gap.urgency_score > 70),\n    timeline: 'within 24 hours'\n  },\n  {\n    priority: 'medium',\n    action: 'Optimize posting schedule',\n    details: trendAnalysis.viral_patterns.optimal_timing,\n    timeline: 'next week'\n  },\n  {\n    priority: 'low',\n    action: 'Monitor emerging trends',\n    details: trendAnalysis.trending_topics.filter(topic => topic.trend_velocity === 'rising'),\n    timeline: 'ongoing'\n  }\n];\n\nconst avgEngagement = trendAnalysis.trending_topics.reduce((sum, topic) => \n  sum + (topic.engagement_score || 0), 0) / trendAnalysis.trending_topics.length;\n\ntrendAnalysis.trend_health_score = Math.min(100, avgEngagement / 1000);\ntrendAnalysis.total_opportunities = trendAnalysis.content_opportunities.length + trendAnalysis.content_gaps.length;\n\nreturn [{ json: trendAnalysis }];"
},
"typeVersion": 2
},
{
"id": "a6d08972-facf-4126-97f3-568b8fedd7fd",
"name": "Content Calendar Writer",
"type": "n8n-nodes-base.googleSheets",
"position": [
1090,
360
],
"parameters": {
"columns": {
"value": {
"Date": "={{ new Date().toISOString().split('T')[0] }}",
"Status": "Planned",
"Platform": "={{ $json.content_calendar?.[0]?.platform || 'Multi-Platform' }}",
"Priority": "={{ $json.content_ideas?.high_priority?.[0]?.priority || 'Medium' }}",
"Created_By": "AI Trend Monitor",
"Session_ID": "={{ $('Trend Insight Engine').item.json.session_id }}",
"Trend_Score": "={{ $('Trend Insight Engine').item.json.trend_health_score }}",
"Content_Type": "={{ $json.content_calendar?.[0]?.format || 'Blog Post' }}",
"Posting_Time": "={{ $json.engagement_optimization?.optimal_posting_times?.LinkedIn || '9:00 AM' }}",
"Content_Title": "={{ $json.content_calendar?.[0]?.title || 'AI-Generated Content Idea' }}",
"Target_Hashtags": "={{ $json.engagement_optimization?.best_hashtags?.slice(0, 5).join(', ') || '#ContentMarketing' }}",
"Content_Description": "={{ $json.content_ideas?.high_priority?.[0]?.description || 'Trending topic content' }}",
"Expected_Engagement": "={{ $json.content_calendar?.[0]?.expected_engagement || 'Medium' }}"
},
"mappingMode": "defineBelow"
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Content_Calendar_2025"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "[YOUR_ID]"
}
},
"typeVersion": 4.5
},
{
"id": "dc42220e-341b-46b8-81c6-966bace53cf7",
"name": "Team Alert Dispatcher",
"type": "n8n-nodes-base.slack",
"position": [
1110,
580
],
"parameters": {
"text": "=\ud83d\ude80 **Daily Trend Report - {{ $('Trend Insight Engine').item.json.analysis_date }}**\n\n\ud83d\udcca **Trend Health Score**: {{ $('Trend Insight Engine').item.json.trend_health_score }}/100\n\ud83c\udfaf **Content Opportunities**: {{ $('Trend Insight Engine').item.json.total_opportunities }}\n\u26a1 **High-Priority Trends**: {{ $('Trend Insight Engine').item.json.trending_topics.filter(t => t.engagement_score > 50000).length }}\n\n\ud83d\udd25 **Top Trending Topic**: {{ $('Trend Insight Engine').item.json.trending_topics[0]?.topic || 'No major trends' }}\n\ud83d\udcc8 **Engagement Score**: {{ $('Trend Insight Engine').item.json.trending_topics[0]?.engagement_score || 0 }}\n\n\ud83d\udca1 **Immediate Actions Needed**:\n{{ $('Trend Insight Engine').item.json.recommended_actions.filter(a => a.priority === 'high').map(a => `\u2022 ${a.action} (${a.timeline})`).join('\\n') || '\u2022 No urgent actions required' }}\n\n\ud83d\udcc5 **Content Calendar Updated**: {{ $('Trend Insight Engine').item.json.total_opportunities }} new ideas added\n\ud83d\udd17 **View Full Report**: [Content Calendar](https://docs.google.com/spreadsheets/[YOUR_ID])",
"channel": "[YOUR_ID]",
"attachments": [],
"otherOptions": {
"icon_emoji": ":chart_with_upwards_trend:"
}
},
"typeVersion": 1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Query Assembly Logic": {
"main": [
[
{
"node": "Social Trend Scraper AI",
"type": "main",
"index": 0
},
{
"node": "Google Trends Scraper AI",
"type": "main",
"index": 0
},
{
"node": "Viral Content Analyzer AI",
"type": "main",
"index": 0
},
{
"node": "Reddit Insights Scraper AI",
"type": "main",
"index": 0
}
]
]
},
"Combine Trend Outputs": {
"main": [
[
{
"node": "Trend Insight Engine",
"type": "main",
"index": 0
}
]
]
},
"Batch Query Splitter": {
"main": [
[
{
"node": "Query Assembly Logic",
"type": "main",
"index": 0
}
]
]
},
"Social Trend Scraper AI": {
"main": [
[
{
"node": "Combine Trend Outputs",
"type": "main",
"index": 0
}
]
]
},
"Google Trends Scraper AI": {
"main": [
[
{
"node": "Combine Trend Outputs",
"type": "main",
"index": 1
}
]
]
},
"Trend Insight Engine": {
"main": [
[
{
"node": "Content Calendar Writer",
"type": "main",
"index": 0
},
{
"node": "Team Alert Dispatcher",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Trend Pulse": {
"main": [
[
{
"node": "Trend Setup Builder",
"type": "main",
"index": 0
}
]
]
},
"Trend Setup Builder": {
"main": [
[
{
"node": "Batch Query Splitter",
"type": "main",
"index": 0
}
]
]
}
}
}