Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import gspread
- import os
- from oauth2client.service_account import ServiceAccountCredentials
- from time import sleep
- import tweepy
- import random
- from time import ctime
- def twitter_api():
- #twitter
- twitter_api_key = '7GfplAz0acQpQBqQxGeJfNuvR'
- twitter_api_key_secret = 'Xj5FzVofrfvgfJ21sjfidkuzWqadLbJyzkX1UKIswqC3hG4mdL'
- twitter_access_token = '1152633982149955585-Nstkg2PNDkUYXp21WmgKXYaxnPZhZa'
- twitter_access_token_secret = 'DNw9IIgRl0qySk9iN1hJYAQ1Jep1w4cJY9ejBtNv5pmYD'
- auth = tweepy.OAuthHandler(twitter_api_key, twitter_api_key_secret)
- auth.set_access_token(twitter_access_token, twitter_access_token_secret)
- twitter_api = tweepy.API(auth)
- return twitter_api
- def tweet_for_snick():
- #sheets
- scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
- creds = ServiceAccountCredentials.from_json_keyfile_name("/home/pi/DoodleBot/DoodleBot/doodle_bot_creds.json", scope)
- client = gspread.authorize(creds)
- sheet = client.open('DoodleBot').sheet1
- random_name = random.choice(sheet.col_values(1))
- random_state = random.choice(sheet.col_values(2))
- snick_tweet = random_name + ' ' + random_state
- return snick_tweet
- twitter_api = twitter_api()
- final_tweet = tweet_for_snick()
- twitter_api.update_status(final_tweet)
- print(final_tweet)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement