Post your queued content to X on schedule

Every day at 09:00, your content queue in Google Sheets is read, one post per row with the day it should go out. Working down the sheet, the rows that are due and not yet posted are published to X, and the date and a link to the live post are written back into the row.

Nothing goes out twice: a row with anything in 'Posted On' is skipped, and that marker is written before the post is published, so an interrupted run leaves the row marked rather than letting the next run send it again. Nothing is published before its date, and a run publishes at most five posts (you can change the number); any due posts beyond that wait for the next day, and the run says how many. If X refuses a post, its row is marked 'Failed' with the date and X's reason, and the run is marked failed. A post over the 280 characters X accepts (counting each link as 23, as X does), or a row with an unreadable date, is left queued and the run is marked failed, naming the row. 'Posted On' and 'Link' are the only cells ever written, so your own columns are never touched.

You need Google Sheets and X connections, and a queue tab with 'Posted On' and 'Link' as its first two columns, then a 'Post' column and a 'Publish Date' column. Fill in the spreadsheet's link and the tab's name.

Run every day at 09:00.Run every day at 09:00.

Set queueSheetUrl to blank.Set queueSheetUrl to blank.

Set queueTabName to blank.Set queueTabName to blank.

Set maxPostsThisRun to 5.Set maxPostsThisRun to 5.

Google SheetsRead the rows of queueSheetUrl. Save it as queue.Read the rows of queueSheetUrl. Save it as queue.

Set queueHeaders to queue.headers.Set queueHeaders to queue.headers.

Set headerLine to queueHeaders joined by ||.Set headerLine to queueHeaders joined by ||.

If headerLine doesn't start with Posted On|Link|If headerLine doesn't start with Posted On|Link|

Yes

Stop and report a problem: The first two columns of your queue tab must be headed 'Posted On' and 'Link', in that order. They are the only two cells this workflow ever writes to, so your own columns stay untouched. Add them, then run it again.Stop and report a problem: The first two columns of your queue tab must be headed 'Posted On' and 'Link', in that order. They are the only two cells this workflow ever writes to, so your own columns stay untouched. Add them, then run it again.

No

No steps

If queueHeaders doesn't contain PostIf queueHeaders doesn't contain Post

Yes

Stop and report a problem: Your queue tab needs a column headed 'Post' holding the text to publish. Add it, then run it again.Stop and report a problem: Your queue tab needs a column headed 'Post' holding the text to publish. Add it, then run it again.

No

No steps

If queueHeaders doesn't contain Publish DateIf queueHeaders doesn't contain Publish Date

Yes

Stop and report a problem: Your queue tab needs a column headed 'Publish Date' holding the day each post should go out, written as 2026-09-01. Add it, then run it again.Stop and report a problem: Your queue tab needs a column headed 'Publish Date' holding the day each post should go out, written as 2026-09-01. Add it, then run it again.

No

No steps

Get today's date and save it as todaysDate.Get today's date and save it as todaysDate.

XGet your account. Save it as profile.Get your account. Save it as profile.

Set authorHandle to i/web.Set authorHandle to i/web.

If a step below fails, save the error as profileProblemIf a step below fails, save the error as profileProblem

Try

Trim profile.user.username and save it as foundHandle.Trim profile.user.username and save it as foundHandle.

If foundHandle isn't emptyIf foundHandle isn't empty

Yes

Change authorHandle to foundHandle.Change authorHandle to foundHandle.

No

No steps

On error

Show in the output: Could not read your X username, so the links written back to the queue use the generic form..Show in the output: Could not read your X username, so the links written back to the queue use the generic form..

Set postsPublished to 0.Set postsPublished to 0.

Set published to an empty record.Set published to an empty record.

Set dueLeft to 0.Set dueLeft to 0.

Set problems to an empty list.Set problems to an empty list.

For each row in queue.rows:For each row in queue.rows:

If a step below fails, save the error as rowProblemIf a step below fails, save the error as rowProblem

Try

Set rowNumber to row.row_number.Set rowNumber to row.row_number.

Trim row["Posted On"] and save it as postedOn.Trim row["Posted On"] and save it as postedOn.

If postedOn isn't emptyIf postedOn isn't empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

Trim row.Post and save it as postText.Trim row.Post and save it as postText.

If postText is emptyIf postText is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

Trim row["Publish Date"] and save it as publishDate.Trim row["Publish Date"] and save it as publishDate.

If publishDate is emptyIf publishDate is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

Set daysSinceDue to -1.Set daysSinceDue to -1.

If a step below fails, save the error as dateProblemIf a step below fails, save the error as dateProblem

Try

Count the days from publishDate to todaysDate and save it as daysSinceDue.Count the days from publishDate to todaysDate and save it as daysSinceDue.

On error

