How to Automatically Shorten URLs from MS Excel Using Pabbly Connect

Learn how to automatically shorten URLs from MS Excel using Pabbly Connect. Follow this step-by-step guide for seamless integration with bit.ly. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for URL Shortening

To start shortening URLs from MS Excel automatically, you first need to access Pabbly Connect. This platform allows you to integrate various applications seamlessly.

Begin by creating a free account at Pabbly Connect. Once you have signed up, log in to your account and navigate to the dashboard. From there, you can start creating your automation workflow.

2. Creating Your Automation Workflow in Pabbly Connect

In this section, we will set up a workflow in Pabbly Connect to automate the URL shortening process. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Automatically Shorten URLs Using Bitly’.

Next, you will see two boxes labeled Trigger and Action. The trigger will be set to Microsoft Excel, and the action will be Bitly. This setup means that whenever a new URL is added in Excel, it will trigger the shortening process in Bitly.

• Click on ‘Create’ after naming your workflow.
• Select Microsoft Excel as the first application.
• Choose the trigger event as ‘New Row in Worksheet’.

After setting the trigger, click on ‘Connect’ and authorize your Microsoft Excel account. Select the workbook that contains your long URLs, and ensure that the worksheet is correctly identified.

3. Adding Long URL to MS Excel

Now that your workflow is set up, you need to add a long URL to your MS Excel worksheet. This URL will be automatically picked up by Pabbly Connect for shortening.

For example, you can add the link ‘https://www.Pabbly.com/lifetime-deal’ to your Excel sheet. Once added, click on the ‘Save and Send Test Request’ button in Pabbly Connect. This action will capture the new data from your worksheet.

• Make sure the long URL is correctly formatted in Excel.
• Check the response received in Pabbly Connect to confirm that the URL has been captured.

Once you see the response, you are ready to move on to the next step, which is shortening the URL using Bitly.

4. Shortening the URL with Bitly

In this step, we will use Pabbly Connect to connect to Bitly and shorten the previously captured long URL. Click on the plus icon to add another action step and select Bitly as the application.

Choose the action event as ‘Shorten Link’. Again, click on ‘Connect’ and authorize your Bitly account. Once connected, you will be prompted to enter the long URL that needs to be shortened.

Map the long URL from the previous step in Pabbly Connect. Click on ‘Save and Send Test Request’ to shorten the URL.

Once the test is successful, you will receive a shortened URL from Bitly, which can be used in the next step of the workflow.

5. Adding the Shortened URL Back to MS Excel

Finally, we will add the shortened URL back to a separate Excel sheet using Pabbly Connect. Click on the plus icon again to add another action step and select Microsoft Excel.

Choose the action event as ‘Add Row to Worksheet’. Connect your Microsoft Excel account again, select the workbook for the shortened URLs, and map the necessary fields such as Link Title, Long URL, and Shortened URL from the previous steps.

Ensure all fields are correctly mapped in Pabbly Connect. Click on ‘Save and Send Test Request’ to add the data to Excel.

After refreshing your Excel sheet, you will see that the shortened URL has been added automatically. This completes the automation process using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automatically shorten URLs from MS Excel using Bitly. By following these steps, you can efficiently manage your URLs without manual intervention.

With Pabbly Connect, the integration between Excel and Bitly becomes seamless, allowing for automated URL shortening whenever you add a new link. This automation can significantly enhance your workflow and save time.