Back to marketplace

Extract data from a PDF and write to a Google Sheet

CREATED BY

KD

36 Templates

9.8k Views

LAST UPDATED

November 7, 2025

INTEGRATIONS USED

DESCRIPTION

What does this flow do?

Use this flow to extract tabular data from a PDF and write it to a Google Sheet.

Here's how it works:

  • Upload PDF to the PDF Reader node

  • Extract Data node extracts data from PDF (according to the specified data headers)

  • Google Sheets Writer node writes PDF data to a Google Sheet

Requirements

⚠️ READ BEFORE USING!

This flow is configured for a hypothetical example PDF. In order to use it properly for your own PDFs, you'll need to do the following

  • Authenticate with Google Sheets

  • Define the data header types you want to extract from the PDF in the Extract Data node

  • Create a Google Sheet with headers for the desired data types

  • Paste the link for the Google Sheet in the Google Sheets Writer node

  • In the Google Sheets Writer node, map the outputs from the Extract Data node to correct Google Sheets columns

HOW DO YOU SET THIS UP?

1.

Authenticate with Google Sheets

2.

Define data header types

Be sure to configure the appropriate Data outputs, with names, data types and descriptions. You may also want to add extra info in the Additional Context field.

3.

Create a Google Sheet with appropriate headers

4.

Paste the Google Sheets link in the Google Sheets Writer node

5.

Map outputs from the Extract Data node to the headers in the Google Sheet

Hand-picked by the Gumloop team

Similar Templates

form icon
Notifications icon
Using AI icon
Gmail icon

148 views

14 hours ago