ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Full URLbit.ly Needed?Short URL
2
3
4
5
To use this script:
6
1. Make a copy of this spreadsheet (there is a script that will come with it)
7
2. Create a (free) account at bitly.com and get a Generic Access Token
8
3. Select Tools > Script Editor and paste in your access token
9
4. Click the Run triangle and accept all the dire warnings about the script.
10
11
Once you've completed the above, you can add URLs to the Full URL column. Then,
12
place an "X" in the bit.ly Needed? column for each URL for which you want a short
13
URL. Finally, click the GENERATE SHORT URLs button and watch the magic!
14
15
For questions/support (or adulation), tweet @analyticshour or email contact@analyticshour.io.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100