AutomationMart
Home/Browse/Generate content ideas with AI: Scrape Google & Facebook posts to Slack
n8n

Generate content ideas with AI: Scrape Google & Facebook posts to Slack

n8nn8n13 modulesv1.0
SlackNotionGoogle SheetsOpenAIFacebook

Description This workflow automates the process of finding new content ideas by scraping trending news and social media posts, analyzing them with AI, and delivering a summarized report to Slack. It is perfect for content marketers, social media managers, and strategists who spend hours researching trending topics manually. Who is this for Content Marketers: To discover trending topics for blogs or newsletters. Social Media Managers: To keep up with competitor activity or industry news. Mar

At a glance

Generate content ideas with AI: Scrape Google & Facebook posts to Slack is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Notion, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Notion, Google Sheets, OpenAI, Facebook
Modules
13
Price
Free
Version
v1.0
Generate content ideas with AI: Scrape Google & Facebook posts to Slack workflow diagram

About this workflow

Description This workflow automates the process of finding new content ideas by scraping trending news and social media posts, analyzing them with AI, and delivering a summarized report to Slack. It is perfect for content marketers, social media managers, and strategists who spend hours researching trending topics manually. Who is this for Content Marketers: To discover trending topics for blogs or newsletters. Social Media Managers: To keep up with competitor activity or industry news. Market Researchers: To monitor specific keywords or brands. How it works Schedule: The workflow runs automatically on a weekly schedule (default is Monday morning). Data Collection: It uses Apify to scrape the latest news from Google Search and recent posts from specific Facebook pages. Data Processing: The results are merged, and the top 5 most relevant items are selected to prevent information overload. AI Analysis: An AI Agent (powered by OpenRouter/LLM) analyzes each article to classify it into a theme (e.g., Marketing, Technology, Strategy) and extracts 3 catchy keywords. Notification: The analyzed insights, including the theme, keywords, summary, and original URL, are formatted and sent directly to Slack. Requirements Apify Account: You need an API token and access to the Google Search Results Scraper and Facebook Posts Scraper actors. OpenRouter API Key: Used to power the AI analysis (can be swapped for OpenAI/Anthropic if preferred). Slack Account: To receive the notifications. How to set up Configure Credentials: Open the Workflow Configuration node and paste your Apify API Token and OpenRouter API Key. Connect your Slack account in the Slack node. Adjust Apify Settings: In the Apify Google news node, change the search query (currently set to "Top News" in Japanese) to your desired topic. In the Apify Facebook node, update the startUrls to the Facebook pages you want to monitor. Customize AI Prompt: (Optional) Open the AI Agent node to adjust the language or the specific themes you want the AI to classify. How to customize Change the LLM: Replace the OpenRouter model with the OpenAI or Anthropic Chat Model node if you prefer those providers. Increase Data Volume: Adjust the "Limit 5 items" Code node to process more articles at once (mind your API usage limits). Change Destination: Replace the Slack node with Notion, Google Sheets, or Email to save the ideas elsewhere. 3. ⚠️ Crucial Checklist Before Submission The n8n team will reject templates that contain non-English text in the nodes. Please apply these changes to your workflow in the n8n editor before exporting the JSON for submission: Rename Nodes to English: Cron トリガー → Schedule Trigger Function: Slackメッセージ作成 → Format Slack Message Slack: 企画ネタ投稿 → Slack Post Function: LLMレスポンス整形 → Parse LLM Response Merge Data (統合) → Merge Data Function: データ抽出・5件制限 → Limit to 5 Items Function: Googleデータ抽出 → Extract Google Data Function: Facebookデータ抽出 → Extract FB Data Translate Code Comments & Prompts: Inside the Code nodes, ensure comments are in English (e.g., // Slackへの投稿メッセージを作成します → // Create message for Slack). Inside the AI Agent node, translate the System Prompt into English (e.g., "You are a professional content planner..." instead of "あなたはプロの..."). Even if you want the output in Japanese, the template default should usually be English, or clearly labeled as a Japanese template. Add the Mandatory Sticky Note: Add a Yellow Sticky Note to the canvas. Paste the "Description" text (from step 2 above) into this sticky note. Place it clearly next to the start of the workflow. Remove Hardcoded IDs: Ensure MASKEDUSERID and MASKEDWEBHOOKID are cleared out or set to expressions that reference the user's setup.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Automate hotel booking requests from Gmail to Google Sheets with GPT-5-mini

Who’s it for This workflow is for hotel managers, travel agencies, and hospitality teams who receive booking requests via email. It eliminates the need for manual data entry by automatically parsing emails and attachments, assigning booking cases to the right teams, and tracking performance metrics. What it does This workflow goes beyond simple automation by including enterprise-grade logic and security: 🛡️ Gatekeeper: Watches your Gmail and filters irrelevant emails before spending money on AI

Free

App Store Review Aggregator Using BrowserAct with Auto-Notification

Automate app review monitoring across both major app stores with this powerful workflow. Stop manually checking reviews and get instant notifications when users leave feedback. WHAT IT DOES: - Scrapes reviews from Google Play Store and Apple App Store simultaneously - Archives all reviews in Google Sheets for historical analysis - Sends instant alerts to your Telegram channel - Runs automatically on your schedule (hourly, daily, or on-demand) - Requires no API keys or app store credentials HOW

Free

Notion API MCP server

Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing 13 Notion API operations to AI agents. ⚡ Quick Setup 1. Import this workflow into your n8n instance 2. Credentials Add Notion API credentials 3. Activate the workflow to start your MCP server 4. Copy the webhook URL from the MCP trigger node 5. Connect AI agents using the MCP URL 🔧 How it Works This workflow converts the Notion AP

Free

Extract structured invoice data from JotForm PDFs with GPT-4.1-mini & Sheets

Who this is for This workflow is designed for Finance teams, accounting professionals, and automation engineers. Use Case: Automates processing of invoice submissions received via JotForm. Core Function: Extracts structured data such as: Invoice number Client information Totals and tax amounts Line items or services Key Benefit: Eliminates manual data entry, saving time and reducing human error. Automation Goal: Streamline document handling with AI-powered PDF parsing and structured o

Free

Create new LionDesk contacts from Google Forms responses

Every time a new Google Forms response is submitted, Make will automatically validate the email from the response using ZeroBounce. If the email status is "valid" it will get the person's details using Clearbit. If there is a result it will create a new contact on LionDesk and send a Slack message. If the contact already exists on LionDesk it will send a Slack message. This example uses the response sheet in [this link](https://docs.google.com/spreadsheets/d/1ywFP36iduqwZW1s2UFSToJeVj0KEkrOSayqv

Free

Create Front contacts from Google Sheets rows and add them to groups

Every time a new row is added in a Google Sheet, Make will automatically create a new contact in Front and send a message to that contact using Front. This example uses the sheet in [this link](https://docs.google.com/spreadsheets/d/1I_0ORbuaKUyehO5qj7l3iWRNYELfAuG5lQzLfyuSw9A/edit#gid=0).

Free

Automated event discovery with Bright Data & n8n

Description This workflow automatically discovers and collects information about upcoming events in your area or industry. It saves you time by eliminating the need to manually check multiple event websites and provides a centralized database of relevant events. Overview This workflow automatically scrapes websites for upcoming events in your area or industry and compiles them into a structured format. It uses Bright Data to access event listing websites and extract event details like dates, loc

Free

Ai data extraction with dynamic prompts and Airtable

This n8n template introduces the Dynamic Prompts Ai workflow pattern which are incredible for certain types of data extraction tasks where attributes are unknown or need to remain flexible. The general idea behind this pattern is that the prompts for requested attributes to be extracted live outside the template and so can be changed at any time - without needing to edit the template. This seriously cuts down on maintainance requirements and is reusable for any number of tables at little cost. C

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free