SSBot v 0.4
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCD
1
SSBot
2
A Twitter Bot Engine in Google Spreadsheets
3
version 0.4
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
Your account name here:
9
@austensays
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 apps.twitter.com. Create a new app with some basic initial settings:
13
14
Name:<Whatever you want but it 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:<Leave this blank for now>
18
19
Step 3: Complete and copy your App's settings.
20
Once the app is created, check its "Permissions" tab to make sure it's set to "Read/Write", then go to the "Keys and Access Tokens" tab. Hit the button to "Generate Access Token". Copy the "Consumer Key" and "Consumer Secret" values into these cells:
21
22
Consumer Key (API Key):
23
wjH8Nxbryq0I7cBbdWXNXXBeJ
24
25
Consumer Secret (API Secret):
26
igMHC7hcYwSnAfonM5ZeujOuS1sBaycrr5c2cyElh30zNO9fln
27
28
Step 4: Find your spreadsheet's "Project Key"
29
Go into the script editor ("Tools -> Script Editor...") and then find the project's properties under "File -> Project Properties". You should see a table there that includes a "Project Key" value. Paste that below.
30
31
Project Key:
32
M0UNJkass8Pm_ap2KQJPRs2E4P0fXt17w
33
34
Step 5: Set callback value in Twitter App settings
35
Return to the Twitter app settings (to get back to it: app.twitter.com and then open the App you just created), and enter the following URL in the "Callback URL" field.
36
Don't edit this field directly:
37
https://script.google.com/macros/d/M0UNJkass8Pm_ap2KQJPRs2E4P0fXt17w/usercallback
38
39
Step 6: Select your data sheet and generate a preview
40
Use the dropdown selector below to choose a data sheet. These sheets (tabs at the bottom) include four different basic bot genres, and each has its own set up instructions and potential considerations. You can always change it later, but generate a preview now so that you can authorize the Spreadsheet to run scripts.
41
42
Select which data sheet you want to use:
43
Select from Columns
44
45
Select "Generate Preview" from the "Bot" menu above, then switch to the "Preview Output" sheet (below) to see what it looks like.
46
47
Step 7: Complete and Test Twitter Authorization
48
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.
49
50
Step 8: Set your timing.
51
How often do you want your bot to tweet? Select the posting interval from the dropdown below:
52
53
Select timing:
54
1 hour
55
56
From the "Bot" menu, select "Start posting tweets".
57
Hopefully your bot is now running! You can add to the vocabulary and change the source sheet while it's running. The change will be reflected in the next tweet it sends out. If you want to stop posting for any reason, use the "Stop posting tweets" function from the "Bot" menu.
58
59
60
Loading...
 
 
 
Setup
Preview Output
Select from Columns
Select from Rows
Markov
_ebooks