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) ...
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
4 votes
Accepted

Pull in analytics and click stats for goo.gl links in Google Sheets?

With the code below, you're able to insert the analytics information as well. Code var SHORT = "short", INFO = "info", LONG = ' long'; function onOpen() { SpreadsheetApp.getUi() .createMenu("...
2 votes

How to switch accounts in Google URL Shortener

The normal "switch account" option is not currently available with goo.gl. Here are some workarounds. Either sign out of all Google Accounts, then sign in with the account you want to use OR Open ...
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 ...
  • 51.3k
2 votes

How are my links being clicked already?

Your suspicion is probably correct: Google bot is following your links shortly after you created the short link. It makes sense. You've just told Google about a genuine link. Google didn't need to ...
  • 51.3k
1 vote
Accepted

Goo.gl URL Shortener Switch Accounts

Unfortunately, Google Multi-login doesn't work with all Google applications, as you've discovered. Probably your best option to use goo.gl with multiple accounts is to use multiple browsers or, if ...
  • 51.3k
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

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