Sync New OneDrive Files with Google Sheets Using Pabbly Connect

Learn how to sync new OneDrive files with Google Sheets using Pabbly Connect in this detailed tutorial. Follow the steps to automate your workflow effortlessly!

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To sync new OneDrive files with Google Sheets, you will first need to access Pabbly Connect. Start by visiting the Pabbly website and signing in to your account. If you don’t have an account, you can create one quickly and easily.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you will find options to create new workflows that allow you to integrate various applications seamlessly. Click on the ‘Access Now’ button to initiate the process of integrating OneDrive with Google Sheets.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a new workflow to connect OneDrive and Google Sheets using Pabbly Connect. Click on the ‘Create Workflow’ button on the dashboard. Name your workflow something descriptive, like ‘OneDrive to Google Sheets’.

• Click on the ‘Create’ button to proceed.
• Select OneDrive as your trigger application.
• Choose the ‘New File’ trigger event.

After selecting the trigger event, connect to your Microsoft OneDrive account by allowing access. This step is crucial as it enables Pabbly Connect to monitor your OneDrive for new files.

3. Setting Up the Trigger for OneDrive

Now that you have created the workflow, it’s time to set up the trigger in Pabbly Connect. You will need to specify the folder path where new files will be uploaded in OneDrive. This is essential for Pabbly Connect to accurately track new uploads.

To specify the folder, navigate to your OneDrive files and copy the folder path. If you are using subfolders, ensure you include the complete path. After entering the folder path in Pabbly Connect, click on ‘Save and Send Test Request’ to verify that the integration is set up correctly.

4. Adding Action to Google Sheets

After successfully setting up the trigger for OneDrive, the next step is to add an action to Google Sheets via Pabbly Connect. You will want to select Google Sheets as your action application and choose the ‘Add New Row’ action event.

• Select the Google Sheets account you want to connect.
• Choose the spreadsheet you created for tracking new uploads.
• Map the necessary fields such as file name, upload date, and URL.

Once all fields are mapped, click on ‘Save and Send Test Request’. This action will send the data from the newly uploaded OneDrive file to your specified Google Sheet.

5. Finalizing the Integration Process

After completing the setup, you should test the integration to ensure everything works correctly. Upload a new file to the specified OneDrive folder and check if it appears in your Google Sheet. This final test confirms that Pabbly Connect is effectively syncing your OneDrive files with Google Sheets.

If the data appears as expected, congratulations! You have successfully set up an automated workflow using Pabbly Connect. This integration will help streamline your file management process, allowing you to focus on more critical tasks.

Conclusion

In this tutorial, we explored how to sync new OneDrive files with Google Sheets using Pabbly Connect. By following these detailed steps, you can automate your workflow efficiently and save valuable time.