URL of the source file which can be a PDF, PNG, TIFF, or JPG format. Also accepts filetoken://.. link from PDF.co Files storage. Please ensure the link is publicly accessible if stored in Google Drive, Dropbox, etc.

Specify the language for OCR (Optical Character Recognition) when extracting text from scanned documents. The default language is English.

The filename for the newly created searchable PDF.

If the PDF document is protected, please provide the password. For unprotected documents, leave this field empty. For user-controlled encryption/decryption with AES, use the Profiles field.

Sets the expiration duration (in minutes) for the output links. The default is 60 minutes. Longer durations can be set if you're using the Business Plan or higher. For more information, visit our subscriptions page.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Option): Set the interval (in seconds) for checking the status of the async job. For longer jobs, increase this value; for faster jobs, decrease it. Only applicable if Job Execution Mode is Async (Up to 35 sec).

If you have any custom profiles, you can set them here. For samples of custom profiles, visit our API docs.

Provide a direct URL to the PDF file or a filetoken://.. link from PDF.co Files storage. Ensure the link is accessible publicly if hosted on G Drive, Dropbox, or similar platforms.

Choose the operation mode: either to rotate or delete pages.

Specify the rotation angle in degrees. The AI automatically fixes rotation of pages in scanned PDFs based on text analysis. Adjust the OCR language to change text language.

Specify the OCR (Optical Character Recognition) language for text recognition inside scanned PDFs. The default language is English.

Specify the pages to process. Use a comma-separated list of page indices or ranges. For Rotate Pages, the first page is 0, and for Delete Pages, it is 1. Example: "1,2-5,7-".

Set the expiration time in minutes for output links. The default is 60 minutes. Increase the duration if you have a Business Plan or higher. Check subscription plans here.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Option): Set the interval for asynchronous job checks (in seconds). Increase the duration for longer jobs and decrease for shorter ones. Only applicable if Job Execution Mode is Async (Up to 35 sec).

Set a custom configuration, if any. View sample custom profiles here.

Provide the URL to the input PDF document, a filetoken://.. link for PDF.co File, or leave blank to create a new PDF. If you use Google Drive, Dropbox, or other cloud storage platforms, ensure that the link is publicly accessible without a password.

PDF document password. Leave empty for unprotected documents. You can also use user-controlled data encryption with AES encryption/decryption via Profiles field.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced) Adjust the interval (in seconds) at which the system checks the status of asynchronous jobs. Increase this for longer jobs, decrease for shorter jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

If you have any custom profiles, you can set their configurations here. Check sample custom profiles here.

Enter the URL of the source PDF document or a filetoken://.. link from PDF.co Files storage. If using Google Drive, Dropbox or similar, ensure the link is accessible without a password.

Specify the text to find and delete within the PDF. The maximum limit is five search and delete operations per task.

Toggle this to enable regular expressions in your search. For example, use [0-9]{3}-[0-9]{2}-[0-9]{4} to find SSN patterns.

Toggle this to make your search case-sensitive.

Specify the pages to search in. Enter a comma-separated list of page indices (or ranges). Note: The first page is 0. For example: "0,1-5,7-".

If your PDF is password-protected, enter the password here. For unprotected documents, leave this field blank. For user-controlled data encryption, use AES encryption/decryption via the Profiles field.

Set the expiration time (in minutes) for output links. Default is 60 minutes. Increase this if you're using a Business Plan or higher. Check out our subscription plans.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Setting): Adjust the interval for checking the status of async jobs (in seconds). Set a longer interval for larger jobs or a shorter one for smaller jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

Here you can define any custom profiles if necessary. You can configure specific settings for the PDF process. Check sample custom profiles here.

Enter the URL of the source PDF document or a filetoken://.. link from PDF.co Files storage. If you are using Google Drive, Dropbox, or similar, ensure the link is accessible without a password.

Specify the text you wish to find within the PDF.

Enter the URL of the image that will replace the found text.

Toggle this to enable the use of regular expressions in your search. For example, use [0-9]{3}-[0-9]{2}-[0-9]{4} to find patterns matching a Social Security Number.

Toggle this to make your search case-sensitive.

Optionally specify the pages to search in. Enter a comma-separated list of page indices (or ranges). Note: The first page is 0. For example: "0,1-5,7-".

If your PDF is password-protected, enter the password here. For unprotected documents, leave this field blank. For user-controlled data encryption, use AES encryption/decryption via the Profiles field.

