Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Google Sheets with PDF.co - no code necessary. See how you can get setup in minutes.
100%
Help
Google Sheets
Google Sheets
1. Choose trigger event
PDF.co
PDF.co
2. Choose action
1. Select the event
Setup
Test
Google Sheets
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New Spreadsheet Row (Team Drive)" from Google Sheets.
Add your action
An action happens after the trigger—such as "Add Barcode to PDF" in PDF.co.
You’re connected!
Zapier seamlessly connects Google Sheets and PDF.co, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Source Range
Required
Destination Range
Required
Paste Type
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Title
Required
Spreadsheet to Copy
Headers
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Drive
Spreadsheet
Required
Worksheet
Required
Row(s)
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Drive
Spreadsheet
Required
Worksheet
Required
Row(s)
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Row
Required
Background Color
Text Color
Bold
Italic
Strikethrough
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Cell Range
Required
Validation Type
Required
Input Message
Strict Validation
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet
Required
Worksheet
Required
Row
Required
Overwrite All Columns
Background Color
Text Color
Bold
Italic
Strikethrough
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Api_docs_info
Stop on error
Required
HTTP Method
Required
URL
Required
Query string parameters
Additional request headers
Body
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Drive
Spreadsheet Name
Required
Search Type
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet
Required
Worksheet
Required
A1 Range
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet
Required
Worksheet
Required
Row ID
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet
Required
Worksheet
Required
Lookup column
Required
Lookup value
Required
Supporting lookup column
Supporting lookup value
Search from last row
Row count
Action
This is an event a Zap performs.
Search
Find existing data in your app
Drive
Spreadsheet
Required
Title
Required
Overwrite existing worksheet with the same title
Headers
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
Barcode Value
Required
Barcode Type
Required
Source File URL (optional)
X Coordinate
Required
Y Coordinate
Required
Pages (optional)
Custom Profiles
Advanced Options
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Image URL
Required
X Coordinate
Required
Y Coordinate
Required
Width
Height
Pages
Advanced Options
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Message
Source File URL
Required
Custom Fields
Line Item Structure
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Barcode Type to Read (optional)
Pages (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Output Format
Required
Source File URL
Required
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)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Custom Classification Rules (optional)
CSV Rules URL (optional)
Enable Case Sensitive Custom Rules (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Message
Sender Email
Required
Recipient Email
Required
Email Subject
Required
SMTP Server
Required
SMTP Server Port
Required
SMTP Username
Required
SMTP Password
Required
CC (optional)
BCC (optional)
Email Body (Plain Text) (optional)
Email Body (HTML) (optional)
Attachment URLs (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Input Type
Required
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)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Automatically Convert Non-PDF Files (optional)
File Name (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
File Name (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Deletion Mode
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Text to Locate
Required
Replacement Image URL
Required
Pages (optional)
Enable Regular Expressions (optional)
Case-Sensitive Search (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Page Numbers/Ranges
Required
File Name (optional)
Custom Profiles (optional)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Source File URL
Required
Text Search String
Required
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)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
For AI agents & developers
Use Google Sheets and PDF.co with AI agents and code
Beyond Zap workflows. Call Google Sheets and PDF.co actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Google Sheets and PDF.co actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Create Spreadsheet Column
Add Barcode to PDF
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Practical ways you can use Google Sheets and PDF.co
Automatically store PDF data to Google Sheets
Avoid manual data entries by letting Zapier handle it. This automation kicks in whenever a PDF invoice or statement is processed via PDF.co. Zapier fetches the needed data using PDF.co and neatly organizes it in a pre-set Google Sheets spreadsheet. This boosts accuracy and saves time, letting business owners focus on decision-making over tedious tasks.
Ensure customer support data is always organized. When a PDF-based customer interaction like a case study or resolution sheet is generated through PDF.co, Zapier extracts the content and logs it into a centralized customer support tracking sheet on Google Sheets.
Keep track of every project's key details without the hassle. When a PDF-based project update or report is uploaded, Zapier extracts the data via PDF.co and maps it into structured rows within Google Sheets. This provides project managers with centralized, real-time dashboards for better task tracking and deadline management.
Learn how to automate Google Sheets on the Zapier blog
Learn how to automate PDF.co on the Zapier blog
Make work flow with AI
Level up your Google Sheets to PDF.co integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Google Sheets + PDF.co integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google Sheets and PDF.co
How do I integrate Google Sheets with PDF.co?
To integrate Google Sheets with PDF.co, you can use our platform to set up automated workflows. You'll need to create a trigger for your Google Sheets, like a new row being added, and then choose an action with PDF.co, such as converting the row data into a PDF document.
What triggers are available for Google Sheets in this integration?
In our integration with Google Sheets, you can set triggers such as 'New Spreadsheet Row', 'Updated Spreadsheet Row', or 'New Spreadsheet'. These triggers will initiate processes that involve actions from PDF.co.
Can I customize the PDF output in the Google Sheets and PDF.co integration?
Yes, you can customize the PDF output. During the setup of your action step with PDF.co after a trigger from Google Sheets, you can specify various conversion templates and options to format your output as required.
Is it possible to automate invoice generation using this integration?
Yes, automating invoice generation is possible. You can trigger the process when new data is added to Google Sheets - like an order entry - and configure our system to convert that data into a formatted invoice using PDF.co.
What happens if there is an error during the integration process?
If there's an error during the integration process between Google Sheets and PDF.co, you'll be notified through our platform. We provide detailed logs and error messages to help troubleshoot and rectify any issues swiftly.
Can I integrate multiple sheets within one spreadsheet using this setup?
Yes, you can integrate multiple sheets within one spreadsheet. Our workflow allows you to select specific sheets as part of your trigger configurations in Google Sheets.
Do I need technical skills to use this integration effectively?
No technical skills are necessary. Our user-friendly platform provides step-by-step instructions and intuitive interfaces that guide you through setting up integrations between Google Sheets and PDF.co effortlessly.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
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.
