How to Shorten URL from Microsoft Excel via Bitly Using Pabbly Connect

Learn how to shorten URLs from Microsoft Excel using Bitly through Pabbly Connect in this detailed tutorial. Step-by-step instructions included. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for URL Shortening

To shorten URLs from Microsoft Excel via Bitly, we first need to access Pabbly Connect. Begin by searching for Pabbly Connect in your browser and navigate to the landing page. Here, you can either sign in if you already have an account or sign up for free to get started.

Once logged in, you will see various tools offered by Pabbly. Select Pabbly Connect to initiate the integration process. Click on the ‘Access Now’ button to open your dashboard, where you can create a new workflow for shortening URLs.

2. Creating a Workflow in Pabbly Connect

In this step, we will create a new workflow in Pabbly Connect specifically for shortening URLs. Click on the ‘Create Workflow’ button and provide a name for your workflow, such as ‘How to Shorten URL from Microsoft Excel via Bitly.’ Choose a folder to save your workflow, like ‘Automations,’ and click on ‘Create.’

• Name your workflow appropriately.
• Select a folder for organization.
• Click ‘Create’ to proceed.

Now, you’ll be directed to the workflow window where you can set up triggers and actions. The trigger will be Microsoft Excel, and the action will be Bitly. This setup allows you to automate the process of shortening URLs as soon as new data is added to your Excel sheet.

3. Setting Up the Trigger in Pabbly Connect

The next step involves setting up the trigger in Pabbly Connect. Search for Microsoft Excel and select it as your trigger application. Choose the trigger event as ‘New Row in Worksheet.’ This means that every time a new row is updated in your Excel sheet, the workflow will be triggered.

Click on ‘Connect’ to establish a connection with your Microsoft Excel account. If you haven’t connected your account before, select ‘Add a New Connection’ and follow the prompts to allow Pabbly Connect access to your Excel data. Once connected, specify the workbook and worksheet names where your video details are stored.

4. Shortening URL with Bitly via Pabbly Connect

After successfully setting up the trigger, it’s time to configure the action using Pabbly Connect. Search for Bitly and select it as your action application. Choose the action event as ‘Shorten Link.’ This will allow Pabbly Connect to take the long URL from your Excel sheet and shorten it using Bitly.

• Select Bitly as the action application.
• Choose ‘Shorten Link’ as the action event.
• Connect your Bitly account by allowing necessary permissions.

Once you’ve mapped the long URL from the previous step, click on ‘Save and Send Test Request’ to verify the integration. If successful, you will see the shortened URL generated by Bitly, confirming that the action step is complete.

5. Adding Shortened URL Back to Excel via Pabbly Connect

Finally, to complete the process, we will add the shortened URL back to Microsoft Excel using Pabbly Connect. Again, select Microsoft Excel as the action application and this time choose ‘Add Row to Worksheet’ as the action event. Connect to your Excel account once more, ensuring you are linked to the correct workbook and worksheet.

Map the video title, video URL, and the shortened URL from Bitly to the corresponding fields in your Excel sheet. After mapping, click ‘Save and Send Test Request’ to add the new row with the shortened URL into your worksheet. A successful response will indicate that the details have been added correctly.

Conclusion

In this tutorial, we learned how to shorten URLs from Microsoft Excel using Bitly through Pabbly Connect. By following the steps outlined, you can automate the process of URL shortening seamlessly. This integration not only saves time but also enhances your data management efficiency.