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.

Screenshot of the Sample Invoice
Screenshot of the Sample Invoice
Screenshot of the Empty Google Sheets
Screenshot of the Empty 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

Choose PDF.co for the First Module

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

Set up the first module

Set up the first module

Set up the first module

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

Run the first module

5. Result of the First Module

Screenshot of the Result
Screenshot of the Result

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

Choose Google Sheets for the second module

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

Set up the second module

Set up the second module

Set up the second module

8. Run the Scenario

Run the scenario

9. Result

  • Here’s the result
Screenshot of the Table after Inserting the Data
Screenshot of the Table after Inserting the Data

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.

Related Pages:

Related Samples: