How to schedule Typefully posts from Google Sheets
Unproofread notes
If you have 100s of text posts inside Google Sheets that you would like to automatically schedule via Typefully and publish to X/Twitter, Threads, LinkedIn, Mastodon, Bluesky, etc. then it's possible by using this script. And the steps to set this up are:
- 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.
Comment via email