How to Upload Files from Google Sheets to OneDrive Using Pabbly Connect

Learn how to upload files from Google Sheets to OneDrive using Pabbly Connect. Follow this step-by-step tutorial to automate file uploads seamlessly. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Sheets and OneDrive Integration

To upload files from Google Sheets to OneDrive, you will first need to access Pabbly Connect. Start by signing into your Pabbly account. Once logged in, navigate to the dashboard where you can see all available applications.

Click on the ‘Access Now’ button for Pabbly Connect. This will lead you to the main interface where you can create workflows. Click on the big blue button labeled ‘Create Workflow’ and give it a name, such as ‘Upload Files from Google Sheets to OneDrive’. After naming your workflow, click on ‘Create’ to proceed.

2. Setting Up the Trigger in Pabbly Connect

In the newly created workflow, you will see two sections: Trigger and Action. The trigger for this integration will be a new row added in Google Sheets. This means that whenever a new row is added, it will initiate the workflow.

• Select Google Sheets as the Trigger application.
• Choose the trigger event as ‘New or Updated Spreadsheet Row’.
• Copy the provided webhook URL to connect Google Sheets with Pabbly Connect.

After copying the webhook URL, go to your Google Sheets, navigate to Extensions, and select Add-ons. Here, you will need to install the Pabbly Connect Webhook add-on if it is not already installed. Once installed, you can access it directly from the Extensions menu.

3. Initial Setup in Google Sheets

In the Pabbly Connect Webhook add-on, click on ‘Initial Setup’. Here, paste the webhook URL you copied earlier. You will also need to specify the trigger column, which is the last updated column in your Google Sheet.

• Set the trigger column to the appropriate column (e.g., Column B).
• Submit the setup to finalize your connection.

Once you have submitted the initial setup, return to Pabbly Connect. The platform will be waiting for a response from Google Sheets. Now, enter a file URL and the corresponding name in your Google Sheet to test the connection.

4. Setting Up the Action in OneDrive

After confirming that the trigger is working, it’s time to set up the action in OneDrive using Pabbly Connect. Search for Microsoft OneDrive in the Action application field and select it.

Choose the event as ‘Upload a File’. Connect your Microsoft OneDrive account by clicking ‘Connect’ and granting access to Pabbly Connect.

Once connected, specify the folder in OneDrive where you want the files to be uploaded. You can either select a folder or type its name directly. Next, map the file name and URL from the Google Sheets data to ensure the correct files are uploaded.

5. Testing the Integration and Finalizing

With the action set up, it’s time to test the integration. Click on ‘Save and Send Test Request’ in Pabbly Connect. You should receive a response indicating that the request was processed successfully.

To confirm everything is working, check your OneDrive folder for the uploaded file. If the file appears with the correct name and timestamp, your integration is successful. This automation will now upload files from Google Sheets to OneDrive automatically whenever a new row is added.

Conclusion

In this tutorial, we demonstrated how to seamlessly upload files from Google Sheets to OneDrive using Pabbly Connect. This integration automates the file upload process, saving time and effort. By following these steps, you can enhance your productivity and manage your files more efficiently.