Pabbly Connect: Seamlessly Upload Files from Google Sheets to Google Drive

Learn how to use Pabbly Connect to automatically upload files from Google Sheets to Google Drive. Step-by-step guide with detailed instructions. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for File Uploads

To start using Pabbly Connect for uploading files from Google Sheets to Google Drive, first ensure you have access to your Google account. Once logged in, navigate to Pabbly Connect and create a new workflow.

In this workflow, you will be able to set up triggers and actions. The first step is to connect your Google Sheets account to Pabbly Connect. This allows you to pull data from your Google Sheets, including file URLs that need to be uploaded.

2. Installing the Pabbly Add-On in Google Sheets

Next, you need to install the Pabbly add-on in Google Sheets. Go to the Add-ons menu and select ‘Get Add-ons’. Search for ‘Pabbly’ to find the relevant extensions. You will find two options, but you need to install the one titled ‘Upload Files to Google Drive’. using Pabbly Connect

• Click on the install button for the add-on.
• Once installed, return to the Add-ons menu.
• Select ‘Pabbly Save to Drive’ to begin the configuration.

After installation, you can now set up the add-on by clicking on ‘Setup’. This is where you will configure the settings to specify the Google Sheet and the destination folder in Google Drive.

3. Configuring File Upload Settings in Pabbly Connect

In the setup menu of the Pabbly add-on, you will be prompted to enter three important values. First, specify the sheet name where your file URLs are located. In our example, the sheet name is ‘Sheet1’. Next, indicate the URL column, which is column ‘A’ in this case.

Finally, you need to input the destination folder ID from your Google Drive. To find this, navigate to your Google Drive, select the folder, and copy the folder ID from the URL. Paste this ID back into the setup in Pabbly Connect.

4. Saving Files to Google Drive Using Pabbly Connect

Once the configuration is complete, you can choose to save files either on a schedule or instantly. For scheduled uploads, enable the ‘Save on Schedule’ option, which will trigger the automation every hour to check for new file URLs in your Google Sheets.

• Select ‘Save Now’ for immediate uploads.
• Specify the starting row index and number of rows to fetch.
• Click ‘Save to Drive’ to begin the upload process.

After executing the save action, Pabbly Connect will download the files from the specified URLs and upload them directly to your chosen Google Drive folder.

5. Verifying Uploaded Files in Google Drive

After the upload process is complete, you can verify the files in your Google Drive. Navigate to the designated folder, and you should see all the files that were uploaded. This includes all PNG and MP4 files that were linked in your Google Sheets.

Utilizing Pabbly Connect makes this process seamless and efficient, allowing you to automate file uploads without manual intervention. You can also set it to continue uploading new files added to the Google Sheet.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to upload files from Google Sheets to Google Drive automatically. By following these steps, you can streamline your workflow and ensure that all your necessary files are stored efficiently.