ABCD
1
☝️️ Before you do anything else, make a copy of this spreadsheetSSBot
2
A Twitter Bot Engine in Google Spreadsheets
3
version 0.6.0
4
5
Step 1: Create a Twitter account for your bot
6
This bot account will need to be email-verified and have a mobile number linked to it. If you already have a Twitter account with a mobile number, you can de-associate the number from that original account, verify it with new account, and then later, after the bot account starts posting, reverse the process to get the phone number back with your original account.
7
8
Twitter Bot's Handle:
9
@
10
11
 Step 2: Create a Twitter App for your bot
12
Make sure you're still logged in to your bot's account, and go to http://apps.twitter.com . Create a new app with some basic initial settings:
13
14
Name:<Whatever you want but it must be unique and cannot be blank>
15
Description:<Whatever you want but it cannot be blank>
16
Website URL:<Your actual website or a placeholder like http://www.example.com/>
17
Callback:https://script.google.com/macros/d/1Q-y4sQqOXdACzERQVukCdcRW2AYzOMIRDhF_xtcUe3X2CzYdMIZA51L7/usercallback
18
Copy/paste this exact value into the Twitter application. Make sure you don't accidentally inclued a space at the end when you paste it.
19
20
 Step 3: Complete and copy your App's settings.
21
Make sure the app's permissions say "Read and Write", then look in the Twitter app's "Keys and Access Tokens" tab, find the Consumer Key and Consumer Secret, and paste them here in the green cells.
22
23
Consumer Key (API Key):
24
25
26
Consumer Secret (API Secret):
27
28
29
 Step 4: Generate a preview.
30
In the "Bot" menu of this spreadsheet, select "Generate Preview." In addition to generating some sample tweets in the "Preview" tab, this action will also trigger an authorization dialog to allow Google to execute code on your behalf. (The default constructor is "columns," but you can change that later in the "Settings" tab.)
31
32
 Step 5: Send a test tweet.
33
In the "Bot" menu of this spreadsheet, select "Send a Test Tweet." If everything has been set up correctly, you should see a popup inviting you to authenticate with Twitter. Do so, and then run "Send a Test Tweet" again to see if it works. Errors will be recorded in the "log" sheet.
34
35
 Step 6: Check all the settings in the "Settings" tab.
36
Almost done! From the "Bot" menu above, select "Send a Test Tweet". If everything has been set up correctly, you should see a popup inviting you to authenticate with Twitter. Do so, and then run "Send a Test Tweet" again to see if it works.
37
38
 Step 7: Start posting!
39
Select "Start posting tweets" to apply and activate all of the settings. Once it's running, most changes will apply on the next scheduled tweet, but if you want to change the timing you'll have to stop and re-start it.
40