12
votes
Google Sheets Function to get a shortened URL (from Bit.ly or goo.gl etc.)
This little code makes it possible to create shortened URL's, with the use of Google Apps Script and the URL Shortener API.
Prerequisites
Under resources in the script editor (Tools > Script editor) ...
8
votes
Google Sheets Function to get a shortened URL (from Bit.ly or goo.gl etc.)
TinyURL has an API that spits out a text file with the shortened link. If you use the IMPORT DATA function, you can grab the text from that page. You also need to use the CONCATENATE function to ...
- 176
3
votes
Accepted
How can I rename a tag in Bit.ly?
I do not believe you are able to rename the tag directly, so the workaround you need to do is the following to change the tag from aaa to bbb:
Change the filter to display Only archived and Tags > ...
- 511
2
votes
How can I be certain that a URL-shortened link I click isn't going to send me to a dangerous or unwanted site?
GetLinkInfo.com purports to work with "all" URL shorteners. Just drop the link in the field and press "Get Link Info".
If found, the site responds with:
The title of the target page
The description ...
- 51k
1
vote
Limiting access to a link in Bitly
Bit.ly links are permanent — you can’t delete them and you can’t restrict access to them.
I think your best option is to move the sheet (make a copy of it and then delete it), so that bit.ly link ...
- 22.2k
1
vote
Google Sheets Function to get a shortened URL (from Bit.ly or goo.gl etc.)
About the Bitly link http://dev.bitly.com/spreadsheets.html
You need to replace the A1 cell with the url you'd like to use.
It's also quite handy that they provide a way to fetch click count too.
- 111
1
vote
How can I publish a word document on the same URL but changing content from time to time?
A filing cabinet on Google Sites may work.
(Disclaimer: I haven't tested it, don't know it's subject to teh same issue that Drive apparently has - but I know that if you simply upload a new file ...
- 7,209
1
vote
Sort all my j.mp links by most clicked
Note: j.mp is actually bit.ly
You can use the Bitly API (link metrics) to get the number of clicks for each link.
I'm pasting here an answer from WebMasters on this topic:
(I think this question ...
- 3,669
Only top scored, non community-wiki answers of a minimum length are eligible