Extract Data from PDFs Stored in OneDrive Automatically

Parseur logo OneDrive logo

Many teams store PDFs in OneDrive: supplier invoices dropped into a shared folder, scanned forms uploaded from the office scanner, contracts saved by the person who received them. The files are in one place, but getting the data out of them still requires someone to download each one, open a parsing tool, and handle the extraction manually.

This integration removes that step. Zapier watches a OneDrive folder for new files and sends each one to Parseur automatically. Parseur extracts the structured fields you defined, and the data is ready to export or route to another app without any manual work.

Because OneDrive is part of the Microsoft 365 ecosystem, Power Automate is also a natural fit for this workflow alongside Zapier. Both connect to Parseur and both can watch OneDrive folders for new files. The setup steps below use Zapier, but the Power Automate path follows the same logic.

Key Takeaways

  • Zapier watches a OneDrive folder and sends each new file to Parseur automatically. Power Automate works the same way and is the better fit for teams already in Microsoft 365.
  • Parseur handles native PDFs, scanned documents via OCR, images, and Word files. Any file type Parseur supports can be sent from OneDrive via this workflow.
  • After extraction, parsed data can be routed to Excel Online, SharePoint, a CRM, Google Sheets, or any other app via Zapier, Make, or Power Automate.
  • The same pattern works for Google Drive, Dropbox, and other cloud storage platforms with a Zapier "New File in Folder" trigger.
  • Both Parseur and Zapier have free plans.

What you can build with this integration

Once the OneDrive-to-Parseur connection is running, any new file in your watched folder triggers the full extraction workflow:

  • Invoice processing: Finance teams share a OneDrive folder for incoming supplier invoices. PDFs dropped into the folder are sent to Parseur, which extracts vendor name, invoice number, due date, and line items, then routes the data to accounting software or a tracking spreadsheet. See the invoice processing guide.
  • Contract management: Legal or operations teams store incoming contracts in a OneDrive folder. Parseur extracts party names, dates, and key values. Extracted fields can be logged to a tracker or trigger a review workflow in Teams or email.
  • Bill of lading processing: Logistics teams upload shipping documents to OneDrive. Parseur extracts shipment details, consignee information, and cargo descriptions automatically.
  • Scanned document processing: Physical documents scanned to OneDrive are processed by Parseur's built-in OCR. Forms, receipts, and handwritten invoices are all handled without extra configuration.
  • Shared team folders: Any team member can drop a file into the watched folder and it gets processed automatically, with no coordination required.

How the integration works

  1. A new file appears in your watched OneDrive folder
  2. Zapier detects the new file and sends it to your Parseur mailbox
  3. Parseur extracts the structured fields from the document and makes the data available for export or routing

You configure the folder in Zapier and the extraction template in Parseur once. After that, every new file in the folder is handled automatically.

Step-by-step: Connect OneDrive to Parseur via Zapier

Step 1: Create your Parseur mailbox

Sign up to Parseur for Free
Try out our powerful document processing tool for free.

Create your Parseur mailbox and choose the mailbox type that matches your documents. Parseur has pre-built templates for invoices, bills of lading, and many other formats. For custom document types, use the AI-assisted default mailbox.

Step 2: Connect OneDrive as the Zapier trigger

Sign in to your Zapier account and search for OneDrive and Parseur integrations.

Invoice uploaded in OneDrive folder
A PDF invoice in a OneDrive folder ready to be processed

Search for "OneDrive and Parseur"
Search for the OneDrive and Parseur integration in Zapier

Set OneDrive as the trigger app and New File as the trigger event. Connect your OneDrive account and grant Zapier access.

Log in to your OneDrive account
Connect your OneDrive account to Zapier

Select the folder you want to watch for new files.

Choose your OneDrive folder
Choose the OneDrive folder to watch

Zapier will retrieve a sample file from the folder to confirm the connection.

OneDrive and Zapier connection completed
Zapier confirms the OneDrive connection

Step 3: Set Parseur as the action

Choose Parseur as the action app and Create Document from File as the action event. Connect your Parseur account and select the mailbox where you want the files to be sent.

Connect Parseur with Zapier
Select your Parseur mailbox as the destination

Step 4: Test the Zap

Send a test to confirm the file moves from OneDrive to Parseur correctly.

Send a test from Zapier to OneDrive
Run a test to confirm the file reaches Parseur

Step 5: Turn the Zap on

