Dropbox + Google Sheets + PDF.co Integrations
Dropbox + Google Sheets + PDF.co Integrations
Zapier lets you send info between Dropbox and Google Sheets and PDF.co automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Quickly automate Dropbox and Google Sheets and PDF.co workflows with Zapier's templates
Our most popular Zap!
Do even more with Dropbox + Google Sheets + PDF.co
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Dropbox, Google Sheets, and PDF.co. And don’t forget that you can add more apps and actions to create complex workflows.
FolderRequired
Check a specific folder for new folders. Keep clicking to go inside folders. Please note: new folders added to folders inside the folder you choose here will NOT trigger this Zap.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFolderRequired
Parent folder, like
/TextFiles/or/Documents/Taxes/.Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File you would like to move. Please use the Search powered field to find the file. Otherwise advanced users may type in full path name using Custom Value such as
/Folder1/Folder2/File Name.pdfNew LocationRequired
Where to move the file.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FolderRequired
Where to find the file that will be updated, or where to create the new file.
File NameRequired
Specify the name of the file. ".txt" will always be appended as the file extension.
File ContentRequired
Plain text content to append to the text file.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PathRequired
The path to be shared by the shared link, e.g.
/Documents/Taxesor/Documents/Taxes/notes.txt.Requested Visibility
The access permission that can be requested by the caller for the shared link. Note that the final resolved visibility of the shared link takes into account other aspects, such as team and shared folder settings.
Link Password
If Requested Visibility is Password this is needed to specify the password to access the link.
Expires At
Expiration time of the shared link. By default the link won't expire.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FolderRequired
The folder to search in, like
/TextFiles/or/Documents/Taxes/. Keep clicking to go inside folders.Folder NameRequired
Include Deleted Folders?
ActionThis is an event a Zap performs.SearchFind existing data in your appFolderRequired
The folder to search in, like
/TextFiles/or/Documents/Taxes/. Keep clicking to go inside folders.Search TermRequired
Include file contents?
Note: File contents greater than 100MB will cause an error. Set this to NO to exclude file contents and avoid errors.
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
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
value to be encoded into barcode
Barcode type to generate
Barcode type to use (QR Code is generated by default).
Generate output as datauri inline url
Set to
trueto generate inline image url that you can set as a source for images in html or email. These embedded images work without Internet required.Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here. You can also use user-controlled data encryption to encrypt output file.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Input TypeRequired
Select input type. For advanced options and html templates support, please use a separate
HTML To PDFmodule instead.InputRequired
Input. Set it based on the selected
Input Type. If you use G Drive, Dropbox or another then the link should be accessible without password.Name
Output PDF file name.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF.co API EndpointRequired
PDF.co API endpoint. Select endpoint or switch into the
Customand type endpoint path. For details please check PDF.co API Docs.URL input parameter override
Overrides
urlinput param forInput JSONbelow. Can be an a link,filetoken://(for files stored in PDF.co Files). Some API endpoints may also accept multiple links separated by comma (check API docs for more details). You can also use links documents in Google Docs, G Drive, Dropbox (these links be accessible without a password or login).Input JSON
Input JSON with parameters as input. For source code samples please check PDF.co API Docs
Run As Async Job
Set to
trueto force async job mode and to automatically wait for async job completion. Equal to settingasyncparam totruein the input json. It will check background job status in a loop usingv1/job/checkmethod until it returnsstatusassuccessorfailed. When turned off, action will send API call and will return immediately.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InputRequired
Input source. Can be an url, link to
filetoken://(for files stored in PDF.co Files). You can also use links to documents or files at Google Drive, Google Docs Dropbox or similar services (link should be accessible without login).Template Id
ID of the document parser template. Manage your templates on this page
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Extract information about fillable fields from PDF form.
Set to
trueto extract information about current fillable fields available.Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF URLRequired
Url to the source PDF, PNG, TIFF, JPG or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.OCR Language
Sets OCR (Optical Character Recognition) language to be used for extracting text from scanned PDF, PNG, JPG documents. English is default.
Name
File name for new PDF file.
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Direct link to source PDFRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.ModeRequired
Select Mode for Action
Angle
Angle in degrees. Uses AI to automatically to fix rotation of pages inside scanned PDF based on text analysis. To change text language change
OCR LanguageparameterOCR Language for Auto-Rotation
Change OCR (Optical Character Recognition) language to be used when searching text inside scanned PDF. English is default.
Pages
Optionally set which pages to process. Set comma-separated list of page indices (or ranges) to split to. For
Rotate Pagesfirst page is 0 (zero), and forDelete Pagesfirst page is 1 (one). Example: "1,2-5,7-".Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source PDF (optional)
Url to the input PDF document,
filetoken://..link for PDF.co File or leave blank to create new PDF. If you use G Drive, Dropbox or another then the link should be accessible without password.Text objects
Each text object should be defined as
x;y;page;textwhere;is the separator between params. Advanced version:x;y;pages;text;fontsize+bold+italic+underline+strikeout;fontname;fontcolor;link;transparent;width;height;alignment. Pages starts at0(zero), set multiple pages as comma-separated ranges like0,1-2,5,7-where7-means pages from 7th to the last one. Use dash for a range (ex.-2= from second to the last page). Use!to count page index from the last page, for example!0means the very last page,!1means penultimate page and so on. Example:20;20;0-;Sample Textor20;20;0-;Sample Text;24+bold+italic+underline+strikeout;Arial;FF0000;www.pdf.co;false;120;100;right.If you need to insert
;symbol then escape it with\like this\;.To get
XandYcoordinates in your PDF file please use PDF.co Simple PDF Viewer.Images and PDF embeds
Insert image from JPG, PNG, GIF or PDF. Each image or pdf is defined as
x;y;page;urltoimageorpdf;link;width;heightwhere;separates parameters. Page index starts at0or use page ranges:0,1-2,5,7-.7-means from 7th page to the last one. Use!to for inverted page index:!0means the very last page,!1means pennultimate page etc.Example:
20;80;0-;bytescout-com.s3-us-west-2.amazonaws.com/files/demo-files/cloud-api/pdf-edit/logo.png. Advanced example:20;80;0-;bytescout-com.s3-us-west-2.amazonaws.com/files/demo-files/cloud-api/pdf-edit/logo.png;www.pdf.co;200;200.Find
XandYcoordinates using Simple PDF Viewer. You can also usefiletoken://for images or pdf from PDF.co Files also works withdatauri. You can create datauri for a signature here or convert image to datauri here.Fillable Fields
Value to fill into a fillable field should be defined as:
page;fieldName;valueor10;10;0;some text here;14;Arialwhere;is the separator between params. View field names in pdf forms using this tool or useGet PDF Infoaction.To flatten output PDF (to turn input fields into non-editable text) use
profilesas instructed in this KB. You can also use macros to add page numbers or to use square brackets for template data, for details check this KB article.Output PDF Name
Output PDF file name
Allow empty text and image objects
Enable this to allow empty text objects and images with empty url. Enable to if you need to suppress errors on empty text or image objects.
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Auto-trim Input Values
auto-trim input text values from leading and trailing spaces, line breaks etc.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Template Data
Optional input data. Optional JSON data that you can reference inside annotations and fields like this:
[[variable1]]with JSON data like{ 'variable1': 'hey hey'}. Please check this KB article for more details and workaround regarding zapier restrictions on using curly brackets{{ }}for template property.Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible via link.Mode
Select Mode for Action.
Owner Password
The owner (main) password that is used for setting restrictions and encryption of a document. You can also encrypt-decrypt PDFs with user-controlled data encryption.
User Password
Optional user password that is required when viewing or printing a document. You can also encrypt-decrypt PDFs with user-controlled data encryption.
Encryption Level
Encryption Algorithm to be used for PDF built-in encryption. AES-128 or higher is recommended. You can also encrypt-decrypt PDFs with user-controlled data encryption.
Printing
Allow or prohibit printing PDF document. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Printing Quality
Allowed printing quality. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Document Assembly
Allow or prohibit assembling the document. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Content Copying
Allow or prohibit copying content from PDF document. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Content copying for Accessibility
Allow or prohibit content extraction for accessibility needs. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Modify Document
Allow or prohibit modification of PDF document. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Filling of form fields
Allow or prohibit filling of interactive form fields (including signature fields) in PDF document. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Commenting
Allow or prohibit interacting with text annotations and forms in PDF document. Note: this restriction applies when
userPassword(if any) is entered. This restriction does not apply if user entersOwner Password.Name
Base file name for new PDF files.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Direct link to source PDFRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Text to Search
Enter text to search inside PDF. Maximum search and replacement limit is five.
Text to Replace With
Enter text to replace with.
Note: search text and replace text will be replaced in the order of entry. Also make sure to enter the exact number of search and replacement text.
Use Regular Expressions
Enable regular expressions. For example, to find SSN use
[0-9]{3}-[0-9]{2}-[0-9]{4}.Case Sensitive?
Is Search Case Sensitive?
Pages
Optionally set which pages to search in. Set comma-separated list of page indices (or ranges) to split to. First page is 0 (zero). Example: "0,1-5,7-".
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Direct link to source PDFRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Text to searchRequired
Enter text to search inside PDF.
Use Regular Expressions
Enable regular expressions. For example, to find SSN use
[0-9]{3}-[0-9]{2}-[0-9]{4}.Pages
Optionally set which pages to search in. Set comma-separated list of page indices (or ranges) to split to. First page is 1 (one). Example: "1,2-5,7-".
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
Flatten Output
Make output data as a single list for easier re-use
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Barcode To SearchRequired
To search for a barcode use macros string:
[[barcode:<barcodeTypesSeparatedByComma> <barcodeValue>]]. Example:[[barcode:qrcode]]. Visit documentation for more information.Exclude Pages With Found Barcode
Set to True if you want to exclude pages where barcode was found. False by default.
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Name
Base output file name for new PDF files.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
FolderRequired
Check a specific folder for new files. Keep clicking to go inside folders. Please note: new files added to folders inside the folder you choose here will NOT trigger this Zap.
Include file contents?
Note: File contents greater than 100MB will cause an error. Set this to NO to exclude file contents and avoid errors.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFolderRequired
Where to save the file.
FileRequired
Must be a file object from another service (or some URL).
Overwrite
Whether we should overwrite this file (if one of the same name exists) or not.
Specify File Name
Advanced: By default, we use the same name as the file from the trigger. If you need to change the name, enter a value here. The original file extension will be appended.
Specify File Extension
Advanced: If you specify a file name, you can also specify an extension (include the initial ".").
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FolderRequired
Where to save the new file.
File NameRequired
Specify the name of the file. ".txt" will always be appended as the file extension.
File ContentRequired
Plain text content to put inside the new text file.
Overwrite
Whether we can overwrite this file (if one of the same name exists) or not.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File you would like to rename. Please use the Search powered field to find the file. Otherwise advanced users may type in full path name using Custom Value such as
/Folder1/Folder2/File Name.pdfNew NameRequired
What you'd like to rename the file too (without extension, ie .pdf).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Dropbox are located here http://dropbox.github.io/dropbox-sdk-js/Dropbox.html
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FolderRequired
The folder to search in, like
/TextFiles/or/Documents/Taxes/. Keep clicking to go inside folders.File NameRequired
Include Deleted Files?
Include file contents?
Note: File contents greater than 100MB will cause an error. Set this to NO to exclude file contents and avoid errors.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
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
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundinput URLRequired
Url to the source PDF, PNG, JPG, TIFF or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Barcode type to read
Pages to read from
Comma-separated list of page indices (or ranges) to process. Leave empty for all pages. First page is 0 (zero)! Example: “0,2-5,7-”.
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Output FormatRequired
Select Output Format
PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Pages
Comma-separated list of page indices (or ranges) to process. Leave empty for all pages. First page is 0 (zero). Example: "0,1-2,5-".
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Name
Output file name.
Inline output
Set to
trueto return extracted content right away asbodyvariable. By default a link to output file will be returned inurlvariable.OCR Language
Sets OCR (Optical Character Recognition) language to be used for extracting text from scanned PDF, PNG, JPG documents. English is default.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Input URLRequired
Url to the input PDF document,
filetoken://..link for PDF.co File Storage. If you use G Drive, Dropbox or similar then the link should be accessible without password.Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
Set custom rules
Optionally define classification rules in CSV format. Every row comes in this form:
classname,logic,keyword1,keyword2. Example:Amazon,AND,Amazon AWS,AWS Invoice. Check this page for more instructions.Load custom rules from CSV via url
Link to CSV with custom classification rules. Every row comes in this form:
classname,logic,keyword1,keyword2. Example:Amazon,AND,Amazon AWS,AWS Invoice. Check this page for more instructions.Case Sensitive Custom Rules Enabled
Defines if keywords in rules are case sensitive or not
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From email addressRequired
From email address. To find how to get SMTP configuration please check this page
To email addressRequired
To email address. To find how to get SMTP configuration please check this page
SubjectRequired
Subject for email to send. To find how to get SMTP configuration please check this page
CC
CC for email to send. To find how to get SMTP configuration please check this page
BCC
BCC for email to send. To find how to get SMTP configuration please check this page
bodytext
Plain text body for email to send. To find how to get SMTP configuration please check this page
bodyhtml
HTML text body for email to send. To find how to get SMTP configuration please check this page
SMTP serverRequired
Smtp server address. To find how to get SMTP configuration please check this page
SMTP server portRequired
Smtp server port. To find how to get SMTP configuration please check this page
SMTP usernameRequired
Smtp server password. To find how to get SMTP configuration please check this page
SMTP passwordRequired
Smtp server password. To find how to get SMTP configuration please check this page
Attachments to include from links to PDFs, documents or images
The comma-separated list of links to add as attachments (PDFs, documents, spreadsheets, images).
Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTML Template Id (optional)
Set ID of your Html template (a number). Find the ID at PDF.co HTML templates page or set to
1to use built-in HTML template.Input HTML or URL to convert (optional)
Or enter HTML or URL to convert from.
To generate large HTML files enable not to wait for full load or use a custom API call with a background job based approach.
Page Orientation
Select PDF page orientation.
Page Size
Select PDF paper size. To set a custom paper size please use
Override Paper Sizefield below.Page Size Override
Use this field to override PDF paper size as
width heightformat. You can addpx,mmorin(inches). Example:200 300,200px 300px,200mm 300mm,20cm 30cmor6in 8in.Margins Override
Override default margins with custo values (the order is
top right bottom left). You can als set all margins:10px,5mm,5infor all sides.Print Background
Set to
falseto disable printing of background.MediaType to use
Set to
screento use screen for HTML to PDF orprintto convert as for printing (default).Do not wait until full page load
Set to
trueto skip waiting for a full load. Useful to speed up conversion of dynamic pages with dynamic video or data.HTML Template Data (for HTML templates)
Set JSON or CSV for input data.
Name
Base file name for new PDF files.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config to inject javascript, to adjust HTML etc. You can also encrypt output PDF with user-controlled data encryption. Check the collection of sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List of links to source PDFs, documents or imagesRequired
The comma-separated list of links to PDFs, documents, spreadsheets, images. Enable
Auto-convertoption to support non-PDF files. Supports links to external sites,filetoken://..from PDF.co Files storage and links to G Drive, Dropbox and other services. Links should be accessible without password. For password protected PDF files, use PDF Security module first to unlock input pdf.Auto-convert non-PDF files
Auto-convert doc, docx, xls, jpg, png, msg, eml to pdf before merging. Important: uses
pdf/merge2endpoint for non-pdf files and consumes more credits.Name
File name for output PDF.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Input PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Name
File name for output PDF.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can adjust compression options using this parameter. Check sample compression configurations here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InputRequired
Url to the input PDF document,
filetoken://..link for PDF.co File or leave blank to create new PDF. If you use G Drive, Dropbox or another then the link should be accessible without password.Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Direct link to source PDFRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Text to Search
Enter text to search and delete inside PDF. Maximum search and delete limit is five.
Use Regular Expressions
Enable regular expressions. For example, to find SSN use
[0-9]{3}-[0-9]{2}-[0-9]{4}.Case Sensitive?
Is Search Case Sensitive?
Pages
Optionally set which pages to search in. Set comma-separated list of page indices (or ranges) to split to. First page is 0 (zero). Example: "0,1-5,7-".
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Direct link to source PDFRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Text to Search
Enter text to search inside PDF.
Replace Image Url
URL of Image to be inserted as a text replacement.
Use Regular Expressions
Enable regular expressions. For example, to find SSN use
[0-9]{3}-[0-9]{2}-[0-9]{4}.Case Sensitive?
Is Search Case Sensitive?
Pages
Optionally set which pages to search in. Set comma-separated list of page indices (or ranges) to split to. First page is 0 (zero). Example: "0,1-5,7-".
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.PagesRequired
Comma-separated list of page indices (or ranges) to split into. First page is 1 (one). Example: "1,2-5,7-". Special cases: to extract each page into separate PDF use to
*.Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Name
Base file name for new PDF files.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PDF URLRequired
Url to the source PDF document or
filetoken://..link from PDF.co Files storage. If you use G Drive, Dropbox or another then the link should be accessible without password.Text To SearchRequired
Text to search for on pages.
Case Sensitive
Set to True to enable case sensitive search. False by default.
Use Regular Expressions
Set to True to enable regular expressions for search string. False by default.
Exclude Pages With Found Text
Set to True if you want to exclude pages where text was found. False by default.
OCR Language
Change OCR (Optical Character Recognition) language to be used when searching text inside scanned PDF. English is default.
Password
PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with
AESencryption/decryption viaProfilesfield.Name
Base output file name for new PDF files.
Output links expiration
Optional. Expiration in minutes for output links. Default is
60minutes. You can increase it if you use useBusiness Planand higher, check plans here.Async Job Check IntervalRequired
(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.
Custom Profiles
Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How to connect Dropbox + Google Sheets + PDF.co
- Step 1: Authenticate Dropbox, Google Sheets, and PDF.co.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Dropbox
Dropbox lets you store your files online, sync them to all your devices, and share them easily. Get started for free, then upgrade for more space and security features.
Related categories
Similar apps
Google Drive
File Management & Storage, Google
Box
File Management & Storage
OneDrive
File Management & Storage, Microsoft
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreRelated categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
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.
Learn moreRelated categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.
Other Dropbox + Google Sheets Integrations
- gravity-forms
- code
- vimeo
- jotform
- google-forms
- candidatezip
- trello
- slack
- hubspot
- cognito-forms
- wordpress
- wistia
- smtp
- microsoft-outlook
- google-docs
- amazon-s3
- onedrive
- wufoo
- wpforms
- wix-automations
- vonage-business-communications
- url-shortener
- todoist
- schedule
- placid
- pandadoc
- mailchimp
- freshbooks
- email-parser
- docusign
- docparser
- asana
- zoho-creator