A | B | |
---|---|---|
1 | Export Twitter Friends and Followers v3.1 | |
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 | Benefits: | |
7 | - Control - You register for your own API key with Twitter so you have full control of the account - 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 | |
8 | Instructions: | |
9 | Make your own Copy | |
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. 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 | ||
15 | Only a selection of the data returned from Twitter is copied into the spreadsheet, below are all the possible column headers you can use. | |
16 | contributors_enabled | |
17 | created_at | |
18 | description | |
19 | favourites_count | |
20 | follow_request_sent | |
21 | followers_count | |
22 | following | |
23 | friends | You'll need to remove // from line 218 in the Script Editor |
24 | friends_count | |
25 | geo_enabled | |
26 | id | |
27 | id_str | |
28 | is_translator | |
29 | lang | |
30 | listed_count | |
31 | location | |
32 | name | |
33 | notifications | |
34 | profile_background_color | |
35 | profile_background_image_url | |
36 | profile_background_tile | |
37 | profile_image_url | |
38 | profile_link | |
39 | profile_link_color | |
40 | profile_sidebar_border_color | |
41 | profile_sidebar_fill_color | |
42 | profile_text_color | |
43 | profile_use_background_image | |
44 | protected | |
45 | screen_name | |
46 | show_all_inline_media | |
47 | status | |
48 | status_contributors | |
49 | status_coordinates | |
50 | status_created_at | |
51 | status_favorited | |
52 | status_geo | |
53 | status_id | |
54 | status_id_str | |
55 | status_in_reply_to_screen_name | |
56 | status_in_reply_to_status_id | |
57 | status_in_reply_to_status_id_str | |
58 | status_in_reply_to_user_id | |
59 | status_in_reply_to_user_id_str | |
60 | status_place | |
61 | status_retweet_count | |
62 | status_retweeted | |
63 | status_source | |
64 | status_text | |
65 | status_truncated | |
66 | statuses_count | |
67 | time_zone | |
68 | url | |
69 | utc_offset | |
70 | verified |