Export Twitter Friends and Followers v2.1.2 [Network Mod]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
AB
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
Benefits:
7
- 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
8
Instructions:
9
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
10


- 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)

11
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]
12
Advance Options
13
Only a selection of the data returned from Twitter is copied into the spreadsheet, below are all the possible column headers you can use.
14
contributors_enabled
15
created_at
16
description
17
favourites_count
18
follow_request_sent
19
followers_count
20
following
21
friendsYou'll need to remove // from line 218 in the Script Editor
22
friends_count
23
geo_enabled
24
id
25
id_str
26
is_translator
27
lang
28
listed_count
29
location
30
name
31
notifications
32
profile_background_color
33
profile_background_image_url
34
profile_background_tile
35
profile_image_url
36
profile_link
37
profile_link_color
38
profile_sidebar_border_color
39
profile_sidebar_fill_color
40
profile_text_color
41
profile_use_background_image
42
protected
43
screen_name
44
show_all_inline_media
45
status
46
status_contributors
47
status_coordinates
48
status_created_at
49
status_favorited
50
status_geo
51
status_id
52
status_id_str
53
status_in_reply_to_screen_name
54
status_in_reply_to_status_id
55
status_in_reply_to_status_id_str
56
status_in_reply_to_user_id
57
status_in_reply_to_user_id_str
58
status_place
59
status_retweet_count
60
status_retweeted
61
status_source
62
status_text
63
status_truncated
64
statuses_count
65
time_zone
66
url
67
utc_offset
68
verified
Loading...
 
 
 
Readme
TMP
combined
Vertices
SNA Metrics
Edges