Out in the Twitter sphere..
November 11, 2016 10:54 AM Subscribe
Are there any tools available for non-technical people that would enable to scrape owned Twitter content (all the tweets that are attributed to a handle)? I know there are ways for more tech savvy folks to tap into Twitter API, however, is there a service (free or paid) that would enable non tech people to load in a bunch of Twitter URLs and get a spreadsheet of tweets? Your input is very much appreciated!
Archive-It from the Internet Archive (nb: I work there) does this but mostly for cultural heritage institutions. This thing used to work and maybe doesn't anymore but you can check with the MeFite who made it. Here's a Quora question with some other suggestions.
posted by jessamyn at 11:05 AM on November 11, 2016
posted by jessamyn at 11:05 AM on November 11, 2016
If you mean owned as in you have ownership or access (username/password) to the account in question, you can request your Twitter archive with a button at the bottom of your settings page.
If you don't have login access to the account in question, Sprout Social can't help you. I use it for work and you can pull reports of your tweets but not those of other accounts
posted by misskaz at 11:27 AM on November 11, 2016 [1 favorite]
If you don't have login access to the account in question, Sprout Social can't help you. I use it for work and you can pull reports of your tweets but not those of other accounts
posted by misskaz at 11:27 AM on November 11, 2016 [1 favorite]
You can do this with Zapier or IFTTT. Probably for free for a small/medium number of owned tweets.
For Zapier, you'd trigger on Twitter (User Tweet - Triggers when a specific user tweets). Then you'd tell Zapier to write the Tweet details into a Google Sheet spreadsheet row (or somewhere else, they have hundreds of integrations).
posted by reeddavid at 11:44 AM on November 11, 2016
For Zapier, you'd trigger on Twitter (User Tweet - Triggers when a specific user tweets). Then you'd tell Zapier to write the Tweet details into a Google Sheet spreadsheet row (or somewhere else, they have hundreds of integrations).
posted by reeddavid at 11:44 AM on November 11, 2016
Yeah, what does "owned" mean here? If you own(or at least have login access to) the accounts, then request your archive. The tweets themselves are actually in a CSV, which you should be able to load into any spreadsheet program and use/convert as desired.
If you use Google's apps, Martin Hawksey's TAGS might be a good option for you. You'll need to authorize it as a Twitter app, and then it'll handle anything you can express as a Twitter search. So in this case, you'd tell it to fetch "from:mooselini" for example. It has an option to run periodically, if you need it to also archive posts going forward.
(This is subject to API limitations, as will be basically anything else you come across.)
posted by Su at 1:35 PM on November 11, 2016
If you use Google's apps, Martin Hawksey's TAGS might be a good option for you. You'll need to authorize it as a Twitter app, and then it'll handle anything you can express as a Twitter search. So in this case, you'd tell it to fetch "from:mooselini" for example. It has an option to run periodically, if you need it to also archive posts going forward.
(This is subject to API limitations, as will be basically anything else you come across.)
posted by Su at 1:35 PM on November 11, 2016
You should be able to do it with Google Sheets too. I've seen how-tos online, should be findable with Google.
posted by COD at 2:20 PM on November 11, 2016
posted by COD at 2:20 PM on November 11, 2016
This thread is closed to new comments.
posted by Hermione Granger at 11:01 AM on November 11, 2016