Dropbox + Google Sheets + PDF4me Integrations
How to connect Dropbox + Google Sheets + PDF4me
Zapier lets you send info between Dropbox and Google Sheets and PDF4me automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Dropbox + Google Sheets + PDF4me
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 PDF4me. 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.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.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
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 foundFlow Name
Name of the PDF4me Workflow Trigger. To know more about filling the fields, please refer to our documentation for guidelines.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.FileRequired
Map the PDF file where margin needs to be added. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from URL.
Top Margin
Top margin in millimeters (mm).
Bottom Margin
Bottom margin in millimeters (mm).
Left Margin
Left margin in millimeters (mm).
Right Margin
Right margin in millimeters (mm).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the file here to be converted. Supported file formats are doc, docx, ppt, pptx, xls, xlsx, txt, eml, bmp, gif, jpeg, png, tiff.
File Name
File name including extension. Note: Extension in file name is important for identifying file conversion and please do not give .pdf as extension. If extension is not given, resulting PDF file may be empty. To know more about filling the fields, please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to be converted for PDF/A compliance. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
PDF/A ComplianceRequired
PDF/A Compliance to be applied. To know more about filling the fields, please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file from which the Image needs to be generated. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from provided URL / data.
Page NumberRequired
Enter page number of the selected page for image generation
WidthRequired
Width in pixels of the image generated.
Image FormatRequired
File Format of the image generated.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File to be upload to PDF4me Workflow
Select PDF4me-Workflow
Select the PDF4me Workflow to process file. To know more about filling the fields, please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File from which pages needs to be extracted. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
File Name.
Extract ModeRequired
Set the mode of extract (Pagewise/Full Document).In pagewise mode text is returned as list with page numbers. In Full Document text will be returned in a single field
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template FileRequired
Map the template file for generating documents. To know more about filling the fields, please refer to our documentation for guidelines.
Template File Name
Name for the output file.
Template File TypeRequired
Select Template file type.
Input Data Format TypeRequired
Select Input Data Format.
Input Data TypeRequired
Choose Document Data Type
Meta Data
MetaData for Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file for getting document information. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from url.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the HTML file to be converted to PDF. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
Name of the HTML file
Index File Path
Index File Path required if input file is ZIP.
Layout
Set layout for the page
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the file to be Optimized. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
Name is optional. But if uploading a non-PDF, please specify file name. This will perform conversion to PDF before compression. Otherwise optimize will fail.
Compression Type
Select type of Optimization.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FilesRequired
Map the PDF files to be merged into a single document. To know more about filling the fields, please refer to our documentation for guidelines.
Output File Name
Name for the output file.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FilesRequired
Map the PDF files to be merged side-by-side into a single document. To know more about filling the fields, please refer to our documentation for guidelines.
OrientationRequired
Merge pages size-wise
Output File Name
Name for the output file.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File on which OCR needs to be performed.
File Name
File Name of the PDF.
Quality TypeRequired
Select the type of quality. API call cost is different for each quality. Please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File on which should be converted to a PowerPoint presentation
File Name
File Name.
Quality TypeRequired
Select the Quality type for conversion. API call cost is different for each quality. Please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to be password protected. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from the URL
PasswordRequired
Password to be set for PDF file.
PermissionRequired
Permissions while encrypting with password.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file containing the Swiss QR. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from URL.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to be rotated. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
Rotate DirectionRequired
Rotate direction.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file where Watermark is to be added. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from the URL.
Sign Image FileRequired
Map the Image of the Signature to be stamped
Sign image file name
Signature image file name
PagesRequired
Pages where Signature needs to be added. Possible values are page numbers ( 1,2,3) or string (first, last, all).
Horizontal AlignRequired
Horizontal position of Signature
Vertical AlignRequired
Vertical position of Signature
Image Width
Signature width in mm. if 0, default width or aspect ratio width will be taken.
Image Height
Signature height in mm. if 0, default height or aspect ratio height will be taken.
Horizontal Margin
Horizontal Margin in millimeters.
Vertical Margin
Vertical Margin in millimeters.
TransparencyRequired
Transparency for image. Transparency ranges from 0 (Max transparent) - 100 (Max Opacity).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF to be split. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
Split Type
Specify whether the document should be split into two or split recurringly.
Page NumberRequired
Split document after page number.
Split File Naming
Select With Page Number for names with range of split, e.g: test 001-004.pdf, test 005-008.pdf, etc. Select Naming as per order to get the output names based on the serial order of split. E.g: test 1.pdf, test2.pdf, test3.pdf, etc.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File on which should be Split. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
File Name.
Search TextRequired
Provide text here that needs to searched for splitting
Select Split TypeRequired
Select the split type to determine whether split should happen after or before the page that contains the text
Split File Naming
Select With Page Number for names with range of split, e.g: test 001-004.pdf, test 005-008.pdf, etc. Select Naming as per order to get the output names based on the serial order of split. E.g: test 1.pdf, test2.pdf, test3.pdf, etc.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File to remove password protection. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
PasswordRequired
Password set for the PDF file.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WebUrlRequired
Url of the webpage to be converted to PDF. To know more about filling the fields, please refer to our documentation for guidelines.
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.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
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.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 foundFileRequired
Map the file in for adding Barcode or QR code. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name. Otherwise name will be picked from the URL.
Barcode TypeRequired
Type of barcode to be added.
TextRequired
Text to be added as barcode.
PagesRequired
Pages where barcode need to be added. Possible values are page numbers ( 1,2,3 etc.) or text (first, last and all).
Horizontal AlignRequired
Set the horizontal position of the barcode.
Vertical AlignRequired
Set the vertical postion of the barcode.
Barcode Width
Barcode width in millimeters (mm).
Barcode Height
Barcode height in millimeters (mm).
Horizontal Margin
Horizontal margin in millimeters (mm).
Vertical Margin
Vertical margin in millimeters (mm).
TransparencyRequired
Transparency ranging from 0 - 100. 0 for complete transparent, 100 for fully opaque.
Hide Text
Hide the text shown beside the barcode.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the file in for adding page numbers. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name otherwise the name will be picked from the URL.
Page Number FormatRequired
Page number format to be displayed
Font Size
Font Size for the page numbering
Set Bold
Set Bold for page numbering
Set Italic
Set Italic for page numbering
Horizontal AlignRequired
Set the horizontal position of the page numbering.
Vertical AlignRequired
Set the vertical postion of the page numbering.
Horizontal Margin
Horizontal margin in millimeters (mm).
Vertical Margin
Vertical margin in millimeters (mm).
Skip First Page
Skip numbering in the first page of the document
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Barcode TypeRequired
Select barcode type to be generated. To know more about filling the fields, please refer to our documentation for guidelines.
Text in the BarcodeRequired
Text to be encoded in the Barcode
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file where Swiss QR Bill should be added. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from the URL.
Amount
The amount element is to be entered without leading zeroes, including decimal separators and two decimal places.
AV1 Parameters
Alternative scheme parameter, Maximum 100 characters permitted.
AV2 Parameters
Alternative scheme parameter, Maximum 100 characters permitted.
Billing Info
BillingInfo, Maximum 140 characters permitted.
Creditor Address TypeRequired
The creditor's address type is specified using a code S or K.
Creditor City
The creditor's Town/City with max 35 characters length.
Creditor NameRequired
The creditor's name or company according to the account name.
Creditor Postal Code
The creditor's PostalCode with max 16 characters length.
Creditor Address Line 1
The creditor's address line 1 with max 70 characters length.
Creditor Address Line 2
The creditor's address line 2. For S type 16 characters, K type 70 characters length permitted.
Currency
The payment currency, Only CHF and EUR are permitted.
IBANRequired
IBAN or QR-IBAN of the creditor. Max 21 characters with CH or LI only.
Language Type
Choose the language type.
Reference
Reference, Maximum 27 characters permitted.
Reference Type
Type of Reference
Separator Line
Separator line type to be displayed in SwissQR Code
Ultimate Debtor Address Type
The Ultimate Debtor's address type is specified using a code S or K.
Ultimate Debtor City
The Ultimate Debtor's Town/City with max 35 characters length.
Ultimate Debtor Name
The Ultimate Debtor's name or company according to the account name.
Ultimate Debtor Postal Code
The Ultimate Debtor's PostalCode with max 16 characters length.
Ultimate Debtor Address Line 1
The Ultimate Debtor's address line 1 with max 70 characters length.
Ultimate Debtor Address Line 2
The Ultimate Debtor's address line 2. For S type 16 characters, K type 70 characters length permitted.
Unstructured Message
UnstructuredMessage, Maximum 140 characters permitted.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File from which pages needs to be deleted. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
File Name.
Page NumbersRequired
Specify page numbers of the selected pages to be deleted from PDF. For mutliple pages enter as 2,5,6.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File from which pages needs to be extracted. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
File Name.
Page NumbersRequired
Enter page numbers of the selected pages to be extracted from PDF. For mutliple pages enter as 2,5,6.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template FileRequired
Map the PDF Template file for generating document. To know more about filling the fields, please refer to our documentation for guidelines.
Template File Name
Name for the output file.
Input DataRequired
Input Data for template
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template FileRequired
Map the template file for generating document. To know more about filling the fields, please refer to our documentation for guidelines.
Template File Name
Name for the output file.
Template File TypeRequired
Select Template file type.
Input Data Format TypeRequired
Select Input Data Format.
Input Data TypeRequired
Choose Document Data Type
Meta Data
MetaData for Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the file to be shared.
File Name
Name is optional.
Days
Number of days link should be active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file where Watermark needs be added. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from the URL.
Image FileRequired
Map the Image to be added as Stamp / Watermark.
Image File Name
Name of the image file.
PagesRequired
Pages where Watermark needs to be added. Possible values are page numbers ( 1,2,3) or string (first, last, all).
Horizontal AlignRequired
Horizontal position of Image
Vertical AlignRequired
Vertical position of Image
Image Width
Image width in mm. if 0, default width or aspect ratio width will be taken.
Image Height
Image height in mm. if 0, default height or aspect ratio height will be taken.
Horizontal Margin
Horizontal Margin in millimeters.
Vertical Margin
Vertical Margin in millimeters.
TransparencyRequired
Transparency for image. Transparency ranges from 0 (Max transparent) - 100 (Max Opacity).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the markdown file to be converted to PDF. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from the URL.
Markdown File Path
Markdown File Path required if input file is ZIP.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the Base PDF file. To know more about filling the fields, please refer to our documentation for guidelines.
FileName
File Name of the base PDF.
Layer FileRequired
Map the file to be added as layer.
Layer File Name
File Name of the file layer.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the file to be optimized. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
Name is optional. But if uploading a non-PDF, please specify file name. This will perform conversion to PDF before compression. Otherwise optimize will fail.
Compression Type
Select type of compression.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File on which should be converted to Excel spreadsheets
File Name
File Name.
Quality TypeRequired
Select the Quality type for conversion. API call cost is different for each quality. Please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File on which should be converted to a Word document.
File Name
The PDF File Name.
Quality TypeRequired
Select the Quality type for conversion. API call cost is different for each quality. Please refer to our documentation for guidelines.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to read barcodes from. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise name will be picked from URL.
Select barcode typesRequired
Select barcode types to be read from the file. You can also select multiple types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF File to be repaired or restored. To know more about filling the fields, please refer to our documentation for guidelines.
File Name
You can specify file name or otherwise the name will be picked from the URL.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file from which the page needs to be rotated. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
Page NumberRequired
Page to be rotated.
Rotate DirectionRequired
Rotation direction.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to be Split using barcode. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
Barcode Text
Text data in Barcode to filter & split
Barcode FilterRequired
Filter options for text in the barcode.
Barcode TypeRequired
Choose the type of Barcode to split by.
Split Barcode PageRequired
Choose the way split should occur.
PDF Render DpiRequired
Render DPI. Valid values - 100, 150, 200, 250
Combine Pages with Same Barcodes
Combine pages with same barcodes. Any pages having consecutively same barcode texts will be merged as a single document
Return as Zip
Hide text shown beside barcode.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to be Split using the Swiss QR. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
Split Barcode PageRequired
Choose the way split should occur.
PDF Render DpiRequired
Render DPI. Valid values - 100, 150, 200, 250
Combine Pages with Same Barcodes
Combine pages with same Swiss QR. Any pages having consecutively same barcode texts will be merged as a single document
Return as Zip
Hide text shown beside barcode.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the PDF file to apply stamp / watermark. To know more about filling the fields, please refer to our documentation for guidelines.
Specify File Name
You can specify file name or otherwise name will be picked from URL.
TextRequired
Text to be applied as watermark / stamp.
Font SizeRequired
Adjusts the font size of the text. If no value is set, default value 12 will be set.
PagesRequired
Pages where watermark/stamp need to be applied. Possible values are including numbers ( 1,2,3 etc) or text (first, last and all).
Horizontal AlignmentRequired
Position of text watermark horizontally.
Vertical AlignmentRequired
Position of text watermark vertically.
Horizontal Margin
Horizontal Margin in mm.
Vertical Margin
Vertical Margin in mm.
Transparency
Transparency for text. Transparency ranges from 0 (Max transparent) - 100 (Max Opacity).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Map the zip file to be unzipped.
File Name
Name is optional.
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 Dropbox + Google Sheets + PDF4me Integrations Work
- Step 1: Authenticate Dropbox, Google Sheets, and PDF4me.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
Related categories
Similar apps
Google Drive
File Management & Storage, Google
Box
File Management & Storage
OneDrive
File Management & Storage, Microsoft
About Google Sheets
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
