How To Auto Shorten New Blog Posts And Add Them To A Sheet?

How To Auto Shorten New Blog Posts And Add Them To A Sheet?

Do you like to shorten your links? And are you looking for ways to automatically shorten them? Well, in this post I am going to show you how to do just that.


Why shorten URLs?

Sometimes URLs are just too long and ugly looking, so it's better to have a short URL that is more simple to share and better to look at. With Bitly you can not just shorten your URLS but also give your URLs and unique name.

Bitly uses the short "bit.ly" domain, so every link that you shorten will use this domain. For example, my blog www.libertyondemand.biz, when shortened the URL will become: https://bit.ly/3oMMjX:

If you don't like the last part, you can even change it to something like, https://bit.ly/libertyondemand.

And if you upgrade to the pro version you can even change the domain that is being used to your own. For example, I could be using lib.biz or something similar.

The best part about Bitly is that it keeps track of all the clicks. And for each link you get analytics as well, like time stamps, referrers, locations.

In the next part I show you how to automatically create Bitly links every time you post a new blogpost.


Turn all new blog posts into Bitly links

The best way to do this is by using a tool like Make (formerly known as Integromat). This tool is one of the best in the market when it comes to automation. You will get a simple interface but many advanced options to create complex automations.

Create Bitly account
First, make sure you have a Bitly account. The free version lets you create 1,000 links per month. If that isn't enough you have to upgrade, prices starting at 29,- per month.

Create Make account
Next, create an Make account, if you already have an Integromat account, you can keep using it till 2023. Or you can switch to Make, which is simple and quick. (you can keep your old scenarios). 

I strongly suggest you upgrade to the Pro version, as this will give you 10x more volume each month. The free version is fine if you want to only post once or twice per day.


Also Read: 1300+ Profile Creation Backlink Sites For SEO - High DA List


Create an new scenario
Now you have to create an new scenario, simply click the blue button in the top right corner, “create a new scenario

Then click on the blue circle in the middle and search for RSS. Under "URL", paste the URL of your website's RSS feed. If you don't know how to find it, you can use the Chrome extension “Get RSS Feed URL

After that you have to choose where to start, mostly I will choose all items. Now click ok.


Add another module, by hovering over the RSS module you will notice a small + symbol. Click it and search for Bitly. Choose “shorten URL” and connect your Bitly account.

After you have connected your Bitly account you have to choose which URL has to be shortened. Click in the input field under “Long URL”, and a window will pop up with various options. It will show you everything that Make discovered in the RSS feed. Choose “URL” and make sure it's actually the post URL.



Now you can test if it works, click “Run once”. Does the new URL show up in Bitly? Is it the correct URL? After you have verified it's all correctly working, you have to choose how often the scenario has to run. By default this is every 15 minutes. Chance it too 1440 to run it once per day.

Turn on the scenario.

And you're done, in the end it should look like this:

Final result, RSS to Bitly using Make (integromat)

Now everyday Make will automatically create Bitly links from your latest blog posts. You can play around with Make and choose the settings that best suit you.


Also Read: How To Extract All The Links On a Webpage And Export Them?


How to Automatically add Bitly links to an Excel Sheet?


Now that you set up Make to automatically create shortened Bitly links, we can also add them to an excel sheet.

We will use Google Sheet for this tutorial, but you can also use Microsoft 365 excel, or other apps.

We can either create a new scenario, or, which is the best part when using Make, we can use the same scenario. Like I said before, you can create very advanced automations with Make.

First, you have to go to Google Sheets and create a new sheet document. Name it whatever you want, and you can also add table headers. Make will automatically find the headers you gave them. I created a simple sheet as seen below. But you can create it however you want.

Create an new google sheet

After you created your sheet click again on the small + icon next to the Bitly app. And search for Google Sheets. Click “add a Row” and then Connect with Google Sheets. Now you have to find the correct sheet and add the correct items per input. 

See the screenshot below for an example. 

add the correct values per input

It might be a little different for you, because your RSS feed or Google Sheet is different. But It should be fairly straightforward.

If everything seems alright, click ok, and again test the scenario by clicking the "Run once" button. Does the data show up in your excel sheet? You can add more columns if you want, like the categories or author, it depends on you.

If everything is working fine, in the end your scenario should look similar as shown in the screenshot below.

Final result, RSS to Bitly, and Bitly to google sheets 

And from now on, every time you post a new article, it will be first shortened and then added to Google sheets.

Please note, as far as I know Make doesn't give you the option to give Bitly links unique names. This would be something you have to do manually.


Also Read: 15 Powerful Tools To Automate Your Online Business


What are the benefits of this?

First, you will save a lot of time, especially for small business owners. It can be frustrating to always have to manually input data, and what if you forget it, or make mistakes? Your data might be incorrect or incomplete.

But if you use Make, and automate these processes, the data will always be the same as your blogpost, eliminating the chances of making mistakes. This will give you more freedom to focus on building your business.


Can you also do this if you are a Medium blogger?

You might wonder, is this also possible for Medium bloggers? And the answer is yes, it is. Remember, we use an RSS feed to auto post. So all you have to do is find your Medium RSS feed.

For example, this is my Medium RSS feed: https://medium.com/feed/@ronhoekstra. So all you have to do is take the first part of the Medium url https://medium.com/feed/ and add your own username behind it “@Yourusername”. And voila, now your medium posts are shortened and added to an excel sheet.


____________

Your subscription could not be saved. Please try again.
Your subscription has been successful.

JOIN THE NEWSLETTER

Subscribe to our newsletter and stay updated.

Ron Hoekstra is the founder of The Liberty OnDemand. With his many years of experience in the field of graphic design and self taught knowledge about business, digital marketing and leveraging wealth. He can give you valuable insights and content to help you grow and become more successful!


MORE CONTENT LIKE THIS: