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!
Hey, great little app. Like it, very useful 
My review = 
Clean and simple! Can be very useful.
Can we use this with the Deep links of Glide somehow?
I imagine yes but there will be a little lag.
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.
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!
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
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.
Regarding the discussion on Twitter with @eltintero and me, I found a working solution with TinyURL so I think it might help.
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.
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!
Those are handled in my script above, because the formula lives in the script, not in the cells 
Please tell me if you have access to the script in the Sheets, I think you can view it.
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!
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.
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?
Hi Christoph, actually I have not applied it that much since Sept, how long does it take to be updated to Glide?
