how to get pdf file into google document tutorial

Now that we have the text content of the PDF file, we can use RegEx to extract the information we need. Please ensure the Advanced Drive API as describes in this tutorial. Convert PDF to TextĪssuming that the PDF files is already in our Google Drive, we’ll write a little function that will convert the PDF file to text. We can then use RegEx to parse this text file and write the extracted information into a Google Sheet. Our PDF extractor script will read the file from Google Drive and use Google Drive API to convert to a text file. Here’s a sample PDF invoice that we’ll use in this example. These PDF invoices have to be parsed and specific information, like the invoice number, the invoice date and the buyer’s email address, needs to be extracted and saved into a Google Spreadsheet. This tutorial explains how you can parse and extract text elements from invoices, expense receipts and other PDF documents with the help of Apps Script.Īn external accounting system generates paper receipts for its customers which are then scanned as PDF files and uploaded to a folder in Google Drive.

How to get pdf file into google document tutorial