Publishes the posts in your spreadsheet queue on the day each one is due, and writes the date and link back so none goes out twice.
Uses
Google Sheets
X
Post your queued content to X on schedule
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 PostYes
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 DateYes
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 profileProblemTry
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 emptyYes
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 rowProblemTry
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 emptyYes
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 emptyYes
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 emptyYes
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 dateProblemTry
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 0Yes
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 280Yes
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 maxPostsThisRunYes
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 postProblemTry
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 linkProblemTry
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 1Yes
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 emptyYes
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.