Watch Step By Step Video Tutorial Below

1. Overview of Google Sheets and Bitly Integration

Google Sheets is a powerful spreadsheet tool, while Bitly is a well-known URL shortening service. Integrating these applications can streamline your workflow significantly.

This guide will show how to automatically shorten lengthy URLs entered in Google Sheets using Bitly through Pabbly Connect. The shortened URL will be placed in an adjacent column.

2. Setting Up Pabbly Connect

To begin, visit the Pabbly Connect website and sign in to your account. If you don’t have an account, it only takes a couple of minutes to create one.

Once logged in, navigate to the “Connect” section and click on “Create Workflow.” Name your workflow something like “Google Sheets to Bitly” to keep things organized.

3. Configuring Google Sheets as a Trigger

In the trigger window, change the application to Google Sheets. For the method, select “New Spreadsheet Row” to trigger the workflow when a new URL is added.

Ensure that your Google Sheet is set up with the first column for names, the second for lengthy URLs, and the third for shortened URLs. This structure is crucial for the integration to work smoothly.

4. Integrating Bitly for URL Shortening

After configuring Google Sheets, you will set up Bitly for shortening the URLs. Click the plus button to add an action and choose Bitly from the application list.

Select the method as “Shorten Link”. Connect your Bitly account and authorize Pabbly Connect to access it. This allows the tool to generate shortened URLs on your behalf.

5. Sending Shortened URLs Back to Google Sheets

Once you have the shortened URL, you need to update your Google Sheet. Add another action to look up the rows in Google Sheets.

Map the necessary columns, ensuring that you indicate which column contains the lengthy URL. You will then set the action to update the adjacent column with the shortened URL.

This process allows the shortened URLs to automatically populate in the designated column whenever a new lengthy URL is added.

Conclusion

This guide details how to integrate Google Sheets with Bitly using Pabbly Connect, allowing for automatic URL shortening directly within your spreadsheet.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.