How to use Bitly API to shorten urls using Bots-Task?

AppSheet AppSheet Q&A
,
1

3X_b_a_ba625db66c1691e4d4f9045cfb9025f25e45ab70.png
3X_b_a_ba625db66c1691e4d4f9045cfb9025f25e45ab70.png571×615 28.2 KB

edit: Body includes “long_url”: “link” as well
Using several posts from the community itself and Bitly Documentation, I tried that but got this:
“Exception”: "Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request. ",

I am still new to how webhooks and API work. Please help me out (and others who may need it!)

Note: This part is still just to sent to Bitly to shorten. I honestly have no clue on how to receive the output from Bitly and replace the long URL with the shortened Bitly.

2nd Note: I used Integromat, Zapier, etc. before but the waiting/execution time in their free plan is 15 mins, which is not suitable with my intention. And their 2 mins execution time is too costly and won’t generate that much links for now.

2

Keima_John:

I honestly have no clue on how to receive the output from Bitly

Not possible.

1 Like
3

Thanks for getting back so quick!
So, does that mean it is not possible to shorten URLs directly? (for now)

4

Keima_John:

So, does that mean it is not possible to shorten URLs directly?

It can be done using google sheets itself, there are even some examples online if you search for them as “bitly shorten links google sheets”

2 Likes
5

Keima_John:

So, does that mean it is not possible to shorten URLs directly? (for now)

Correct.