Set the expiration time (in minutes) for output links. Default is 60 minutes. Increase this if you're using a Business Plan or higher. Check out our subscription plans.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Setting): Adjust the interval for checking the status of async jobs (in seconds). Increase the value for longer jobs, decrease for faster jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

If you have any custom profiles, you can configure them here. To see examples of custom profiles, visit this link.

Provide a direct URL to the source PDF document or a filetoken://.. link from PDF.co Files storage. The URL should be accessible without a password if you use Google Drive, Dropbox, or similar platforms.

Provide a comma-separated list of page indices or ranges for splitting the PDF. The first page is 1. Example: "1,2-5,7-". Special case: use "*" to extract each page into a separate PDF.

If the PDF document is password-protected, enter the password here. Leave this field empty for unprotected documents. You can also use user-controlled data encryption with AES encryption/decryption via the Profiles field.

Specify the base filename to be used for the new PDF files.

Set the expiration time in minutes for the output links. The default time is 60 minutes. If you are using the Business Plan or higher, you can increase this time. Check the available plans here.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced): Adjust the interval in seconds for checking the status of the async job. Increase the value for longer jobs, and decrease it for faster jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

If you have any custom profiles, you can configure them here. Check the sample custom profiles here.

Provide a direct URL to the source PDF document or a filetoken://.. link from PDF.co Files storage. Ensure the URL is accessible without a password if you use Google Drive, Dropbox, or similar platforms.

Enter the text to search for within the PDF pages.

Set this to True to make the search case sensitive. The default setting is False.

Set this to True to use regular expressions in the search string. The default setting is False.

Set this to True if you want to exclude pages where the text was found. The default setting is False.

Specify the OCR (Optical Character Recognition) language to use when searching text within scanned PDFs. The default language is English.

Enter the password if the PDF document is password-protected. Leave this field empty for unprotected documents. You can also use user-controlled data encryption with AES encryption/decryption via the Profiles field.

Specify the base filename to be used for the new PDF files.

Set the expiration time in minutes for the output links. The default time is 60 minutes. If you are using the Business Plan or higher, you can increase this time. Check the available plans here.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced): Adjust the interval in seconds for checking the status of the async job. Increase the value for longer jobs, and decrease it for faster jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

Custom profiles (if any). You can set a custom config here. Check sample custom profiles here.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Check a specific folder for new files. Keep clicking to go inside folders. Please note: new files added to subfolders inside the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Check a specific folder for updated files. Keep clicking to go inside folders. Please note: files updated within 5 minutes after creation or located in subfolders of the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.

Should this trigger also on files that are deleted?

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.

A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information

If yes, we will tell Google to convert this into an editable document.

By default, we use the same name and extension as the original file.

Advanced: Can only be used if you also specify a file name.

File to Move

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Destination folder to move into. Keep clicking to drill down into child folders.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Folder to find/replace this file into. Keep clicking to drill down into child folders. Places at the top-level if none picked.

A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information

If yes, we will tell Google to convert this into an editable document.

By default, we use the same name and extension as the original file.

Advanced: Can only be used if you also specify a file name.

File to create a shortcut to

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Destination folder for shortcut. Keep clicking to drill down into child folders.

API docs for Google Drive are located here https://developers.google.com/drive/api/v3/reference

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

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.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Select where to create this new folder. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.

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.

You must have column headers

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.

You must have column headers

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.

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.

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.

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.

Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.

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.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

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.

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.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

True if the text is bold.

True if the text is italicized.

True if the text is strikethrough.

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.

API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

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.

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.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

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.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

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)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

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.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

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)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

Provide a comma-separated list of URLs to the documents or images you wish to merge. To include non-PDF files, enable the Auto-convert option. Supports external links, filetoken://.. from PDF.co Files storage, and links to Google Drive, Dropbox, etc. Ensure links are publicly accessible. For password-protected PDFs, use the PDF Security module to unlock them first.

Enable this option to auto-convert DOC, DOCX, XLS, JPG, PNG, MSG, EML files to PDF before merging. Note: this uses the pdf/merge2 endpoint for non-PDF files and may consume more credits.

The filename for the merged PDF document.

Optional. Expiration in minutes for output links. Default is 60 minutes. You can increase it if you use use Business Plan and higher, check plans here.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Option): Adjust the check interval (in seconds) for the async job status. Increase for longer jobs, decrease for faster jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

