Hot answers tagged

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) ...
user avatar
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 ...
user avatar
  • 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 > ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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.
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 3,669

Only top scored, non community-wiki answers of a minimum length are eligible