Back to marketplace
Extract data from a PDF and write to a Google Sheet
CREATED BY
36 Templates
9.8k Views
LAST UPDATED
November 7, 2025INTEGRATIONS 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

