This little code makes it possible to create shortened URL's, with the use of Google Apps Script and the URL Shortener API.
Under resources in the script editor (Tools > Script editor) select the Advanced Google Services and activate the UrlShortener:
Then go to the Google Developers Console and select the URL for the API:
Enable the API ...
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 string the URL together.
The structure of the tinyurl API is http://tinyurl.com/api-create.php?url=YOURLINKHERE
IMPORT DATA from that link would obviously not go ...
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 > bbb. Choose apply
It now displays all the archived links with this tag, retag each link with your newly created tag, bbb, and remove the references to aaa
Hit the ...
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 of the target page
The shortened URL
The effective URL
An assessment of the safety of the site from Google using their Safe ...
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 points to a non existent URL.
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 with the same name, the URL is the same.)
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 should be migrated)
Consider using a URL shortening service such as bit.ly to get click data about a list of links. Here's how it would work:
You'd use ...