Google Sheets + PDF.co
Extract pdf information with PDF.co when new or updated rows are added to Google Sheets team drive
Keep track of essential PDF data sourced from your team's Google Sheets without extra work. With this workflow, any new or updated row in your Google Sheets documents triggers a process to obtain detailed PDF information via PDF.co. It efficiently streamlines your document management, making sure you quickly get the information you need from any PDF linked in your spreadsheets.
Keep track of essential PDF data sourced from your team's Google Sheets without extra work. With this workflow, any new or updated row in your Google Sheets documents triggers a process to obtain detailed PDF information via PDF.co. It efficiently streamlines your document management, making sure you quickly get the information you need from any PDF linked in your spreadsheets.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Get PDF InformationExtract information from a PDF document such as page count, page size, author, description, keywords and also any form field information.
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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
Advance Options
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message
Source File URLRequired
Custom Fields
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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)
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 rows to pdfs with PDF.co
- Add barcodes to Google Sheets from new Dropbox folders using PDF.co
- 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
- 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
- Parse documents in PDF.co whenever new or updated rows appear in Google Sheets
- 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
- 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
Related Zap Templates
- Extract data from new PDFs in Google Drive with PDF.co and add to multiple rows in Google Sheets
- Add barcodes to Google Sheets from new Dropbox folders using PDF.co
- Add form fields to PDF.co from new or updated Google Sheets rows
- Create pdf fillers in PDF.co for every new worksheet 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
- Convert new Google Sheets worksheets to PDF file format using PDF.co
- Convert new Google Sheets rows into pdfs using PDF.co's html to pdf converter
- Fill pdfs in PDF.co whenever new or updated rows occur in Google Sheets
- Search and replace text in pdfs with PDF.co when new spreadsheet rows are added in Google Sheets
- Convert new Google Sheets rows to pdfs with PDF.co
- Convert new cell URL values in Google Sheets spreadsheet rows to PDF format using PDF.co
- Parse documents in PDF.co whenever new or updated rows appear 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