Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

I Track OneDrive Files in Google Sheets Automatically

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To begin, access Pabbly Connect by navigating to pabbly.com/connect. If you’re a new user, sign up for free to receive 100 tasks, allowing you to test the integration between OneDrive and Google Sheets.

Once logged in, click on the “Create Workflow” option. This will lead you to the quick builder, where you can describe the automation you want to set up. For instance, you might enter a prompt like “Track my OneDrive files in Google Sheets” to initiate the workflow creation.

2. Connecting OneDrive to Pabbly Connect

In this step, you will connect OneDrive to Pabbly Connect. Select “Microsoft OneDrive” as your trigger application and choose the event “New File Created”. Click on the “Connect” button to establish the connection.

Click on “Add New Connection”.
Authorize Pabbly Connect by clicking the “Connect with Microsoft OneDrive” button.
Enter the folder path where your files will be uploaded.

Once you have set up the connection, upload a test file to your OneDrive folder. After this, click on the “Test Request” button in Pabbly Connect to capture the newly uploaded file’s details.

3. Formatting Date and Time in Pabbly Connect

After successfully connecting OneDrive, the next step is to format the date and time of the uploaded file. In Pabbly Connect, add an action step and select “Date Time Formatter” by Pabbly.

Choose the event “Format Date with Time Zone”. Map the date from the previous step and set the original time zone to UTC. Then, specify your desired output time zone, for example, Asia/Kolkata. This ensures that the date and time are displayed in a user-friendly format.

4. Sending Data to Google Sheets via Pabbly Connect

Now, it’s time to send the formatted data to Google Sheets. In Pabbly Connect, add another action step and select “Google Sheets” as your application. Choose the event “Add Row” to insert the file details into your spreadsheet.

Connect to Google Sheets by clicking the “Sign in with Google” button.
Select the spreadsheet and the target sheet where the data will be recorded.
Map the file name, formatted date, and download URL from the previous steps.

After mapping the required fields, click on the “Send Test Request” button. If everything is set correctly, a new row will be added to your Google Sheets with the uploaded file’s information.

5. Conclusion: Automate Your Workflow with Pabbly Connect

By following these steps, you can efficiently automate the process of backing up files from OneDrive to Google Sheets using Pabbly Connect. This integration not only saves time but also ensures that your important files are systematically recorded.

With Pabbly Connect, you can create numerous automations tailored to your needs, enhancing productivity and workflow efficiency in your daily tasks.

Start using Pabbly Connect today to streamline your file management processes and automate your workflows effortlessly.