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

Step 1: Create a New Zap

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

Step 2: Set App Event

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

Step 3: Set Trigger Event

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.

Step 4: Connect Google Drive Account

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

Step 5: Choose Folder Location

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: Test Trigger

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: Select Another App Event

Search and select PDF.co as our App event

Step 8: Select Document Parser

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

Step 9: Connect PDF.co Account

Select or connect your PDF.co account which you will be using with Zapier. You can get your API key from the PDF.co dashboard.

Step 10: Setup Action

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: Test Action

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

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

Step 13: Set Action Event

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: Connect Google Sheets Account

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

Step 15: Setup Action

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: Test & Review

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

Step 17: Output

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.