Automated AI Tweets to X from Google Sheets

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "Auto-Post to X",
  "nodes": [
    {
      "id": "1",
      "name": "Cron Trigger",
      "type": "n8n-nodes-base.cron",
      "typeVersion": 1,
      "position": [
        240,
        300
      ],
      "parameters": {
        "triggerTimes": [
          {
            "hour": 9,
            "minute": 0
          }
        ]
      }
    },
    {
      "id": "2",
      "name": "Generate Tweet",
      "type": "n8n-nodes-base.openAi",
      "typeVersion": 1,
      "position": [
        480,
        300
      ],
      "parameters": {
        "mode": "chat",
        "operation": "createChatCompletion",
        "model": "gpt-4o-mini",
        "messages": [
          {
            "role": "system",
            "content": "You generate short, human-like social posts for X. Keep them under 200 characters, conversational, and avoid hashtags unless really needed."
          },
          {
            "role": "user",
            "content": "Write a post promoting InOneButton, the one-tap AI meeting assistant."
          }
        ]
      }
    },
    {
      "id": "3",
      "name": "Post to X",
      "type": "n8n-nodes-base.twitter",
      "typeVersion": 2,
      "position": [
        720,
        300
      ],
      "credentials": {
        "twitterOAuth1Api": {
          "name": "<your credential>"
        }
      },
      "parameters": {
        "resource": "tweet",
        "operation": "create",
        "text": "={{ $json[\"choices\"][0][\"message\"][\"content\"] }}"
      }
    },
    {
      "id": "4",
      "name": "Log to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 3,
      "position": [
        960,
        300
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "parameters": {
        "operation": "append",
        "sheetId": "__REPLACE_WITH_YOUR_SHEET_ID__",
        "range": "A:C",
        "valueInputMode": "RAW",
        "options": {},
        "values": [
          [
            "={{ $now }}",
            "={{ $json[\"choices\"][0][\"message\"][\"content\"] }}",
            "Posted"
          ]
        ]
      }
    }
  ],
  "connections": {
    "Cron Trigger": {
      "main": [
        [
          {
            "node": "Generate Tweet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Tweet": {
      "main": [
        [
          {
            "node": "Post to X",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post to X": {
      "main": [
        [
          {
            "node": "Log to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• googleSheetsOAuth2Api
• twitterOAuth1Api

About this workflow

Auto-Post to X. Uses openAi, twitter, googleSheets. Scheduled trigger; 4 nodes.

Source: https://github.com/mirko1075/one-button-landpage/blob/5d22d9f03b77707b57211e8497eff54dee34f175/n8n/n8n-x-posts.json — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.