Script to find Twitter handles and then search them for key words

Budget $100 - $250 AUD
Bids 6
Average Bid $0
Status Closed


There are two separate tasks within this project. Your bid should of course cover both tasks.

Task 1

We need you to, using the Twitter API and Search feature as much as possible, write a script to obtain a list of Twitter users. We will provide you with a list of search terms. For example, the set of search terms may be this:

Search Terms=[Kings of Leon, Sydney FC, Keith Urban, The Black Eyed Peas]

You need to write a script which will do the following:

1. Search for each Search Terms element, one at a time

2. Taking the top (first) search result, capture the following information and write it to an Excel file the following information:

a. Twitter Name (e.g. Kings of Leon)

b. Twitter Handle (e.g. @KingsofLeon)

c. Verified (If Verified [which is demonstrated by a white tick inside a blue star], enter “Yes”, otherwise enter “No”)

3. Taking the top (second) search result, capture the same information as in step 2.

4. Repeat steps 1-3, until every element in Search Terms has been searched for.

Note, how exactly you loop through those steps is of course up to you - we just need to make sure we have searched through all search terms, and have captured the output in the Excel sheet.

The Excel spreadsheet would then have only 3 columns. Column A would be Twitter Name, Column B would be Twitter Handle and Column C would be Verified.

Once Task 1 is completed, and we have our fully functioning and accurate Excel database of Twitter accounts, we can then move on to Task 2.

Task 2

We require someone to, using the Twitter API and Twitter Search as much as possible, create a script which will search a series of pre-defined Twitter accounts (the results of Task 1 above) for a series of pre-defined keywords. The script will then need to place this information into a simple SQL database. We will provide more details of what exactly we need here to the winning bidder.

For example, the set of Twitter accounts (found in Task 1) may be the following:

Twitter Accounts=[@kingsofleon, @SydneyFC, @KeithUrban, @bep]

And the set of keywords may be the following:

Keywords=[Australia, Sydney, happy, silly, event, today, soon, announced]

Your script would then need to be able to search through all the Tweets from the Twitter Accounts and test if any element in Keywords are found within the Tweets. We would run this script on some periodic basis (probably daily), and so the script would need to only report any new Tweets that have been generated since the last time the script was run.

In your bid, please write “I am a human” somewhere, and also the write the capital of France in capital letters at the end of your bid.

Please also ask any clarifying questions before submitting a bid, by sending us a message.

Get Free Quotes For A Project Like This

This project was awarded to


My best experience to date with a developer on any of these project boards. First of all he thoroughly reviewed the project before bidding unlike most and he figured out the optimal solution and presented it in the bidding process. He went above and beyond the specification. The project was complete within 24 hours and worked flawlessly the first time that I ran it. I will definitely work with iDivya again and recommend him. Exceeded my expectatiosn - Just a fantastic job.
About the Freelancer
iDivya Profile Picture

BOTS: --------- Customised windows bots Efficient web-spiders Windows software Automation tools for social networks & marketing Expertise in Windows automation, Selenium, Awesomium, Phantom JS, GeckoFx WRITING: ------------- Articles Creative writing Re-writing Ghost-writing

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work