Pushbuild

Turn PDF bank statements and invoices into Google Sheets automatically

A Google Apps Script that turns the tables in a PDF on your Google Drive into a new tab in Google Sheets.

Short answer: Use a Google Apps Script that turns the tables in a PDF on your Google Drive into a new tab in Google Sheets. It runs in your Google account and sends what it works on to our server, which does the work. Setup takes 4 steps: Put the PDF in Google Drive; Add the script; Add your key; Run it.

More on our YouTube channel

How to set it up

  1. Put the PDF in Google Drive. Upload the PDF to Google Drive and open a Google Sheet.
  2. Add the script. Open Extensions, then Apps Script. Add two script files and paste in the two files from our email: Pushbuild.gs and pdf-tables-to-sheets.gs. Save, then reload the sheet. A Pushbuild menu appears.
  3. Add your key. Choose Pushbuild, then Set key, and paste the key from your signup email. The first time a script runs, Google asks for permission because it works in your own account. Review it and allow it.
  4. Run it. Choose Pushbuild, then Import PDF tables, and paste the PDF's Drive link or file ID. Its tables land on a new tab named after the file.
Setup, step by step: 4 steps, done in your own Google account.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Download it free

We'll email you the script (Pushbuild.gs and pdf-tables-to-sheets.gs) and your key. It runs in your Google account and sends what it works on to our server, which does the work.

Free for your first 10 runs. After that it's $9 a month for this snippet, or $19 a month for every Pushbuild snippet.

By continuing, you agree that Pushbuild may email you about this script and related tips. Unsubscribe any time. Privacy

Have us install it for you

We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

$49 one-time.

Have us install it

Just one file?

Our free PDF to Excel tool does a one-off file in your browser.

Questions

What does this script do?

It is a Google Apps Script that turns the tables in a PDF on your Google Drive into a new tab in Google Sheets.

How do I set it up?

In 4 steps: 1. Put the PDF in Google Drive; 2. Add the script; 3. Add your key; 4. Run it. The full steps are on this page.

Does it send my data anywhere?

Yes. It runs in your Google account and sends what it works on to our server, which does the work. We email you the script (Pushbuild.gs and pdf-tables-to-sheets.gs) and your key.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.

Pushbuild · Automate your business with Pushbuild: pushbuild.com/contact