n8n Workflow: Auto-Generate SEO Content from Trends with GPT-4o and Multi-Storage

This n8n workflow automates the process of generating SEO-optimized content based on trending topics, leveraging AI (GPT-4o) for content creation and offering flexible storage options including SharePoint and local CSV files. It's designed to streamline content production, ensuring your content stays relevant and discoverable.

What it does

This workflow performs the following key steps:

1. Receives a Trigger: It starts by listening for an incoming webhook, which typically provides a trending topic or a prompt for content generation.
2. Generates Content with AI: It uses an AI Agent (likely powered by GPT-4o, given the context) to generate SEO-friendly content based on the input.
3. Processes and Formats Content: The generated content is then processed and formatted. This includes:
   • Extracting relevant data from the AI response.
   • Setting specific fields and values for the content (e.g., title, body, keywords).
4. Conditional Storage: It intelligently decides where to store the generated content based on a condition:
   • SharePoint Storage: If a specific condition is met (e.g., a flag in the webhook payload, or a specific content type), the content is converted into a file and uploaded to Microsoft SharePoint.
   • CSV File Storage: If the SharePoint condition is not met, the content is converted into a CSV file and potentially stored locally or sent via email.
5. Notifies via Email (Optional): If the content is stored as a CSV, it can optionally be sent as an email attachment using Gmail.
6. Waits (Optional): Includes a Wait step, which might be used for rate limiting or to introduce a delay between operations.
7. Responds to Webhook: Finally, it responds to the initial webhook, indicating the completion of the process.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Webhook Source: A system or application that can send HTTP POST requests to the n8n webhook URL.
• OpenAI API Key (or compatible LLM): Credentials for an OpenAI Chat Model (or another Large Language Model configured with the AI Agent node), likely GPT-4o given the workflow's purpose.
• Microsoft SharePoint Account: Credentials for Microsoft SharePoint if you intend to use the SharePoint storage option.
• Gmail Account: Credentials for a Gmail account if you intend to use the email notification feature for CSV files.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" -> "Import from JSON" and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the "AI Agent" node and ensure your OpenAI (or preferred LLM) credentials are set up.
   • If using SharePoint, configure the "Microsoft SharePoint" node with your SharePoint credentials.
   • If using Gmail, configure the "Gmail" node with your Gmail credentials.
3. Configure Webhook Trigger:
   • The "Webhook" node will provide a unique URL once the workflow is activated. Copy this URL.
   • Configure your external system to send POST requests to this URL, including the trending topic or content prompt in the request body.
4. Customize Content Logic:
   • Review the "Edit Fields" (Set) nodes to adjust how the AI-generated content is structured and transformed.
   • Examine the "If" and "Switch" nodes to understand and modify the conditional logic for content storage.
   • Adjust the "Convert to File" and "Spreadsheet File" nodes for CSV generation and the "Microsoft SharePoint" node for SharePoint uploads as needed.
5. Activate the Workflow:
   • Once configured, activate the workflow by toggling the switch in the top right corner of the workflow editor.