How it Works

This automation takes a PDF that is stored in Google Drive and extracts table data into a Lido spreadsheet.

Start with a PDF

Start with a PDF stored in Google Drive that has tabular data in it. It could be one or more tables of data.

If you have a PDF that does not have obviously tabular data, or its otherwise irregular, you can use Lido's PDF Import Tool instead.

Use the EXTRACTTABLESFROMPDF formula

Use Lido's EXTRACTTABLESFROMPDF formula to pull tabular data from the PDF into Lido's spreadsheet.

EXTRACTTABLESFROMPDF(<drive-credential>,"path to file",<output cell>)

Data is now extracted

Your data is now extracted into a Lido spreadsheet and can be used, copied, or exported.

Similar Apps

Use Lido to make your forms, spreadsheets, and communication apps all talk to each other.

Google Forms
Slack
WhatsApp
Google Drive
Google Calendar
Typeform