Generate and Schedule Social Posts with Gemini/OpenAI for X and LinkedIn

This n8n workflow automates the generation and scheduling of social media posts for X (formerly Twitter) and LinkedIn using AI. It simplifies content creation by leveraging either Google Gemini or OpenAI, allowing you to quickly populate your social media queues with engaging content.

What it does

1. Triggers on Schedule or Form Submission: The workflow can be initiated either on a predefined schedule (e.g., daily, weekly) or manually through an n8n form submission.
2. Generates Social Post Ideas:
   • It uses a Function node to define a prompt for the AI.
   • It then interacts with either a Google Gemini Chat Model or an OpenAI node to generate social media post content based on the prompt.
3. Parses AI Output: A Structured Output Parser node extracts the generated social post details (e.g., content for X, content for LinkedIn, relevant hashtags) from the AI's response.
4. Schedules Posts to Google Sheets: The parsed content is then written to a specified Google Sheet, acting as a content calendar or queue for future posts.
5. Optionally Posts to Social Media:
   • The workflow includes nodes to directly post the generated content to X (Formerly Twitter) and LinkedIn.
   • It also has a Slack node, potentially for notifications or approvals before posting.
6. Merges Data: A Merge node combines data streams, likely for consolidating the generated content with scheduling information or confirmation messages.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: Configured credentials for Google Sheets to store and manage your social media posts.
• AI Service Credentials:
  • Google Gemini: Credentials for the Google Gemini Chat Model.
  • OpenAI: An OpenAI API Key configured as a credential in n8n.
• Social Media Accounts:
  • X (formerly Twitter): Configured credentials for your X account to post tweets.
  • LinkedIn: Configured credentials for your LinkedIn account to post updates.
• Slack Account (Optional): Configured credentials for Slack if you wish to receive notifications or implement an approval step.

Setup/Usage

1. Import the Workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • For each service (Google Sheets, Google Gemini/OpenAI, X, LinkedIn, Slack), create or select existing credentials within n8n.
   • Ensure the Google Sheets node is configured to write to your desired spreadsheet and sheet name.
3. Customize AI Prompt:
   • Open the Function node (ID 14) and modify the JavaScript code to adjust the prompt for generating social media content. Tailor it to your specific niche, tone, and content requirements.
   • Choose between the Google Gemini Chat Model or OpenAI node based on your preference and configured credentials.
4. Set Schedule (Optional):
   • If using the Schedule Trigger (ID 839), configure its interval (e.g., every day, every week) to automate content generation.
5. Configure Form Trigger (Optional):
   • If using the n8n Form Trigger (ID 1225), customize the form fields to allow manual input for content generation requests.
6. Activate the Workflow: Once configured, activate the workflow. It will now run according to its trigger or when the form is submitted.

This workflow provides a robust framework for automating social media content creation and scheduling, saving time and ensuring consistent online presence.