How do you extract data from your documents on Google Drive with Make?

Dernière mise à jour :

June 26, 2025

5 minutes

Finally, automate the extraction of data from your documents stored on Google Drive, without coding. Thanks to the integration between Make and Koncile, you can transform any PDF or image into usable data, in a few clicks. Here's how.

Automate the extraction of data from Google Drive with Make, without coding, from PDFs, images, or documents.

Your Google Drive documents with Make and Koncile

1) Upload your files to Google Drive

Get started simply: put your documents in a dedicated Google Drive folder. Whether invoices, contracts, packing lists or HR documents, everything is ready to be processed automatically via a OCR.

Drive

2) Define the fields you want to extract on Koncile

On Koncile, select the type of document and specify the data to be extracted (amounts, dates, names, numbers, etc.). Our intelligent OCR recognizes the structure, even on complex or non-standardized formats.

Koncile facture

You can create repeated fields to automatically capture rows in a table, such as those in a invoice. All you have to do is define a “repeated” section in your model, then specify the columns to be extracted (product name, reference, quantity, price...).

Koncile detects each line and applies the defined structure, even across multiple pages. Result: all transactions are extracted cleanly, line by line, without complex configuration.

Koncile OCR facture

3) Use a Make scenario

Connect your tools with an ultra-simple Make scenario:

Trigger : a new file arrives in the Google Drive folder

Action : Koncile reads the document and extracts the targeted data

Output : the data is sent to the tool of your choice (Google Sheet, webhook, Airtable, CRM...)

No code, 100% automated.

Make et Koncile

4) Consult your data directly on Google Sheet

In a few seconds, the extracted data is found in a Google Sheet table, ready to be filtered, shared, or integrated into your monitoring.

5) Or consult the data in CSV format

Do you need archiving or importing into a tool? The scenario can also generate a ready-to-use CSV file, with the correct column titles and extracted data, row by row.

6) What to remember

Step Action Detail
1 Upload files to Google Drive Drop your documents into a dedicated folder (invoices, contracts, packing lists, HR…)
2 Configure extraction on Koncile Select the document type and the fields to extract (amounts, table rows, etc.)
3 Create a Make scenario Trigger: new file → action: Koncile extraction → result: data sent
4 Display data in Google Sheets Data ready to use in a structured Google Sheet table
5 Export as CSV Generate a ready-to-use CSV file with structured, extracted data
Author and Co-Founder at Koncile
Jules Ratier

Co-fondateur at Koncile - Transform any document into structured data with LLM - jules@koncile.ai

Jules leads product development at Koncile, focusing on how to turn unstructured documents into business value.

In a context of increasingly complex supply chains, KYS (Know Your Supplier) is becoming a key lever for securing your supplier relationships. This article explains what KYS is, why it is essential, and how to integrate it into your compliance and risk management processes.

Blog

27/6/2025

Discover how to transform these documents into structured JSON to automatically use them in your business tools (accounting, CRM, ERP...). Thanks to the Koncile API, convert your PDFs into ready-to-use data, without coding. This comprehensive step-by-step guide shows you how to automate this process, whether you're a developer or not.

Practical guide

19/6/2025

Discover how parsing automates data extraction from PDF, scanned, and digital documents. By combining OCR, NLP, and rule-based methods, it transforms raw content into structured data. This article explains the key concepts, technologies, and use cases behind modern document parsing.

Blog

18/6/2025