Generate Automated Social Media Reports with GPT-4o, Twitter, Facebook, and Notion

This n8n workflow automates the generation of social media performance reports, leveraging the power of GPT-4o for analysis and Notion for organized storage. It's designed to help social media managers, marketers, and analysts quickly gather insights and create structured reports without manual data compilation.

What it does

This workflow streamlines the social media reporting process through the following steps:

1. Manual Trigger: The workflow is initiated manually, allowing you to run it on-demand for report generation.
2. Retrieve Social Media Data (HTTP Request): It makes an HTTP request to an external API (likely a social media analytics platform or a custom script) to fetch relevant social media data.
3. Process Data with AI Agent (GPT-4o): The retrieved social media data is fed into an AI Agent (configured with an Azure OpenAI Chat Model, likely GPT-4o). This agent analyzes the raw data to extract key insights, trends, and performance metrics.
4. Conditional Reporting (If Node): Based on the AI agent's analysis or a predefined condition, the workflow can branch. For instance, it might check if a certain threshold is met or if specific insights are present.
5. Generate Report Content (Code Node): A Code node is used to dynamically construct the report content based on the AI agent's output. This allows for flexible formatting and inclusion of specific data points.
6. Store Report in Google Sheets: The generated report data is then stored in a Google Sheet, providing a structured and accessible record of the social media performance.
7. Store Report in Notion: Simultaneously, the report is also added to a Notion database, offering a more visually appealing and collaborative platform for report viewing and sharing.
8. Notify via Slack: A Slack message is sent, likely notifying a team or individual that the social media report has been generated and is available.
9. Notify via Gmail: An email notification is sent via Gmail, providing another channel for alerting stakeholders about the new report.
10. Merge Notifications: The Slack and Gmail notification branches are merged back into a single flow, ensuring all subsequent actions (if any) are executed after both notifications are processed.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: Configured credentials for Google Sheets to store report data.
• Notion Account: Configured credentials for Notion to store and display reports.
• Slack Account: Configured credentials for Slack to send notifications.
• Gmail Account: Configured credentials for Gmail to send email notifications.
• OpenAI API Key (or Azure OpenAI Service): Credentials for an Azure OpenAI Chat Model (likely GPT-4o) to power the AI Agent for data analysis. This implies access to the Azure OpenAI service.
• External Social Media Data Source: Access to an API or service that provides the raw social media data (configured in the HTTP Request node).

Setup/Usage

1. Import the workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials.
   • Set up your Notion credentials.
   • Set up your Slack credentials.
   • Set up your Gmail credentials.
   • Configure your Azure OpenAI Chat Model credentials, ensuring it points to your GPT-4o deployment.
3. Customize HTTP Request: Update the "HTTP Request" node with the correct URL and authentication details for your social media data source.
4. Adjust AI Agent Prompt: Modify the prompt within the "AI Agent" node to guide GPT-4o on how to analyze your specific social media data and what insights to extract for your reports.
5. Refine Code Node: Adjust the "Code" node to format the AI-generated insights into the desired report structure for Google Sheets and Notion.
6. Configure Google Sheets and Notion Nodes: Specify the target spreadsheet/database, sheet/page names, and mapping for the data fields.
7. Customize Slack and Gmail Notifications: Update the "Slack" and "Gmail" nodes with the desired channels/recipients, subject lines, and message content.
8. Activate the workflow: Once configured, activate the workflow.
9. Execute: Click the "Execute workflow" button on the "Manual Trigger" node to run the report generation process.