Set your custom profiles here, if any. For examples of custom profiles, visit our API docs.

If your PDF is password-protected, enter the password here. Leave empty for unprotected documents. For user-controlled encryption/decryption with AES, use the Profiles field.

Enter the Job ID provided by PDF.co.

(Advanced): Adjust async job check interval (in seconds). Increase for longer jobs, decrease for fast jobs.

If enabled, this option automatically extracts the content from the response link (applicable for JSON, CSV, Text formats) and incorporates it directly into the output.

Provide the URL of the source PDF document or a filetoken://.. link from PDF.co Files storage. If you are using Google Drive, Dropbox or another service, the link should be accessible.

Choose whether to add or remove security features from the PDF file.

Define the owner password used for setting restrictions and encryption. You can also use user-controlled data encryption.

Set an optional user password required for viewing or printing the document. You can use user-controlled data encryption.

Choose the encryption algorithm for the built-in PDF encryption. AES-128 or higher is recommended. Use user-controlled data encryption for more control.

Set whether the PDF document can be printed. Note: This restriction applies when the user password is entered. If the owner password is entered, this restriction does not apply.

Specify the printing quality allowed for the PDF. Note: If a userPassword is provided, this restriction applies. However, it is bypassed if the Owner Password is used.

Choose whether to allow or prohibit document assembly. Note: This restriction takes effect if a userPassword is used. If the Owner Password is used, this restriction is ignored.

Choose whether to allow or prohibit content copying from the PDF document. Note: This restriction takes effect if a userPassword is used. If the Owner Password is used, this restriction is ignored.

Choose whether to allow or prohibit content extraction for accessibility needs. Note: This restriction takes effect if a userPassword is used. If the Owner Password is used, this restriction is ignored.

Choose whether to allow or prohibit the modification of the PDF document. Note: This restriction takes effect if a userPassword is used. If the Owner Password is used, this restriction is ignored.

Choose whether to allow or prohibit filling of interactive form fields (including signature fields) in the PDF document. Note: This restriction takes effect if a userPassword is used. If the Owner Password is used, this restriction is ignored.

Choose whether to allow or prohibit interactions with text annotations and forms in the PDF document. Note: This restriction takes effect if a userPassword is used. If the Owner Password is used, this restriction is ignored.

Provide a base file name for the new PDF files.

Optionally, set an expiration time in minutes for output links. Default is 60 minutes. You can increase it if you use the Business Plan or higher, check plans here.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Setting): Adjust the interval for checking the status of async jobs (in seconds). You can increase the interval for longer jobs or decrease it for faster ones. Only applicable if Job Execution Mode is Async (Up to 35 sec).

Here you can define any custom profiles if necessary. You can configure specific settings for the PDF process. Check sample custom profiles here.

Enter the URL of the source PDF document or a filetoken://.. link from PDF.co Files storage. If using Google Drive, Dropbox, or similar, ensure the link is accessible without a password.

Specify the text to find within the PDF. The maximum limit is five search and replace operations per task.

Enter the text that will replace the found text. Note: the search and replace operations will be carried out in the order of entry. Ensure the number of search and replacement text entries match.

Toggle this to enable regular expressions in your search. For example, use [0-9]{3}-[0-9]{2}-[0-9]{4} to find SSN patterns.

Toggle this to make your search case-sensitive.

Specify the pages to search in. Enter a comma-separated list of page indices (or ranges). Note: The first page is 0. For example: "0,1-5,7-".

If your PDF is password-protected, enter the password here. For unprotected documents, leave this field blank. For user-controlled data encryption, use AES encryption/decryption via the Profiles field.

Set the expiration time (in minutes) for output links. Default is 60 minutes. Increase this if you're using a Business Plan or higher. Check out our subscription plans.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced Setting): Adjust the interval for checking the status of async jobs (in seconds). Set a longer interval for larger jobs or a shorter one for smaller jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

Here you can define any custom profiles if necessary. You can configure specific settings for the PDF process. Check sample custom profiles here.

Provide the URL to the PDF document you wish to search or a filetoken://.. link from the PDF.co Files storage. Make sure the URL is accessible without a password if using Google Drive, Dropbox, or another cloud storage service.

Specify the text you wish to search for within the PDF document.

If you need more complex search patterns, enable this to use regular expressions. Example: To find an SSN, use [0-9]{3}-[0-9]{2}-[0-9]{4}.

