A practical example of how AI automatically pulls prices from PDFs and fills them into Excel without a single click.
A solar energy company had the same problem as thousands of businesses. Every week, employees spent hours manually retyping prices from supplier PDFs into Excel. Errors, delays, frustration. We decided to solve it once and for all.
How it worked before
Every Monday morning 3 to 5 PDF price lists arrived from different suppliers. An employee opened them manually, searched for the right items and retyped the numbers into a shared Excel file. The process took 5 hours a week and contained an average of 12 errors a month.
Make.com + AI extraction
We set up an automation in Make.com that watches a folder in Google Drive. When a new PDF arrives, AI processes it, recognises the price-list structure and extracts the relevant rows. The result is automatically written into the correct column in Excel and a notification is sent to Slack.
Results after 4 weeks
Out of 5 hours of manual work, only 15 minutes of checking remained. The error rate dropped to zero. The company saved 20 hours of work a month, which at an average hourly rate represents savings of more than €400 a month on this one process alone.
If you have any repetitive manual process with documents, we can most likely automate it. Book a free consultation and within 30 minutes you'll find out how many hours a week you can save.