How to Add Rows to Google Sheets with Data Parsed from PDF Documents using PDF.co and Zapier

We prepared this step-by-step tutorial with screenshots to teach you how to add rows on Google Sheets with data parsed from PDF documents using PDF.co and Zapier. This is to automatically send your parsed data into your Google Sheets.

Quick Navigation:

1. Start by clicking on Make a Zap! at the upper-left corner of your Zapier dashboard
2. We will now set up our Trigger. Search and select Google drive as the App event. 
3. As for our Trigger Event go ahead and choose New File in Folder.
4. Select or connect your Google Drive account which you will be using with Zapier
5. Select My Google Drive as the drive to be used and select the specific folder where the zip files are located.
6. We will then Test the trigger to see if there are any errors or none.
7. Search and select PDF.co as our App event
8. Select Document Parser as our Action event.
9. Select or connect your PDF.co account which you will be using with Zapier.
10. Under Setup Action set the Input into Web Content Link and set the Template ID into the template that you want to use with Document Parser.
11. Click on Test & Review to see if there are any errors or none.
12. Add another Action. Search and select Google Sheets as our App event.
13. Select Create Spreadsheet Row as our Action event.
14. Select or connect your Google Sheets account which you will be using with Zapier.
15. Under Setup Action select the Drive that you want to use, select the Spreadsheet that you’ll be using, select which Worksheet you’ll want to add the new row, and set the Value of the row that you want to add.
16. Click on Test & Review to see if there are any errors or none.
17. Once the test returns as successful. You can then turn the zap on.

Step by step guide:

We will use this sample PDF to parse the table and send some parsed data to create new rows on Google Sheets.

STEP 1 – Start by clicking on Make a Zap! at the upper-left corner of your Zapier dashboard

STEP 2 – We will now set up our Trigger. Search and select Google drive as the App event. 

STEP 3 – As for our Trigger Event go ahead and choose New File in Folder. In this case, whenever there’s a new file added to your specific folder, it will trigger this zap.

NOTE: If you are not a Google Drive user, you can use a different cloud storage service such as Dropbox, OneDrive, etc., and look for a similar Trigger Event.

STEP 4 – Select or connect your Google Drive account which you will be using with Zapier

STEP 5 – Select My Google Drive as the drive to be used and select the specific folder where the zip files are located. In my case, I put the sample PDF in the Samples folder

STEP 6 – We will then Test the trigger to see if there are any errors or none.

So we’re done setting up the Trigger. We will now set up the Action.

STEP 7 – Search and select PDF.co as our App event

Step 8 – Select Document Parser as our Action event. Document Parser can parse data in your PDF.

STEP 9 – Select or connect your PDF.co account which you will be using with Zapier. You can get your API key by clicking here.

Step 10 – Under Setup Action set the Input into Web Content Link and set the Template ID into the template that you want to use with Document Parser. You can create templates here.

STEP 11 – We will now Test the action. Click on Test & Review to see if there are any errors or none.

So we’re done with setting up the PDF.co action. Now let’s create an action for Google Sheets.

Step 12 – Add another Action. Search and select Google Sheets as our App event.

Step 13 – Select Create Spreadsheet Row as our Action event. This way we can create a new row through the parsed data from the sample PDF.

Step 14 – Select or connect your Google Sheets account which you will be using with Zapier.

Step 15 – Under Setup Action select the Drive that you want to use, select the Spreadsheet that you’ll be using, select which Worksheet you’ll want to add the new row, and set the Value of the row that you want to add.

Step 16 – Click on Test & Review to see if there are any errors or none.

Step 17 – Once the test returns as successful. You can then turn the zap on.

 

Just follow those steps to add rows on Google Sheets with data parsed from PDF documents using PDF.co and Zapier. Here’s what it looks like once a new row has been added.

In this tutorial, you’ve learned how to add rows to Google Sheets with data parsed from PDF documents using PDF.co and Zapier.