Add Row rowNumber: the publish date '@publishDate' is not a date, so the post was left in the queue. Write it as 2026-09-01. to the end of problems and save it as problems.Add Row rowNumber: the publish date '@publishDate' is not a date, so the post was left in the queue. Write it as 2026-09-01. to the end of problems and save it as problems.

Skip to the next item.Skip to the next item.

If daysSinceDue is less than 0If daysSinceDue is less than 0

Yes

Skip to the next item.Skip to the next item.

No

No steps

Replace the pattern https?://\S+ with https://t.co/LinkLength in postText and save it as countedText.Replace the pattern https?://\S+ with https://t.co/LinkLength in postText and save it as countedText.

Count the characters in countedText and save it as countedLength.Count the characters in countedText and save it as countedLength.

If countedLength is greater than 280If countedLength is greater than 280

Yes

Add Row rowNumber: the post is countedLength characters as X counts them (a link counts as 23), over the 280 X accepts, so it was left in the queue. Shorten it. to the end of problems and save it as problems.Add Row rowNumber: the post is countedLength characters as X counts them (a link counts as 23), over the 280 X accepts, so it was left in the queue. Shorten it. to the end of problems and save it as problems.

Skip to the next item.Skip to the next item.

No

No steps

If postsPublished is greater than or equal to maxPostsThisRunIf postsPublished is greater than or equal to maxPostsThisRun

Yes

Add 1 to dueLeft.Add 1 to dueLeft.

Skip to the next item.Skip to the next item.

No

No steps

Google SheetsOverwrite row rowNumber of queueTabName in queueSheetUrl.Overwrite row rowNumber of queueTabName in queueSheetUrl.

If a step below fails, save the error as postProblemIf a step below fails, save the error as postProblem

Try

XPost: postText. Save it as published.Post: postText. Save it as published.

On error

Add Row rowNumber: X did not publish it - postProblem.message to the end of problems and save it as problems.Add Row rowNumber: X did not publish it - postProblem.message to the end of problems and save it as problems.

Google SheetsOverwrite row rowNumber of queueTabName in queueSheetUrl.Overwrite row rowNumber of queueTabName in queueSheetUrl.

Skip to the next item.Skip to the next item.

Add 1 to postsPublished.Add 1 to postsPublished.

Set postLink to https://x.com/@authorHandle/status/@published.tweet.id.Set postLink to https://x.com/@authorHandle/status/@published.tweet.id.

If a step below fails, save the error as linkProblemIf a step below fails, save the error as linkProblem

Try

Google SheetsOverwrite row rowNumber of queueTabName in queueSheetUrl.Overwrite row rowNumber of queueTabName in queueSheetUrl.

On error

Add Row rowNumber was published (postLink) but its link could not be written back, so the row still reads 'in progress'. Paste the link into it. Google Sheets said: linkProblem.message to the end of problems and save it as problems.Add Row rowNumber was published (postLink) but its link could not be written back, so the row still reads 'in progress'. Paste the link into it. Google Sheets said: linkProblem.message to the end of problems and save it as problems.

On error

Add Row row.row_number could not be handled, so nothing was posted from it: rowProblem.message to the end of problems and save it as problems.Add Row row.row_number could not be handled, so nothing was posted from it: rowProblem.message to the end of problems and save it as problems.

Set summaryLines to an empty list.Set summaryLines to an empty list.

Add Published postsPublished post(s) from the queue. to the end of summaryLines and save it as summaryLines.Add Published postsPublished post(s) from the queue. to the end of summaryLines and save it as summaryLines.

If dueLeft is 1If dueLeft is 1

Yes

Add 1 due post left for tomorrow, because 'maxPostsThisRun' is maxPostsThisRun. to the end of summaryLines and save it as summaryLines.Add 1 due post left for tomorrow, because 'maxPostsThisRun' is maxPostsThisRun. to the end of summaryLines and save it as summaryLines.

Else if @dueLeft is greater than 1

Add dueLeft due posts left for tomorrow, because 'maxPostsThisRun' is maxPostsThisRun. to the end of summaryLines and save it as summaryLines.Add dueLeft due posts left for tomorrow, because 'maxPostsThisRun' is maxPostsThisRun. to the end of summaryLines and save it as summaryLines.

Otherwise

No steps

Join problems with a new line and save it as problemText.Join problems with a new line and save it as problemText.

If problems isn't emptyIf problems isn't empty

Yes

Add These rows need your attention:Add These rows need your attention: problemText to the end of summaryLines and save it as summaryLines.

Stop and report a problem: summaryLines joined by a blank line.Stop and report a problem: summaryLines joined by a blank line.

No

No steps

Finish the run: summaryLines joined by a blank line.Finish the run: summaryLines joined by a blank line.