import tweepy 
import csv
import openpyxl

    consumer_key = Secret
    consumer_secret = Secret
    access_key = Secret
    access_secret = Secret

# This is where i "think" i use the "FOR" loop, but freely admit to being lost
    def get_all_tweets(screen_name):

    auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
    auth.set_access_token(access_key, access_secret)
    api = tweepy.API(auth)
    #Limit tweets to last 20 *modifiable*
    for tweet in tweepy.Cursor(api.search, q="google", rpp=1, count=20, result_type="recent", include_entities=True, lang="en") .items(20):


    alltweets = []

#First instance of screen_name being repeated, however i assume i simply change screen_name= to whatever the for loop is up on line 11
    new_tweets = api.user_timeline(screen_name = screen_name,count=200)


    alltweets.extend(new_tweets)


    oldest = alltweets[-1].id - 1


    while len(new_tweets) > 0:
    print "getting tweets before %s" % (oldest)

#Second instance of screen_name being repeated, however i assume i simply change screen_name= to whatever the for loop is up on line 11
    new_tweets = api.user_timeline(screen_name = screen_name,count=200,max_id=oldest)

    alltweets.extend(new_tweets)


    oldest = alltweets[-1].id - 1

    print "...%s tweets downloaded so far" % (len(alltweets))

# Hashtag modifiers to drill further into tweets content
    outtweets = [[tweet.id_str, tweet.created_at, tweet.text.encode("utf-8")]for tweet in alltweets if '#firsttag' if 'secondtag' in tweet.text.encode("utf-8")]

#I want to create a CSV file, that will dump all records into ScrapingFile.csv once it has looped all names in ClientList.xlsx
#format will be name from Clientlist CellA1, then 20 tweets then name from ClientList Cell A2 (rinse repeat)
    with open('%s_tweets.csv' % ScrapingFile, 'wb') as f:
    writer = csv.writer(f)
    writer.writerow(["id","created_at","text","retweet_count","favorite_count"])
    writer.writerows(outtweets)

    pass


    if __name__ == '__main__':

#final instance of screen_name being repeated, however i assume i simply change screen_name= to whatever the for loop is up on line 11
    get_all_tweets("screen_name")