So I logged into my Google link shortening account the other day just to check out my links and the analytics and so forth and
I noticed that they have a new sign up there
Google are discontinuing their link shortening service as of March 2019.
I was devastated and I thought how am I gonna be able to get my analytics for all my links
So that's when I'd created a tool using Google sheets to easily convert over all my google short links into Bit.ly links
Stick around if you want to check out what I did and how you can do it too
Its TechWizTime
Hey guys Jonathan here with TechWizTime, where I create technology tutorial and review videos
In this video I'm gonna be going over the steps that I took to convert my google short links into bit.ly short links
And it is really quick and really easy actually
Before I go any further though, I just want to mention NordVPN
It's my new VPN of choice. Especially when it comes to circumventing
Media streaming services in other countries you know what I mean
So if you want to check them out and help out the channel, there is a link down in the description below
So I'll run you through quickly how you can export your links from Google and then import them into the Google sheet
Which will then automatically import them into bit.ly
So with that said, let's fire up the Google link shortening service at goo.gl
And you'll notice here that there is an export to CSV
So you want to click on that and what that will do is it'll export all your Google links into a CSV file
So once you've done that and you've got your CSV file you can do this one of two ways you can open it in Google Sheets itself by importing it, or
You can open it in Excel if you've got that on your computer
So I'm in Excel here and all you need to do is expand the column with the actual links in it and
Select those cells and make a copy
Now one of the things to note here is my sheet is limited to a hundred at a time so
Just be aware when you're copying your links
So the next thing you'll need to do is you'll need to click on this bitly link that I've provided down in the description below
To open up a shared version of my Google sheet
Now what you'll need to do here is once you've opened it up you'll need to make a copy of to your Google Drive
So to do that you go to the file menu and go make a copy
Of course make sure you logged into your Google account
So once you've made a copy, open up that one and now you'll be able to edit this
So two pieces of information you'll need here are from your bitly account so, make sure you've set one up already
Because we're gonna need a username and an API key
Now to get your API key from bitly what you'll need to do is log into your account
And up in the top right hand corner with a little icon with four lines are click onto that
Then click on settings
Then click on advanced settings
Then click on API support
Here you'll be given your login
And your API key
That you'll need to input into the Google sheet that you've just made a copy of
So once you've got those details in there
Maybe you might need to go back and copy those links again because it's probably overwritten
Copy those links, only up to a hundred, and then paste them
Into the "URL to shorten" column
Give this a little bit of time, but what it will do is it will go through and using the API access
Import all of those links into your bitly account
How awesome is that?
So now you didn't need to put all those in there at all you can put a name beside them just for your records, but
What will happen is Bit.ly will actually
Scrape those pages and have a look for what the name of the page is so all the hard work is done
So now you're able to track your bit.ly links, especially when Google stops you from tracking the analytics on your Google Short links in 2019
If this helped you make sure you leave me a comment down below and let me know because I know there's gonna be a lot youtubers out there and
Just general people that use Google short link
They're going to be affected by this so this is probably going to help quite a few people I think
Do you want to see more awesome tech gadget reviews and tutorials then
Make sure you subscribe to this channel and also hit the bell icon, so you get notified whenever I release a new video
Which is usually Monday and Friday depending on your time zone
With a new baby it can be a little bit mixed up, but that's my schedule at the moment
Did you like this video? Then make sure you give it a big thumbs up and also consider checking out my patreon campaign
Where you can help support my channel
You can help the community to grow here by sharing this video on Facebook groups, or even reddit
Actually especially reddit, reddit users are going to love this video
Also don't forget to check out these other awesome videos that have created here and as always
Imagine, Learn, Create
why Google why?