Google Sheets + PDF.co
Search and replace text in pdfs with PDF.co when new spreadsheet rows are added in Google Sheets
Get your text modifications done as soon as you add a new row in Google Sheets, thanks to this automation. With it, every new row entry in Google Sheets will prompt a search and replace operation in an existing PDF document on PDF.co. The result? An efficient way of updating documents based on spreadsheet updates, giving you more time to focus on tasks that matter.
Get your text modifications done as soon as you add a new row in Google Sheets, thanks to this automation. With it, every new row entry in Google Sheets will prompt a search and replace operation in an existing PDF document on PDF.co. The result? An efficient way of updating documents based on spreadsheet updates, giving you more time to focus on tasks that matter.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Search and Replace Text in PDFLocate and replace specified text within a PDF document
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 ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
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.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
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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 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
Font Size
Color
Bold
Strikeout
Underline
Font Name
Pages
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Barcode ValueRequired
Barcode Type (optional)
Generate Inline URL (optional)
Custom Profiles (optional)
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.
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text 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
Headers
Overwrite existing worksheets
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.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About PDF.co
PDF.co is a set of tools for PDF file and data extraction. Get CSV out of pdf, spreadshets, barcodes, invoices. Also can split pdf, merge pdf, convert pdf.
Related categories
Related Zap Templates
- 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
- Add barcodes to Google Sheets from new Dropbox folders using PDF.co
- Generate barcodes from new rows in Google Sheets and upload to Dropbox
- Convert new cell URL values in Google Sheets spreadsheet rows to PDF format using PDF.co
- Convert new Google Sheets rows to pdfs with PDF.co
- Add form fields to PDF.co from new or updated Google Sheets rows
- Convert HTML to PDFs with PDF.co and email results with new Google Sheets rows
- Send emails with auto-fill PDF forms from PDF.co for new 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
- 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
- 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
Related Zap Templates
- Convert new or updated Google Sheets rows to pdfs with PDF.co's anything to pdf converter
- Generate barcodes from new rows in Google Sheets and upload to Dropbox
- 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
- Fill pdfs in PDF.co whenever new or updated rows occur 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
- Convert HTML to PDFs with PDF.co and email results with new Google Sheets rows
- Parse documents in PDF.co whenever new or updated rows appear in Google Sheets
- Convert new or updated Google Sheets rows to pdfs with PDF.co
- Add barcodes to Google Sheets from new Dropbox folders using PDF.co
- Convert new Google Sheets rows to pdfs with PDF.co
- Send emails with auto-fill PDF forms from PDF.co for new Google Sheets rows
- 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