google sheetsgoogle-apps-scripttwittertwitter-api
I would like to set-up a Google Spreadsheet that automatically pulls Twitter search results into the cells. For instance, I'd like to search for "pizza" near "baltimore" and then have any pizza mentions near baltimore populate into my Google Spreadsheet.
Twitter has changed their API a couple times. I haven't found anything that works.
Any suggestions?
I would like to be able to add users to a twitter list without loading a separate page to find each user. So I would like to avoid going to their user page, but I'd also like to avoid having to load a page of search results (whether on twitter.com or on an external app) each time, as well.
Edit:
Twitter deprecated Twitter API v.1. So this info is also deprecated now. You can access the same api by using the URL https://api.twitter.com/1.1/search/tweets.json. Though this endpoint does not seem to be identical to the previous endpoint outlined before.
See Twiter API documentation for details.
Original Text:
As far as I know Twitter Search API is the best thing we've got as of now. And Twitter Search API supports searching timeline of any user. In fact "Search" text box of Twitter (at the top of Twitter page) uses the search API, so you can experiment using that search box.
For example searching
twitter from:yourusername
shows your tweets with word twitter .
You can use the same query for searching from your timeline, or from any users timeline. An API call identical to the example query would be
http://search.twitter.com/search.json?q=twitter%20from%3Ayourusername
Note that Twitter Search API has some limitations. They are discussed at Twitter Search API Documentation.
For searching tweets from a list, I am not aware of a quick solution. You can always use
https://api.twitter.com/1/lists/members.json?slug=listname&owner_screen_name=yourusername
to get list members and construct a query manually by using the OR keyword as:
http://search.twitter.com/search.json?q=twitter%20from%3Auser1%20OR%20from%3Auser2
Best Answer
[EDIT Disclosure: This answer is written by the TAGS author and includes links to his personal blog]
The Twitter Archiving Spreadsheet Template (TAGS) template mentioned in the question comments is one solution that has been continually developed to address Twitter API changes. This post will direct you to the latest version, alternatively Open this Spreadsheet and File > Make a copy and follow the setup instructions on the Readme/Setting sheet.
[The spreadsheet template has been used for a number of visualisation/analysis tools including TAGSExplorer and TAGSViewer] as well as tutorials such as 'Twitter Data for Really Targeted Outreach' and combining with Google Analytics referral data]