Shorten Long URLs in Google Sheets with the OS_BITLY_SHORTEN Function

Introduction

If you are looking for a quick way to shorten long urls in Google Sheets, you’ve come to the right place. With this new custom function OS_BITLY_SHORTEN from OneScript, you can easily process them in Google Sheets.

Installation

Install from Google Workspace Marketplace

YouTube

If you're more of a visual learner, watch this video for step-by-step instructions. While you're there, consider subscribing to my channel for future updates and content.

Bitly Access Token

To use this function for the first time, obtain an access token from your Bitly account. This token can be entered and saved in the APIs section of the OneScript sidebar, accessible via the "more" button.

https://app.bitly.com/settings/api/

Demo Use Case

This tutorial demonstrates how to generate a shortened URL using the Bitly platform. While the default domain for Bitly is used here, you have the option to utilize your own custom domain if it's configured within your Bitly account.

Example

OS_BITLY_SHORTEN("https://www.onescript.work/long_url", "bit.ly")

About

Converts a long url to a Bitlink. (Generate your own access token here https://app.bitly.com/settings/api)

---

long_url

The long url to short

domain

Your custom domain or bit.ly will be used

* You will need to generate a bitly access token in your account to use the formula.

OneScript Custom Functions (Follow for More Updates)

Links

Hire Me on Upwork Donate YouTube Github Twitter / X Instagram Upwork Projects