Google Drive + Google Sheets + PDF.co
Extract data from new PDFs in Google Drive with PDF.co and add to multiple rows in Google Sheets
This Zap automatically extracts data from your new invoice files in a Google Drive folder using PDF.co's AI Invoice Parser and save it to multiple rows in Google Sheets. Turn PDF invoices into quick, precise, and standardized JSON without any added clicks or keystrokes.
This Zap automatically extracts data from your new invoice files in a Google Drive folder using PDF.co's AI Invoice Parser and save it to multiple rows in Google Sheets. Turn PDF invoices into quick, precise, and standardized JSON without any added clicks or keystrokes.
- When this happens...
New File in FolderTriggers when a new file is created within, moved to, or uploaded directly to a specific folder (but not its subfolders).
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this...
AI Invoice ParserTransform your invoice processing with our advanced AI. Enjoy quick, accurate data extraction that eliminates manual effort and saves you valuable time.
ActionWriteCreate a new record or update an existing record in your app. - then do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
FileRequired
Convert to Document?
File Name
Drive
Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Parent Folder
Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File NameRequired
File ContentRequired
Convert to Document?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
File IdRequired
Sharing PreferenceRequired
Organization Domain
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File to Replace
File/Folder Name
Rename Folder?
Extension Copy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Retrieve Files from Google Drive
This action sends a GET request to the Google Drive API to retrieve a list of files based on specific query parameters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
File or Folder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Filename
Search Type
Drive
Folder
File Types
Maximum Number of Results
ActionThis is an event a Zap performs.SearchFind existing data in your appFilenameRequired
Search Type
Drive
Folder
File Types
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
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
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
ColumnsRequired
Row countRequired
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 found
Drive
Folder
Include Deleted Files?
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
Folder
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Drive
FolderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File to ReplaceRequired
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Drive
Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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.Delete File
This action will delete a file in Google Drive. You will need to provide the file ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FilenameRequired
Search Type
Drive
Folder
File Types
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder NameRequired
Search Type
Drive
Parent Folder
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder NameRequired
Search Type
Drive
Parent Folder
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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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
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
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Drive
Related categories
About Google Sheets
Related categories
