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?

  • 2
    You have to build it yourself. For all the recent changes in Twitter API, most developers are leaving this platform. Chances are very less that someone would build this now.
    – Bibhas
    Commented Aug 14, 2013 at 15:51
  • 1
    is posible, using tags... look at this > mashe.hawksey.info/2013/02/twitter-archive-tagsv5
    – user46729
    Commented Aug 31, 2013 at 2:01

1 Answer 1


[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]


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.