Learn how to automate the creation of Bitlinks for new OneDrive files using Pabbly Connect, Bitly, and Google Sheets in this detailed tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below


1. Accessing Pabbly Connect for Automation

To create Bitlinks for new OneDrive files, you first need to access Pabbly Connect. This platform allows you to automate workflows between different applications seamlessly.

Start by visiting the Pabbly Connect website and signing in to your account. If you are a new user, you can sign up for free and receive 100 free tasks each month. Once logged in, you will see the Pabbly Connect dashboard where you can begin creating your workflow.


2. Creating Your Workflow in Pabbly Connect

To set up your automation, you need to create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button in the top right corner. Name your workflow something descriptive, like ‘Create Bitlinks from New OneDrive Files with Bitly’.

  • Click on the drop-down arrow to select a folder for your workflow.
  • Choose a folder such as ‘Bitly Automations’.
  • After naming and selecting the folder, click on ‘Create’.

Now, your workflow is ready to be configured with a trigger and actions. Remember, the trigger indicates when the automation starts, while actions define what happens next.


3. Setting Up the Trigger with Microsoft OneDrive

The next step is to set up the trigger for your workflow using Pabbly Connect. Select Microsoft OneDrive as your trigger application and choose the event as ‘New File’. This ensures that whenever a new file is uploaded to OneDrive, it will trigger the workflow.

After selecting the trigger, click on ‘Connect’ to link your Microsoft OneDrive account with Pabbly Connect. You will be prompted to authorize the connection. Once authorized, specify the folder path where the new files will be uploaded.

  • Enter the folder path, excluding any unnecessary parent directory names.
  • Set the event type to ‘New File Created’.
  • Click on ‘Save and Send Test Request’ to check the connection.

Once you upload a file to the specified OneDrive folder, Pabbly Connect will capture the file details as a response, confirming that the trigger is working correctly.


Now that the trigger is set, the next action is to create a Bitlink using Bitly through Pabbly Connect. Select Bitly as your action application and choose ‘Create Bitlink’ as the action event.

Click on ‘Connect’ and authorize your Bitly account. After the connection is established, you will need to fill out the required fields, including the long URL you want to shorten. Map the long URL from the OneDrive trigger response to ensure it dynamically updates with each new file.

Provide a title for your Bitlink. Copy the domain from the help desk provided in Pabbly Connect. Click on ‘Save and Send Test Request’ to create the Bitlink.

After successfully creating the Bitlink, you will receive a positive response, including the shortened URL that you can use for sharing.


5. Recording Data in Google Sheets

The final step involves recording the Bitlink and file details into Google Sheets using Pabbly Connect. Select Google Sheets as your action application and choose ‘Add New Row’ as the action event.

Connect your Google Sheets account by authorizing it through Pabbly Connect. Once connected, select the spreadsheet where you want to store the Bitlink data. Map the fields for the image title, long URL, and Bitlink to ensure the data is accurately recorded.

Select the spreadsheet named ‘OneDrive Images Bitlinks’. Choose the appropriate sheet for data entry. Map the data for the image title, long URL, and Bitlink.

Click on ‘Save and Send Test Request’ to finalize the recording process. You can then check your Google Sheets to confirm that the data has been successfully entered, verifying that the entire automation works as intended.


Conclusion

In this tutorial, we demonstrated how to automate the creation of Bitlinks for new OneDrive files using Pabbly Connect, Bitly, and Google Sheets. This integration streamlines your workflow by automatically generating and recording shortened links.

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