How to Shorten URL from Google Sheets via Bitly Using Pabbly Connect

Learn how to shorten URLs from Google Sheets using Bitly through Pabbly Connect in this detailed step-by-step tutorial. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for URL Shortening

To shorten URLs from Google Sheets via Bitly, first, you need to access Pabbly Connect. This platform allows seamless integration between Google Sheets and Bitly.

Begin by signing into your Pabbly Connect account. If you are a new user, you can sign up for free and enjoy 100 tasks monthly. After logging in, you will see the dashboard where you can start setting up your automation.

2. Creating a Workflow in Pabbly Connect

To create a workflow, click on the ‘Create Workflow’ button located in the top right corner of the dashboard. You will be prompted to name your workflow. Enter ‘Shorten URL from Google Sheets via Bitly’ as the workflow name. using Pabbly Connect

• Select a folder to save your workflow.
• Choose the folder named ‘Bitly Automations’.
• Click on the ‘Create’ button to finalize your workflow setup.

Now your workflow is created, and you will see two sections: Trigger and Action. The Trigger section defines when the automation will start, while the Action section outlines what will happen as a result.

3. Setting Up the Trigger with Google Sheets

In this step, we will configure the trigger to activate when a new row is added to Google Sheets. Click on the Trigger application and select Google Sheets as your trigger app.

For the trigger event, choose ‘New or Updated Spreadsheet Row’. This means that whenever you add a new video title and URL in Google Sheets, Pabbly Connect will capture this data.

• Copy the webhook URL provided by Pabbly Connect.
• Open your Google Sheets and click on ‘Extensions’.
• Select ‘Add-ons’ and then ‘Get Add-ons’ to install the Pabbly Connect Webhooks add-on.

After installation, go back to Extensions, select Pabbly Connect Webhooks, and click on ‘Initial Setup’. Paste the copied webhook URL and set the trigger column to the one where your final data will be added.

4. Setting Up the Action Step with Bitly

Next, we need to set up the action step that will shorten the URL using Bitly. Select Bitly as your action application and choose the action event ‘Shorten Link’.

To connect Bitly with Pabbly Connect, click on ‘Connect’ and then ‘Add New Connection’. After authorizing, you will need to select the group and map the long URL from the previous step.

Select the group you wish to associate the shortened URL with. Map the long URL from the previous response to the action step. Click on ‘Save and Send Test Request’ to generate the shortened link.

Once the shortened link is generated, you can verify it by pasting it into a new tab. This confirms that the integration is working successfully.

5. Updating Google Sheets with the Shortened URL

Finally, we need to update the Google Sheets with the shortened URL. Click on the plus button to add another action step and select Google Sheets as the action application.

For the action event, choose ‘Update Row’ and connect to your Google Sheets account. Select the spreadsheet and the specific sheet where you want to update the data.

Map the row index from the previous step to identify which row to update. Map the shortened URL to the corresponding column in your Google Sheets. Click on ‘Save and Send Test Request’ to finalize the update.

After completing these steps, check your Google Sheets to see the updated shortened URL in place of the original URL, confirming that the integration through Pabbly Connect has worked as intended.

Conclusion

This tutorial demonstrated how to shorten URLs from Google Sheets via Bitly using Pabbly Connect. With these steps, you can automate your workflow and save time efficiently.