How to Parse a Document and Send Data to Google Sheets using PDF.co and Make

This tutorial will show you how to parse a document and send the parsed data to Google Sheets using PDF.co Web API and Make.

1. Create a Scenario
2. Choose PDF.co for the First Module
3. Set up the First Module
4. Run the First Module
5. Result of the First Module
6. Choose Google Sheets for the Second Module
7. Set up the Second Module
8. Run the Scenario
9. Result

We will use this sample invoice as our source file. We will parse the Company Name, Invoice ID, Date Issued, Date Due, Sub Total, Tax, and Total. Then, send the parsed data to the table in our Google Sheets.

Here’s a step-by-step guide with screenshots:

1. Create a Scenario

• On your Make dashboard, click Create a New Scenario

2. Choose PDF.co for the First Module

• Search and select PDF.co as the app for your first module
• Select Parse a Document as the API

3. Set up the First Module

• For the Input File select Import a file from URL
• For the URL insert the URL to your source file
• For the Document Parser Template ID insert the ID of your Document Parser Template
• For the Output Format select JSON 
• For the Export Type select JSON Output

4. Run the First Module

• We need to run the module first so that when we set up the second module there will be available data that we can map

5. Result of the First Module

6. Choose Google Sheets for the Second Module

• Search and select Google Sheets as the app for your second module
• Select Add a Row as the action

7. Set up the Second Module

• For the Method choose Select from the list
• For the Drive select the drive where your google sheets are saved
• For the Spreadsheet ID select the Spreadsheet that you’re going to use
• For the Sheet Name select the Sheet where you want to insert the data
• If your table has a header, select Yes for Table contain headers field
• Insert the parsed data using PDF.co one by one into your table

8. Run the Scenario

9. Result

• Here’s the result

With the help of this tutorial, you’ve learned how to parse a document and send the parsed data to Google Sheets using PDF.co Web API and Make.