Rebrandly has a Google Sheets Add-on that you can install and use to import links directly from a Google spreadsheet. There are some pros and cons to using this method.
A few things to note before you start:
You must have a branded domain set up and added to a workspace in Rebrandly.
We don't recommend this method for more than 1,000 links, because it can be slower than uploading a CSV file manually.
You will need to generate an API key in your Rebrandly settings.
You can only create as many links as your subscription plan allows. Click on Usage in the Rebrandly navigation to check your plan limits.
To import your links:
Go to the Rebrandly listing in the Google Workspace Marketplace.
Click Install and follow Google's confirmation steps.
When the installation is complete, create a new empty Google Sheet.
Do not open a document with your links in it. All data will be deleted and overwritten.
Click Extensions in the menu bar.
Click Rebrandly.
Click Make this a Rebrandly Bulk Links sheet.
Click Yes to confirm the sheet is empty.
You'll see that new fields will be added to the spreadsheet, and a menu panel will open on the right.
Paste a Rebrandly API key into the first field. You can generate an API key in your Rebrandly account settings. For more details, see How do I create a Rebrandly API key?
In the menu panel, click Sync API key with sheet. This will retrieve your workspaces and domains from Rebrandly.
In the panel, select the workspace where you want to create your links.
Select the domain you would like to use for your branded links.
Paste the URLs to be shortened in the Destinations LInks column. These can include UTM parameters. This information is required. If https is left out, we'll assume the http protocol.
To customize the back half of each branded link, enter the unique back half for each link in the Slashtag column. You can leave this blank for Rebrandly to generate a unique random string for you.
To help identify your links in Rebrandly, you can also add titles to them. This is also optional.
Select the rows of links you would like to shorten and click Rebrand selected rows.
The branded links will appear in the Shortened column. If there are problems with any of them, an error will appear in red in the next column.
You can now copy and share your links!