Link a Google Drive folder. Every PDF dropped into it is automatically extracted and structured data appears in Google Sheets. Zero manual intervention.
Connect a Google Drive folder to Lido. Every five minutes, the system checks for new PDFs. When one appears, the AI extracts tabular data and writes it to your designated Google Sheet. The PDF stays in Drive. The extracted data appears in Sheets. No manual upload, no CSV import, no intervention needed.
This is the simplest automation path for teams already working in Google Workspace. You don't need to change any existing workflow — just drop PDFs in a folder like you already do, and structured data materializes in Sheets.
Step 1: Create a Google Drive folder (or use an existing one) where PDFs will be placed.
Step 2: Connect Lido to that folder and specify which Google Sheet should receive the extracted data.
Step 3: Done. Drop a PDF in the folder. Within five minutes, structured data appears in your Sheet.
You can connect multiple Drive folders to different Sheets — for example, one folder per client, one folder per document type, or one folder per department. Each folder routes its extracted data to the correct destination automatically.
No workflow change required. If your team already saves PDFs to Drive (from email attachments, scanner output, or downloads), this just adds automatic extraction on top. Nobody needs to learn a new tool or change their habits.
Works with shared folders. Multiple team members can drop PDFs into the same folder. Extraction happens automatically regardless of who added the file. Great for teams where different people receive different documents.
Combines with email forwarding. Use Gmail's "Save to Drive" feature (via Google Workspace add-ons) to automatically save PDF attachments to a Drive folder. The folder automation picks them up from there. This creates a fully hands-free pipeline: email → Drive → extraction → Sheets.
OneDrive too. Lido supports OneDrive folder connections with the same five-minute polling. If your organization uses Microsoft 365 for file storage but Google Sheets for data, this bridges the gap.
By client: /Clients/Acme Corp/Invoices/ — each client's invoices land in their own Google Sheet tab.
By document type: /Incoming/Bank Statements/, /Incoming/Invoices/, /Incoming/Receipts/ — each type routes to a different Sheet with appropriate columns.
By date: /2026/Q1/, /2026/Q2/ — useful for quarterly reporting workflows where each period's documents consolidate into a single analysis Sheet.
Connect a Drive folder and see automatic extraction in action. 50 free pages, no credit card required.
50 free pages. All features included. No credit card required.