Once the test passes, activate the Zap. Every new file uploaded to the watched folder is sent to Parseur automatically from that point.

Invoice parsed successfully
Parseur extracts the data from the file automatically

Parseur processes the document using your extraction template and the structured fields are available to export or route to your next destination.

Using Power Automate instead of Zapier

If your team is in Microsoft 365, Power Automate is worth considering for this workflow. It has native OneDrive and SharePoint connectors and integrates directly with Teams, Dynamics 365, and other Microsoft services. Parseur connects to Power Automate as a connector, so the extraction step stays the same. Power Automate is the better fit when your destination app is in the Microsoft ecosystem. Zapier is faster to set up when you need to connect to third-party apps like Google Sheets or a non-Microsoft CRM.

If you want to inspect a PDF's data structure before setting up an automated pipeline, these free converters work in the browser:

Parseur logo
What is Parseur?

Parseur is a powerful document processing software to extract text from emails, PDFs and documents and automate your workflow. All Parseur features.

OneDrive logo
What is OneDrive?

Launched in 2007, Microsoft OneDrive enables users to store, share, and synchronize their files.

Zapier logo
What is Zapier?

Zapier is a cloud automation tool that connects apps together. You can connect two or more apps to automate repetitive tasks without coding or relying on developers to build the integration.

Microsoft Power Automate logo
What is Power Automate?

Microsoft Power Automate (also known as Microsoft Flow) is a tool that integrates cloud-based apps and services so they interact with each other seamlessly. Flow makes it easy to interact with Microsoft applications (like Outlook, Excel, SharePoint, Dynamics CRM, SQL Server and more).

Going further

You may also like

Get started

Ready to remove manual work
from your operations?

Start free in minutes and see how Parseur fits into your workflow.

No model training required
Built for real workflows, not experiments
Scales from point-and-click to API

Frequently Asked Questions

Common questions about automatically extracting data from PDFs and other files uploaded to OneDrive using Parseur.

Set up a Zap in Zapier where OneDrive is the trigger (New File) and Parseur is the action (Create Document from File). When a new PDF appears in the watched OneDrive folder, Zapier sends it to your Parseur mailbox automatically. Parseur extracts the fields you defined and the data is ready to route to other apps. Alternatively, Power Automate has a native OneDrive connector that can trigger on new files and send them to Parseur.

Yes. The Zapier OneDrive trigger can watch folders in your personal OneDrive or in shared drives your account has access to. For SharePoint document libraries, Power Automate is usually the better fit since it has native SharePoint connectors that integrate directly with your Microsoft 365 environment.

Either works with Parseur. Zapier is faster to set up and supports the widest range of destination apps. Power Automate is the better fit if your team is already in Microsoft 365 and wants to connect OneDrive to SharePoint, Dynamics 365, Teams, or other Microsoft services. Both have free tiers you can use to test the workflow.

Yes. Create a separate Zap for each folder and point each one to a different Parseur mailbox. For example, one Zap watches an invoices folder and routes to an invoice mailbox, while another watches a contracts folder and routes to a contracts mailbox with a different extraction template.

No. The Zapier OneDrive trigger only fires for new files added after the Zap is activated. Existing files in the folder won't be sent to Parseur automatically. If you need to process existing files, you'll need to move or re-upload them to trigger the Zap.

Use "New File" as the OneDrive trigger event in Zapier and specify the folder you want to watch. This fires whenever a new file is uploaded to that folder, regardless of who uploaded it. It doesn't trigger for files that are only edited or renamed.

Parseur handles native PDFs, scanned PDFs via OCR, images (PNG, JPG, TIFF), Word documents, and CSV files. For scanned documents, Parseur's built-in OCR reads the content without any extra configuration.

Parsed data can be exported as Excel, CSV, or JSON, or routed to other apps via Zapier, Make, or Power Automate. Common next steps include logging extracted fields to Google Sheets or Excel Online, creating records in a CRM or accounting tool, sending Teams or Slack notifications, or triggering any other workflow your team runs on Zapier or Power Automate.

Yes. Make has a OneDrive module that can watch folders for new files. You'd use that as the trigger and connect it to Parseur via webhook or the Parseur connector. Make is a good fit if you need conditional routing or want to send the same file to multiple processing steps simultaneously.

Yes. Parseur has a free plan that includes all features up to a monthly document limit. Zapier has a free plan that supports multi-step Zaps. Power Automate also has a free tier. You can test the full OneDrive to Parseur workflow on any of these free plans.