# Shortly - Free Custom URL Shortener App

**URL:** <https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708>\
**Category:** Project Showcase\
**Created:** [September 13, 2020, 1:27am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708 "2020-09-13T01:27:24Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 13, 2020, 1:27am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/1 "2020-09-13T01:27:24Z")

</div>

Hello again!

I was so happy with the response to my latest project that I decided to build a new one:

Shortly is a Free Custom URL shortener built using GooLNK API. You can create as many shortened links as you want and they remain saved so you can use it later.

Another super simple but useful app built in less than a day, hope you like it!

[https://shortly.glideapp.io/](https://shortly.glideapp.io/)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/855d0cbf476e7e16ece740d789ecef10bf1bb567.png)

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [September 13, 2020, 3:03am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/2 "2020-09-13T03:03:53Z")

</div>

Hey, great little app. Like it, very useful 👏

My review = ⭐ ⭐ ⭐ ⭐ ⭐

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [September 13, 2020, 3:41am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/3 "2020-09-13T03:41:06Z")

</div>

Clean and simple! Can be very useful.  
Can we use this with the Deep links of Glide somehow?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 13, 2020, 5:22am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/4 "2020-09-13T05:22:56Z")

</div>

I imagine yes but there will be a little lag.

---

<div class="post-metadata">

**Author:** ![Roberto\_Salim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roberto_salim/32/6861_2.png) [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)\
**Post date:** [September 13, 2020, 3:21pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/5 "2020-09-13T15:21:16Z")

</div>

Very interesting congratulations, could you tell me how to put login with Google on the button? I thought that in public applications enabled (sig in) on the button was not possible.

---

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 13, 2020, 4:20pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/6 "2020-09-13T16:20:25Z")

</div>

Thanks, @Rosewebstudio, very happy with your review.

I made some important bug corrections yesterday and some small layout changes.

The most important one: the url shortener would get an error if you input an url without “http://“ or “https://“, now i’ve implemented a formula to check if the link starts with http and automatically add it if not.

Enjoy!

---

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 13, 2020, 4:21pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/7 "2020-09-13T16:21:33Z")

</div>

Don’t know about the Glide Deeplinks, the last time I built something this wasn’t available and was a featured request from me haha

---

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 13, 2020, 4:23pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/8 "2020-09-13T16:23:59Z")

</div>

Hey @Roberto_Salim, thanks!! Sure, it’s a little bit hacky but works. I’ve changed the loin to public with email and added the option to use google login, than i loged in with my account and changed the privacy to public. Now, when i add a login button, it uses the configuration from the public with email.

---

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 14, 2020, 11:41pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/9 "2020-09-14T23:41:18Z")

</div>

Just added a new feature, now you can delete any short link that you don’t need anymore.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f6144b7d0de81bf7bceeb9147e086d96351c790f.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 15, 2020, 10:44am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/10 "2020-09-15T10:44:21Z")

</div>

Regarding the discussion on Twitter with @eltintero and me, I found a working solution with TinyURL so I think it might help.

> **[Thinh Dinh's lab V2.0](https://docs.google.com/spreadsheets/d/1JzBrp4R1zK9CMfmTzWWcPPep9-ZCl3OXxgWu27NWCy8/edit#gid=1366387171)**
>
> Robert Test
> 
> Project,Task,Project,Task,Combined
> A,siLxzsQURZK3QGl0Zhqg7w, yLz8ofPiQrC8Y6BYfpm.CQ,A,siLxzsQURZK3QGl0Zhqg7w,A - siLxzsQURZK3QGl0Zhqg7w
> jRzXZcVgQruv37w-gFQ6Kg, zp5bp3uIQoWwJYAH0a-vgQ,yLz8ofPiQrC8Y6BYfpm.CQ,...

Here’s my sheet for testing with TinyURL. Input any link to ColumnA to get the TinyURL link in column B.

Script also copy the value back to the same cell right after the formula runs to prevent multiple runs at the same time from IMPORTDATA when the user reloads the sheet, which might cause a bug/exceed script limit.

---

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 15, 2020, 2:55pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/11 "2020-09-15T14:55:28Z")

</div>

Thank you @ThinhDinh! I will test it later. I have just another question, I’ve made some changes to the script (the one from your tutorial) and now I’m using importxml to import domain data (Seems more reliable than import json).

But, I’m having some problems:

- Do you Know if there is a way to transform the cells using formula into text? My hypothesis is that this could speed up the app (Probably need to keep at least one row with the formula to use it with autofill.)

- The biggest problem now is handling autofill with delete feature. If the user responsible for the last url chooses to delete it, the autofill script stop working because the row above would be empty. Do you any possible solution?

Thanks again!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 15, 2020, 3:01pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/12 "2020-09-15T15:01:22Z")

</div>

Those are handled in my script above, because the formula lives in the script, not in the cells 😄

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 15, 2020, 3:01pm UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/13 "2020-09-15T15:01:39Z")

</div>

Please tell me if you have access to the script in the Sheets, I think you can view it.

---

<div class="post-metadata">

**Author:** ![ionamol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ionamol/32/1951_2.png) [@ionamol](https://community.glideapps.com/u/ionamol)\
**Post date:** [September 16, 2020, 12:22am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/14 "2020-09-16T00:22:51Z")

</div>

Thank you!! This is perfect, I have access to the script file and I just checked the TURLtest.gs and looks that is exactly what I need, I will test it soon and let you know!

Thanks again!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 16, 2020, 12:26am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/15 "2020-09-16T00:26:12Z")

</div>

My pleasure brother, this is gonna be big for scripts that generate distance/reverse geocode. Previously it’s too “sensitive” and reloads everything when the user opens the sheet. They quickly reach the daily limit.

---

<div class="post-metadata">

**Author:** ![christoph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christoph/32/22794_2.png) [@christoph](https://community.glideapps.com/u/christoph)\
**Post date:** [April 12, 2021, 10:01am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/16 "2021-04-12T10:01:26Z")

</div>

Cool idea.  
I’ve tried your function and noticed, that it takes quite some time until the cell with the shortened link will be updated. Have you experienced a similar behaviour?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 12, 2021, 11:13am UTC](https://community.glideapps.com/t/shortly-free-custom-url-shortener-app/15708/17 "2021-04-12T11:13:00Z")

</div>

Hi Christoph, actually I have not applied it that much since Sept, how long does it take to be updated to Glide?
