A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Export Twitter Friends and Followers v2.1.2 | |||||
2 | Created by mhawksey. Read more about this at: | |||||
3 | http://mashe.hawksey.info/2011/03/export-twitter-followers/ | |||||
4 | With this spreadsheet you can: | |||||
5 | - Export your Twitter Friends and Followers | |||||
6 | Updated version available here | |||||
7 | Benefits: | |||||
8 | - Control - You register for your own API key with Twitter so you have full control of the account - Automatic whitelisting – Twitter currently automatically whitelist applications built in Google Spreadsheets this means instead of 150 API request per hour you get 20,000 meaning you can export a lot - Playing with the data – as you are importing straight into a spreadsheet you can do all of your own data manipulation like sorting, filtering and creating your own formula for things like follow/follower ratios - Backup – Google Spreadsheets allow you to download copies of spreadsheets in different formats - Share – You can make your lists of friends/followers easily viewable | |||||
9 | Instructions: | |||||
10 | 1. Make a copy of this spreadsheet (File > Make a copy) < make sure you are logged in first or this option will be greyed out 2. In this spreadsheet from the Twitter drop-down menu (next to Help) select 'Configure'. You may need to run this twice, the first time to authorise the script and follow the instructions for obtaining a Customer Key and Secret from Twitter | |||||
11 | - If there is no Twitter menu option click on this button -> 3. Select Tools > Scripts > Script Editor ... and from the Script Editor window select Run > aTest. 4. This should bring up an authorization message box, click on Authorize. 5. In the Twitter Authorization window enter your login details if required and select 'Allow' 6. Close the Script Editor window and a dialog box in the main spreadsheet should indicate if you have successfully connected to Twitter 7. If all is okay you can now select Twitter > Get Followers and Twitter > Get Friends (when these run your sheet may go blank, if so refresh your browser window) | |||||
12 | If you get a 'Exceeded absolute-time timeout in milliseconds' error message there is a manual function in the script editor called getLotsOfFriendAndFo(). To use this clear any existing data imported to the particular sheet and enter the following details into the function in the script editor: sheetName – sheet name you want to import the data to; friendOrFo – whether you want ‘friends’ or ‘followers’; and optScreenName – the screen name of the person To run the script Run > getLotsOfFriendAndFo as many times as needed (the script will import 100 friends/followers at a time) or if you want to go away and make a cup of tea use Triggers > Current project triggers and add getLotsOfFriendAndFo as a time-driven function to run every minute (once you’ve finished your tea best to delete this trigger). If something goes wrong during the import you can start over manually deleting any data and running resetGetLotsOfFriendAndFo (this resets the cursor used with the Twitter API). [You can also get the Friends/Followers for other users using from the options in the Twitter menu] | |||||
13 | Advance Options | |||||
14 | Only a selection of the data returned from Twitter is copied into the spreadsheet, below are all the possible column headers you can use. | |||||
15 | contributors_enabled | |||||
16 | created_at | |||||
17 | description | |||||
18 | favourites_count | |||||
19 | follow_request_sent | |||||
20 | followers_count | |||||
21 | following | |||||
22 | friends | You'll need to remove // from line 218 in the Script Editor | ||||
23 | friends_count | |||||
24 | geo_enabled | |||||
25 | id | |||||
26 | id_str | |||||
27 | is_translator | |||||
28 | lang | |||||
29 | listed_count | |||||
30 | location | |||||
31 | name | |||||
32 | notifications | |||||
33 | profile_background_color | |||||
34 | profile_background_image_url | |||||
35 | profile_background_tile | |||||
36 | profile_image_url | |||||
37 | profile_link | |||||
38 | profile_link_color | |||||
39 | profile_sidebar_border_color | |||||
40 | profile_sidebar_fill_color | |||||
41 | profile_text_color | |||||
42 | profile_use_background_image | |||||
43 | protected | |||||
44 | screen_name | |||||
45 | show_all_inline_media | |||||
46 | status | |||||
47 | status_contributors | |||||
48 | status_coordinates | |||||
49 | status_created_at | |||||
50 | status_favorited | |||||
51 | status_geo | |||||
52 | status_id | |||||
53 | status_id_str | |||||
54 | status_in_reply_to_screen_name | |||||
55 | status_in_reply_to_status_id | |||||
56 | status_in_reply_to_status_id_str | |||||
57 | status_in_reply_to_user_id | |||||
58 | status_in_reply_to_user_id_str | |||||
59 | status_place | |||||
60 | status_retweet_count | |||||
61 | status_retweeted | |||||
62 | status_source | |||||
63 | status_text | |||||
64 | status_truncated | |||||
65 | statuses_count | |||||
66 | time_zone | |||||
67 | url | |||||
68 | utc_offset | |||||
69 | verified |