Skip to content

Instantly share code, notes, and snippets.

@varmais
Created July 15, 2014 17:36
Show Gist options
  • Save varmais/0cf0ac4ed5f011418732 to your computer and use it in GitHub Desktop.
Save varmais/0cf0ac4ed5f011418732 to your computer and use it in GitHub Desktop.
Random Tweet Bot
#!/usr/bin/env python
import gspread, tweepy, random, sys
CONSUMER_KEY = "TWITTER_CONSUMER_KEY"
CONSUMER_SEC = "TWITTER_CONSUMER_SECRET"
ACCESS_KEY = "TWITTER_ACCESS_KEY"
ACCESS_SEC = "TWITTER_ACCESS_SECRET"
GOOGLE_USER = "GOOGLE_USERNAME"
GOOGLE_PASS = "GOOGLE_PASSWORD"
DOCUMENT_NAME = "GOOGLE_SPREADSHEET_NAME"
auth = tweepy.OAuthHandler(CONSUMER_KEY, CONSUMER_SEC)
auth.set_access_token(ACCESS_KEY, ACCESS_SEC)
api = tweepy.API(auth)
gc = gspread.login(GOOGLE_USER, GOOGLE_PASS)
sheet = gc.open(DOCUMENT_NAME).sheet1
values = sheet.col_values(1)
api.update_status(random.choice(values))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment