AB
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
friendsYou'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