Skip to main content

Auto-post platform-optimized content to X and Threads with late API and Google Sheets

Workflow preview

Workflow preview
100%
Auto-post platform-optimized content to X and Threads with late API and Google Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

X (Twitter) and Threads (by Meta) both have different maximum character lengths. Different X and Threads Content Auto Poster This n8n template demonstrates how to post different content optimized f...

Best for

  • Social Media automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.googlesheets, n8n-nodes-base.if, n8n-nodes-base.httprequest, n8n-nodes-base.stickynote, n8n-nodes-base.scheduletrigger, n8n-nodes-base.code, n8n-nodes-base.set, n8n-nodes-base.noop

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Fariez.

Original n8n.io source

1.1 Workflow description

Title
Auto-post platform-optimized content to X and Threads with late API and Google Sheets
Workflow name
Auto-post platform-optimized content to X and Threads with late API and Google Sheets

X (Twitter) and Threads (by Meta) both have different maximum character lengths.

Different X and Threads Content Auto Poster

This n8n template demonstrates how to post different content optimized for X (Twitter) and Meta Threads using the Late API.

You can use it for any niche. For example: posting AI news to X and Threads.

Possible use cases:

  • Schedule your posts to X and Threads.
  • Use this workflow as a content calendar and automated posting system.
  • Apply it across different content niches.

How it works

  • The automation runs according to the time defined in the Schedule Trigger node.
  • Content is pulled from Google Sheets.
  • Any URL is shortened using your preferred short URL API.
  • Images are uploaded to Late’s server first.
  • Content for X is posted in Step 2. The workflow checks that the content length is under 280 characters.
  • Content for Threads is posted in Step 3. The workflow checks that the content length is under 500 characters.
  • Posts on X are published as threaded posts, while on Threads they are single posts.
  • Once posted, the Google Sheets content database is updated.

Requirements

  • Google OAuth credentials with the Google Sheets API enabled
  • Bitly account and access token (or OAuth)
  • GetLate API connected to your X and Threads accounts

HOW TO USE

STEP 1

  1. Adjust the settings in the Schedule Trigger node to define when the workflow runs.
  2. Open this Google Sheets template, then go to File → Make a copy, and update the settings in the Get Topic node.
  3. Get your Bitly OAuth or Access Token here and add the credentials in the Short Link node.
  4. Get your API key from getlate.dev and add the credentials in the Upload IMG node.

STEP 2

  1. Add your Late credentials to the Post Twitter node.
  2. Get your Twitter account ID from Late, and update it in the JSON Body section of the Post Twitter node.

STEP 3

  1. Add your Late credentials to the Post Threads node.
  2. Get your Threads account ID from Late, and update it in the JSON Body section of the Post Threads node.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Get Topic

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 2 - If

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 3 - Get Img

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 4 - Post Twitter

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 5 - If1

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 6 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Update Data Posted

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 10 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 12 - Rename Img

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 13 - Upload IMG

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 14 - Set Tweets

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 15 - No Operation, do nothing

Type / Role
n8n-nodes-base.noOp - noOp
Config choices
Version 1

Block 16 - Set Thread

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 17 - Post Thread

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 18 - No Operation, do nothing1

Type / Role
n8n-nodes-base.noOp - noOp
Config choices
Version 1

Block 19 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 20 - Short link

Type / Role
n8n-nodes-base.bitly - bitly
Config choices
Version 1

3. Summary Table

Workflow Auto-post platform-optimized content to X and Threads with late API and Google Sheets
Complexity advanced
Nodes 20
Categories Social Media
Author Fariez
Published 03 Sept 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/8223/8223.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Auto-post platform-optimized content to X and Threads with late API and Google Sheets do?

X (Twitter) and Threads (by Meta) both have different maximum character lengths. Different X and Threads Content Auto Poster This n8n template demonstrates how to post different content optimized f...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Social Media use case.