Automate Twitter Posting with GPT-4 Content Generation and Google Sheets Tracking

This n8n workflow automates the process of generating Twitter (X) posts using an AI agent (GPT-4), posting them to Twitter, and tracking the published content in a Google Sheet. It's designed to streamline social media content creation and management, ensuring a consistent posting schedule and a record of all published tweets.

What it does

1. Triggers on a Schedule: The workflow starts at predefined intervals (e.g., daily, hourly) to ensure regular content generation and posting.
2. Generates Content with AI: An AI Agent (powered by OpenAI's GPT-4) is prompted to generate a tweet. This agent uses a "Simple Memory" to maintain context across generations and is configured to use an "OpenAI Chat Model" for its language capabilities.
3. Posts to X (Twitter): The generated tweet content is automatically published to your connected X (Twitter) account.
4. Tracks in Google Sheets: After successful posting, the tweet content is recorded in a Google Sheet, providing a historical log of all published posts. This allows for easy tracking and analysis of your social media activity.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• OpenAI API Key: An API key for OpenAI (likely GPT-4 access for the AI Agent). This will need to be configured as an n8n credential.
• X (Twitter) Account: A Twitter account and corresponding API credentials configured in n8n to allow posting.
• Google Account: A Google account with access to Google Sheets. This will need to be configured as an n8n credential.
• Google Sheet: A Google Sheet set up to store your tweet data. You'll need to specify the Spreadsheet ID and Sheet Name in the Google Sheets node.

Setup/Usage

1. Import the Workflow:
   • Download the workflow JSON.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • OpenAI: Set up an OpenAI API Key credential in n8n.
   • X (Twitter): Set up your Twitter API credentials in n8n.
   • Google Sheets: Set up your Google Sheets API credentials in n8n.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule to your desired posting frequency (e.g., daily, every few hours).
   • AI Agent:
     • Ensure the "OpenAI Chat Model" and "Simple Memory" sub-nodes are correctly configured with your OpenAI credential.
     • Modify the prompt within the AI Agent to guide the content generation according to your specific needs (e.g., "Generate a tweet about [topic]", "Write a concise tweet promoting [product]").
   • X (Twitter):
     • Select your Twitter credential.
     • Ensure the "Tweet" field is correctly mapped to the output of the AI Agent node (e.g., {{ $node["AI Agent"].json["text"] }}).
   • Google Sheets:
     • Select your Google Sheets credential.
     • Provide the Spreadsheet ID and Sheet Name where you want to log the tweets.
     • Map the data fields (e.g., tweet content, timestamp) from the AI Agent and Twitter nodes to the appropriate columns in your Google Sheet.
4. Activate the Workflow: Once all configurations are complete, save and activate the workflow. It will now run automatically based on your defined schedule.