Learn how to track new OneDrive for Business files in Google Sheets seamlessly using Pabbly Connect. Follow this step-by-step tutorial for easy integration. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below


Accessing Pabbly Connect for Integration

To track new OneDrive for Business files in Google Sheets, you 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 for free in just a couple of minutes.

Once logged in, navigate to the dashboard where you can create a new workflow. This workflow will allow you to connect OneDrive for Business to Google Sheets through Pabbly Connect. This integration will enable automatic tracking of files uploaded in OneDrive.


Creating a Workflow in Pabbly Connect

To create a workflow in Pabbly Connect, click on the ‘Create Workflow’ button. You can name your workflow something descriptive, like ‘OneDrive to Google Sheets’. This name will help you identify the integration later.

After naming your workflow, you will need to set the trigger app. In this case, select OneDrive as the application to trigger the workflow. The trigger event should be set to ‘New File’. This means that every time a new file is uploaded to OneDrive, it will initiate the workflow.

  • Click on ‘Connect’ to link your OneDrive account.
  • Authorize Pabbly Connect to access your OneDrive files.
  • Specify the folder path where the new files will be uploaded.

Once these steps are completed, you can proceed to the next part of the integration, which involves connecting to Google Sheets using Pabbly Connect.


Connecting Google Sheets to Pabbly Connect

After setting up OneDrive, the next step is to connect Google Sheets. In your Pabbly Connect workflow, select Google Sheets as your action app. This step is crucial as it determines where the data from OneDrive will be sent.

For the action event, choose ‘Add New Row’. This option allows you to add a new row in your Google Sheets every time a new file is uploaded to OneDrive. You will then need to connect your Google Sheets account to Pabbly Connect.

  • Select the Google Sheet you want to update.
  • Map the fields from OneDrive to the corresponding columns in Google Sheets.
  • Click on ‘Save and Send Test Request’ to test the integration.

Once you complete these steps, your workflow is set to automatically track new OneDrive files in Google Sheets through Pabbly Connect.


Testing the Integration

After setting up the integration, it’s important to test it to ensure everything is functioning correctly. Upload a new file to your designated OneDrive folder. For instance, you can upload a file named ‘corruption index.xlsx’ or any other document.

Wait a few minutes for Pabbly Connect to process the new file. After the processing time, check your Google Sheets to see if the new file has been added as a new row. The row should include details like the file name, creation time, and a shareable URL.

Ensure the file name appears correctly in Google Sheets. Verify the creation time matches the time of upload. Check that the URL links to the uploaded file.

If all details are correct, your integration is successful, and you can now automatically track new OneDrive files in Google Sheets using Pabbly Connect.


Conclusion

In this tutorial, we explored how to track new OneDrive for Business files in Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of logging your business files in Google Sheets, improving efficiency and organization.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.