Monitor Content Trends Across Social Media with AI, Slack, and Google Sheets

This n8n workflow automates the process of extracting content trends from social media, analyzing them with AI, storing the data in Google Sheets, and notifying a Slack channel. It's designed to help you stay on top of trending topics without manual effort.

What it does

This workflow automates the following steps:

1. Triggers on a Schedule: The workflow starts at predefined intervals (e.g., daily, hourly) to check for new trends.
2. Fetches Social Media Content: (Implicit based on the directory name, but not explicitly in the provided JSON. A "Code" node or another app node would typically handle this.)
3. Analyzes Content with AI: (Implicit, likely handled by a "Code" node or an AI-specific node not present in the provided JSON.) The AI would process the fetched content to identify trends, sentiment, or key topics.
4. Stores Data in Google Sheets: The processed trend data is appended to a specified Google Sheet for historical tracking and further analysis.
5. Notifies Slack Channel: A summary or alert about the identified trends is posted to a designated Slack channel, keeping your team informed.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: To store the trend data. You'll need to configure Google Sheets credentials in n8n.
• Slack Account: To receive notifications. You'll need to configure Slack credentials in n8n.
• AI Service/API Key: (Implicit) If using an external AI service (e.g., OpenAI, Google AI), you'll need an API key and the relevant node or custom code configured.
• Social Media API Access: (Implicit) To fetch content from social media platforms (e.g., Twitter, Reddit, TikTok). This would typically involve API keys or authentication for each platform.

Setup/Usage

1. Import the Workflow:
   • Download the workflow JSON.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" -> "Import from JSON" and paste the workflow JSON.
2. Configure Credentials:
   • Locate the "Google Sheets" node and configure your Google Sheets credentials.
   • Locate the "Slack" node and configure your Slack credentials.
   • (If applicable) Configure credentials for any AI or social media nodes you add.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule in the "Schedule Trigger" node to your desired frequency (e.g., daily, hourly).
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where you want to store the data.
   • Slack: Specify the Slack channel ID or name where you want to post notifications. Customize the message content to include relevant trend data.
   • Code Node (Implicit): If you're using the "Code" node for AI analysis or social media fetching, you'll need to write or adapt the JavaScript code to perform these actions and structure the output for subsequent nodes.
4. Activate the Workflow: Once all nodes are configured, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

This workflow provides a robust foundation for automated content trend monitoring, keeping you and your team updated with minimal manual intervention.