Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Google Drive, first, you need to access Pabbly Connect. Open a new tab and search for ‘pabbly.com/connect’. This will take you to the landing page where you can sign up for free.

If you are a new user, simply register to get 100 free tasks. This allows you to test the integration setup without any cost. Once signed in, you will be directed to the Pabbly Connect dashboard where you can create your workflow.

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the “Create Workflow” option. Use the quick builder to generate an automation template. Enter the prompt: “Upload Google Sheets files to Google Drive automatically”.

  • Select Google Sheets as your trigger application.
  • Choose the event that triggers the upload.
  • Confirm the creation of the workflow template.

After confirming, the workflow template will be created, allowing you to connect Google Sheets and Google Drive seamlessly through Pabbly Connect.

3. Setting Up Google Sheets with Pabbly Connect

Next, you need to set up Google Sheets within your workflow. Copy the webhook URL provided by Pabbly Connect and open your Google Sheets document.

In Google Sheets, navigate to Extensions > Add-ons > Get Add-ons, and search for “Pabbly Connect Webhooks”. Install this add-on and refresh your spreadsheet. After installation, go to Extensions > Pabbly Webhooks and select “Initial Setup”.

  • Paste the webhook URL into the designated field.
  • Set the trigger column (typically the last column with data).
  • Submit the setup and test the connection.

This setup allows Google Sheets to communicate with Pabbly Connect whenever new data is entered, facilitating automatic uploads to Google Drive.

4. Connecting Google Drive to Pabbly Connect

After configuring Google Sheets, the next step is to connect Google Drive. In your Pabbly Connect workflow, click on the “Connect” button and select “Add New Connection”.

Choose the “Sign in with Google” option to link your Google Drive account. Select the account you want to connect and grant the necessary permissions. This step is crucial for ensuring that Pabbly Connect can access your Google Drive for file uploads.

  • Map the file URL from Google Sheets to the upload field.
  • Enter the folder ID where files will be uploaded.
  • Test the connection to ensure everything is set up correctly.

Once these steps are completed, your Google Drive is now linked with Pabbly Connect, ready to receive files from Google Sheets.

5. Bulk Uploading Files from Google Sheets to Google Drive

To upload multiple files from Google Sheets to Google Drive, first ensure that the spreadsheet contains all the necessary file URLs. Then, go to Extensions > Pabbly Webhooks and click on “Send All Data”.

This action will trigger the upload of all files listed in your Google Sheets to your connected Google Drive folder. Within seconds, all files will be uploaded automatically.

For verification, check your Google Drive folder to see that all specified files have been uploaded successfully. This method showcases the power of Pabbly Connect in automating file management tasks between Google Sheets and Google Drive.

Conclusion

Using Pabbly Connect, you can easily integrate Google Sheets with Google Drive, allowing for automated file uploads. This streamlines your workflow and saves valuable time.