How to schedule Typefully posts from Google Sheets
If you have 100s of text posts inside Google Sheets that you would like to automatically schedule and publish to X/Twitter, Threads, LinkedIn, Mastodon, Bluesky, etc. via Typefully, it's possible to do so using this script. Here are the steps to set this up:
- Create a Google Sheets spreadsheet and put all your posts in a column
- Get the script from here, copy-paste inside Google Sheets Apps Script
- Get your API key from Typefully and add it in the script
- Specify columns for status and Typefully scheduled links in the script
- Run the script to see all posts getting scheduled one-by-one
And all posts will be scheduled as per the next-free-slot available in your Typefully account. You can learn more about different options supported via the API on this documentation page.
Also, if you're comfortable using AI for generating posts then you can also use this script to generate posts first and then use the Typefully script to schedule them.
Some links here are affiliate or referral links. Buying through them supports this site at no extra cost to you, and it doesn't affect my opinions.