View on GitHub

ssbot

A Google Spreadsheet engine for a Twitter bot.

SSBot

A tool for making a twitter bot using Google Spreadsheets. Because the software runs in Google Spreadsheets, and it requires the interaction of a specifically-constructed sheet with the underlying code specific to that sheet, this GitHub repo exists

The .gs files in this repository are the underlying GAS code for the dev version.

Spreadsheets

To use one of these spreadsheets, “File -> Make a Copy…” to save it to your Google Drive.

Current (v0.5.1)

Legacy (v0.4)

Setup

A step-by-step guide for the legacy version is available on my website.

Step 1: Create your Bot’s Twitter Account

I like to do this first because it gives your bot a sense of identity while you work on it. You probably already know how to sign up for a Twitter account, so here are few tips:

You can customize your bot’s profile now or later, but I always like to give my bots an avatar picture, a nice background, and an informative bio that explains the bot purpose while disclosing its botness.

Signup Page Screenshot

Step 2: Create your Twitter App

Step 3: Authorize your spreadsheet with your API credentials

Step 4: Choose and Configure a Constructor

Step 5: Review some General Settings

Step 6: Start Posting