Specify the pages you want to search within the PDF. Use a comma-separated list of page numbers or ranges. The first page starts at 1. Example: "1,2-5,7-".

If the PDF document is password-protected, enter the password here. For unprotected documents, leave this field empty. For user-controlled data encryption, use AES encryption/decryption via the Profiles field following the instructions here.

Set how long (in minutes) the output links should remain valid. The default is 60 minutes. If you are using the Business Plan or higher, you can increase this duration. Check your subscription plan details.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

This is an advanced setting. Adjust the interval (in seconds) at which the status of the PDF.co job is checked. For longer jobs, increase the interval; for quicker jobs, decrease it. Only applicable if Job Execution Mode is Async (Up to 35 sec).

If you have any custom profiles, you can enter their configuration here. Check sample custom profiles.

Enable this if you want the output data to be consolidated into a single list. This is useful for easier data re-use.

Provide a direct URL to the source PDF document or a filetoken://.. link from PDF.co Files storage. Ensure the URL is accessible without a password if you use Google Drive, Dropbox, or similar platforms.

Enter the barcode macro string to search for in the format: [[barcode:<barcodeTypesSeparatedByComma> <barcodeValue>]]. For example: [[barcode:qrcode]]. Visit the documentation for more details.

Set this to True if you want to exclude pages where a barcode was found. The default setting is False.

Enter the password if the PDF document is password-protected. Leave this field empty for unprotected documents. You can also use user-controlled data encryption with AES encryption/decryption via the Profiles field.

Specify the base filename to be used for the new PDF files.

Set the expiration time in minutes for the output links. The default time is 60 minutes. If you are using the Business Plan or higher, you can increase this time. Check the available plans here.

Determines how the PDF.co job is executed. Choose Async (Up to 35 sec) to execute the job in async mode suitable for jobs that take up to 35 seconds. Choose Async For Large Docs (need to run Job Check module separately) for larger jobs that could take up to 5 minutes - remember to run the Job Check module separately for this. Default is Async (Up to 35 sec).

(Advanced): Adjust the interval in seconds for checking the status of the async job. Increase the value for longer jobs, and decrease it for faster jobs. Only applicable if Job Execution Mode is Async (Up to 35 sec).

If you have any custom profiles, you can configure them here. Check the sample custom profiles here.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Check a specific folder for new subfolders. Keep clicking to go inside folders. Please note: new folders added to subfolders inside the folder you choose here will NOT trigger this Zap. Defaults to the top-level folder if none is picked.

File to Copy

If yes, we will tell Google to convert this into an editable document.

By default, we name the new copy as "Copy of {original file name}".

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Folder to put the new copy into. Keep clicking to drill down into child folders. Defaults to the same folder as the source file's.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Select where to create this new folder. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.

Use plain text.

If yes, we will tell Google to convert this into an editable document.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

This will add a group that the file is shared with, but not remove any existing groups it is shared with. Sharing with an organization is only valid for G Suite users.

Domain name of your G Suite organization (required if you chose a "Sharing Preference" that includes your organization). Example: yourcompany.com

Determines which App Extensions will appear in the dropdown below.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Restrict the search to specific file types. If you only want a single file extension, you can simply add that to the name search above.

The drive to use. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Shared Drives, you can select it here.

Folder where to place file. Keep clicking the dropdown to go inside folders. Defaults to the top-level folder if left blank.

Restrict the search to specific file types. If you only want a single file extension, you can simply add that to the name search above.

A file to be uploaded. Can be an actual file or a public URL. See this help doc for more information

If yes, we will tell Google to convert this into an editable document.

By default, we use the same name and extension as the original file.

Advanced: Can only be used if you also specify a file name.

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.

You must have column headers

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.

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.

You must have column headers

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.

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.

The column position (zero-based) to insert. If not set, append to the right by default.

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.

Create a duplicate of an existing spreadsheet.

These Headers are ignored if a "Spreadsheet to Copy" is selected.

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.

Use a search step before this to get the row to delete.

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.

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.

Determines which App Extensions will appear in the dropdown below.

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.

You must have column headers. See here for more information.

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.

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)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet?

Number of rows to return. Max is 500.

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.

You must have column headers. See here for more information.

Let us know which columns to return. e.g. A:Z

Number of rows to return. Max is 500.

Number of the first row to return (1 is the header)

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.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.