Automate Google Drive File Links to Google Sheets with Pabbly Connect

Learn how to use Pabbly Connect to automate the process of shortening Google Drive file links and adding them to Google Sheets seamlessly. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin the process of integrating Google Drive with Google Sheets, start by accessing Pabbly Connect. This platform enables seamless automation between various applications, including Google Drive and Google Sheets.

Visit the Pabbly Connect homepage by searching for the URL Pabbly.com/connect. If you are a new user, click on ‘Sign Up Free’ to get started with 300 tasks each month. Existing users can simply click ‘Sign In’ to access their dashboard.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, you will need to create a new workflow to automate the process. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard.

• Name your workflow as ‘Shorten and Add Google Drive File Link in Google Sheets’.
• Select a folder for your workflow, such as ‘Automations’.
• Click the ‘Create’ button to finalize your workflow setup.

This setup allows Pabbly Connect to initiate the automation process based on your specified trigger and actions.

3. Setting Up the Trigger in Pabbly Connect

In this step, you will set up the trigger for your workflow using Google Drive. Choose Google Drive as your trigger application and select the event as ‘New File in Specific Folder’. using Pabbly Connect

To connect your Google Drive account, click on ‘Connect’ and then select ‘Add New Connection’. Sign in with your Google account and allow Pabbly Connect to access your Google Drive data. After successful connection, select the folder where you will upload the files.

4. Adding Action Steps in Pabbly Connect

After setting up the trigger, it’s time to add action steps. The first action will be to shorten the URL using Bitly. Select Bitly as the action application and choose ‘Shorten Link’ as the action event. using Pabbly Connect

• Connect your Bitly account by clicking ‘Connect’ and then ‘Add New Connection’.
• Select your desired Bitly account and allow access to Pabbly Connect.
• Map the long URL from the Google Drive trigger to the Bitly action.

Once the URL is mapped, click ‘Save and Send Test Request’ to create the shortened link successfully.

5. Adding Google Sheets Action in Pabbly Connect

The final action involves adding the shortened link and file details to Google Sheets. Select Google Sheets as the action application and choose ‘Add a New Row’ as the action event. using Pabbly Connect

Connect your Google Sheets account in the same manner as before. Once connected, select your specific spreadsheet and sheet where you want the data to be added. Map the required fields such as file name, long URL, and short URL from the previous responses.

Conclusion

In this tutorial, you learned how to use Pabbly Connect to automate the process of shortening Google Drive file links and adding them to Google Sheets. This integration simplifies file management and enhances productivity by streamlining your workflow.