Google Sheets + PDF.co
Parse documents in PDF.co whenever new or updated rows appear in Google Sheets
Stay on top of your data with this streamlined workflow. When you add or update a row in your Google Sheets, this automation parses the related document in the PDF.co app. Enjoy the benefit of timely, accurate data parsing, reducing manual tasks and increasing efficiency. Boost your productivity with this seamless integration between Google Sheets and PDF.co.
Stay on top of your data with this streamlined workflow. When you add or update a row in your Google Sheets, this automation parses the related document in the PDF.co app. Enjoy the benefit of timely, accurate data parsing, reducing manual tasks and increasing efficiency. Boost your productivity with this seamless integration between Google Sheets and PDF.co.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Document ParserExtract data from invoices, reports, statements, and other documents using AI-based templates. This tool is beneficial for automating data extraction tasks and reducing manual workload.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundBarcode ValueRequired
Barcode TypeRequired
Source File URL (optional)
X Co-ordinateRequired
Y Co-ordinateRequired
Pages (optional)
Custom Profiles
Advance Options
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Image URLRequired
X Co-ordinateRequired
Y Co-ordinateRequired
Width
Height
Pages
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message
Source File URLRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Barcode Type to Read (optional)
Pages (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Output FormatRequired
Source File URLRequired
Page Selection (optional)
File Name (optional)
OCR Language for Scanned Documents (optional)
Extraction Region (optional)
Enable Line Grouping (optional)
Unwrap (optional)
Define Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Custom Classification Rules (optional)
CSV Rules URL (optional)
Enable Case Sensitive Custom Rules (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message
Sender EmailRequired
Recipient EmailRequired
Email SubjectRequired
SMTP ServerRequired
SMTP Server PortRequired
SMTP UsernameRequired
SMTP PasswordRequired
CC (optional)
BCC (optional)
Email Body (Plain Text) (optional)
Email Body (HTML) (optional)
Attachment URLs (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Input TypeRequired
Page Orientation (optional)
Page Size (optional)
Custom Page Size (optional)
Custom Margins (optional)
Render Page Background (optional)
Media Type (optional)
Do not wait until full page load (optional)
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Automatically Convert Non-PDF Files (optional)
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Text to Search and RemoveRequired
Enable Regular Expressions (optional)
Case-Sensitive Search (optional)
Pages (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Text to LocateRequired
Replacement Image URLRequired
Pages (optional)
Enable Regular Expressions (optional)
Case-Sensitive Search (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Page Numbers/RangesRequired
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Text Search StringRequired
Enable Case-Sensitive Search (optional)
Enable Regular Expression Search (optional)
Exclude Pages with Identified Text (optional)
OCR Language (optional)
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSource File URLRequired
IdRequired
X Co-ordinateRequired
Y Co-ordinateRequired
TypeRequired
Initial Value
Size
Pages
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Text to addRequired
X Co-ordinateRequired
Y Co-ordinateRequired
Advance Options
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Barcode ValueRequired
Barcode Type
Generate Inline URL (optional)
Advance Options
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Input FormatRequired
Source File URLRequired
File Name (optional)
Worksheet Index (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF.co API EndpointRequired
URL Input Parameter Override (optional)
Input JSON (optional)
Execute Job Check Immediately
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Template Id (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Extract Fillable Fields (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
OCR Language (optional)
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Operation TypeRequired
OCR Language for auto-rotate (optional)
Page Numbers (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URL (optional)
Text Annotations (fill at least one)
Image Embeds (fill at least one)
Fillable Form Fields (fill at least one)
File Name (optional)
Allow Empty Text and Image Objects (optional)
Auto-trim Input Values (optional)
Template Data (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Operation Mode (optional)
Owner Password (fill at least one for Remove Security)
User Password (fill at least one for Remove Security)
Encryption Algorithm (optional)
Allow Printing (optional)
Define Printing Quality (optional)
Enable Document Assembly (optional)
Enable Content Copying (optional)
Enable Content Copying for Accessibility (optional)
Enable Document Modification (optional)
Enable Form Field Filling (optional)
Enable Commenting (optional)
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Text to LocateRequired
Replacement TextRequired
Target Pages
Enable Regular Expressions (optional)
Case-Sensitive Search (optional)
Replacement Limit (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Search QueryRequired
Enable Regular Expressions (optional)
Page Range (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source File URLRequired
Barcode Search StringRequired
Exclude Pages with Identified Barcodes (optional)
File Name (optional)
Custom Profiles (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Google Sheets
Related categories
About PDF.co
Related categories
Related Zap Templates
- Extract data from new PDFs in Google Drive with PDF.co and add to multiple rows in Google Sheets
- Convert new or updated Google Sheets rows to pdfs with PDF.co's anything to pdf converter
- Convert new Google Sheets worksheets to PDF file format using PDF.co
- Convert new Google Sheets rows to pdfs with PDF.co
- Add barcodes to Google Sheets from new Dropbox folders using PDF.co
- Convert new cell URL values in Google Sheets spreadsheet rows to PDF format using PDF.co
- Add form fields to PDF.co from new or updated Google Sheets rows
- Convert new Google Sheets rows into pdfs using PDF.co's html to pdf converter
- Create pdf fillers in PDF.co for every new worksheet in Google Sheets
- Fill pdfs in PDF.co whenever new or updated rows occur in Google Sheets
- Convert new or updated Google Sheets rows to pdfs with PDF.co
- Update and add text to pdfs in PDF.co with new or updated rows in Google Sheets
- Fill pdfs in PDF.co when new rows are added to Google Sheets
- Search and replace text in pdfs with PDF.co when new spreadsheet rows are added in Google Sheets
- Convert new Google Sheets spreadsheets to pdfs with PDF.co's html to pdf converter
- Convert new Google Sheets worksheets to pdfs with PDF.co
- Add text to pdfs in PDF.co when new rows are added in Google Sheets
- Create searchable pdfs in PDF.co from new rows in Google Sheets
- Create pdf fillers in PDF.co from new rows in Google Sheets team drive
- Create form fields in PDF.co for new rows in Google Sheets
- Update and add text to pdfs with new or updated rows in Google Sheets (team drive)
- Trigger custom api calls in PDF.co from new or updated rows in Google Sheets
- Extract pdf information with PDF.co when new or updated rows are added to Google Sheets team drive
Related Zap Templates
- Extract data from new PDFs in Google Drive with PDF.co and add to multiple rows in Google Sheets
- Convert new Google Sheets rows to pdfs with PDF.co
- Add form fields to PDF.co from new or updated Google Sheets rows
- Fill pdfs in PDF.co whenever new or updated rows occur in Google Sheets
- Fill pdfs in PDF.co when new rows are added to Google Sheets
- Convert new or updated Google Sheets rows to pdfs with PDF.co's anything to pdf converter
- Add barcodes to Google Sheets from new Dropbox folders using PDF.co
- Convert new Google Sheets rows into pdfs using PDF.co's html to pdf converter
- Convert new or updated Google Sheets rows to pdfs with PDF.co
- Search and replace text in pdfs with PDF.co when new spreadsheet rows are added in Google Sheets
- Convert new Google Sheets worksheets to PDF file format using PDF.co
- Convert new cell URL values in Google Sheets spreadsheet rows to PDF format using PDF.co
- Create pdf fillers in PDF.co for every new worksheet in Google Sheets
- Update and add text to pdfs in PDF.co with new or updated rows in Google Sheets
- Convert new Google Sheets spreadsheets to pdfs with PDF.co's html to pdf converter