Skip to main content
PDF4me APIIntegrationsKnowledge BaseExtensionsAPI TesterBlog

Secure Excel - Protection for Zapier

PDF4me Secure Excel gives you enterprise-grade protection for sensitive spreadsheets with multi-level password controls. Secure files with encryption so only authorized users can open them, lock workbook structure to prevent sheet additions or deletions, or protect individual worksheet cells to allow viewing but block editing. Use different passwords for each protection level, or one master password—giving you complete control over who sees and edits your data. Perfect for financial reports, customer data, confidential analytics, or templates that shouldn't be modified accidentally.

Authenticating Your API Request​

To access the PDF4me Web API through Zapier, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Zapier workflows and PDF4me's powerful Excel security services.

Get your API Key
PDF4me Excel Secure Workbooks Zapier configuration - File, File Name, Excel Password, Protect Workbook, Protect Workbook Password, Protect Worksheets, Worksheet Protection Password, Worksheets-By Name, Worksheets-By Index, Worksheet Protection Type
Configure the Secure Excel action—File input, passwords, and protection levels.

Configuration at a Glance​

Example configuration from the Zapier interface

The screenshot above shows File and File Name mapped from a previous step, Excel Password = 1234, Protect Workbook = True (password 12345), Protect Worksheets = True (password 123456), Worksheet Protection Type = All.

Excel Password

1234

Protect Workbook

True

Protect Worksheets

True

Protection Type

All

Map File and File Name from previous steps

Use the + button next to File and File Name to map from earlier Zap steps. The Excel file must provide full content, not "Exists but not shown" references.

File: (Exists but not shown)

If you see "File: (Exists but not shown)" in the File field and get errors, select the option that provides the full file content instead. See Zapier & Power Automate Tips for details.

Key Features​

  • Three Protection Levels: Excel Password (file encryption), Protect Workbook, Protect Worksheets
  • Independent Passwords: Use different passwords for each level; main password used as fallback
  • Worksheet Targeting: Worksheets-By Name or Worksheets-By Index—leave empty for all
  • Worksheet Protection Type: All, Contents, Objects, or Scenarios

Parameters​

Complete list of parameters for the Secure Excel action. Parameter names match the Zapier configuration UI.

Quick setup checklist
  1. Map File (Excel) and File Name from previous step
  2. Set Excel Password for file encryption (optional)
  3. Set Protect Workbook = True and Protect Workbook Password if needed
  4. Set Protect Worksheets = True and Worksheet Protection Password if needed
  5. Select Worksheet Protection Type (All, Contents, Objects, Scenarios)

Important: Parameters marked with an asterisk (***) are required. At least one password must be provided for each protection level you enable.

ParameterTypeDescriptionExample
File***FileExcel File Content—map from previous step[2. File from Step 2]
File NameStringExcel Filename—with .xlsx or .xls extensionadd_header_sample_file.xlsx
Excel PasswordStringFile encryption password—required to open. Fallback for workbook/worksheet if others empty1234
Protect WorkbookBooleanEnable workbook structure protectionTrue
Protect Workbook PasswordStringPassword for workbook protection12345
Protect WorksheetsBooleanEnable worksheet content protectionTrue
Worksheet Protection PasswordStringPassword for worksheet protection123456
Worksheets-By NameStringComma-separated worksheet names—empty = allSheet1,Summary
Worksheets-By IndexStringComma-separated worksheet indexes—empty = all0,2
Worksheet Protection TypeStringAll, Contents, Objects, or ScenariosAll

Output​

The PDF4me Secure Excel action returns the protected Excel file for use in subsequent Zap steps. The output format is common across all PDF4me Excel file-returning actions in Zapier.

Key output fields (map these to your next step)​

File Url

API endpoint to download the protected Excel file. Map this to the next step's file input.

api.pdf4me.com/Zapier/GetDocument?d=...
Alternate File Url

Alternative download URL with filename in path.

api.pdf4me.com/Zapier/GetAltDocument/.../add_header_sample_file.xlsx
ParameterTypeDescription
Job IdStringUnique identifier for the Zapier job execution
File UrlURLAPI endpoint to download the protected Excel file
Alternate File UrlURLAlternate download URL with filename in path
File NameStringBase filename without extension
File ExtensionStringFile extension
Full File NameStringComplete filename with extension
Document IdStringUnique identifier for the processed document
File SizeNumberSize of the output file in bytes

Scenario Examples​

The PDF4me Secure Excel action in Zapier provides comprehensive scenario templates designed for real-world security needs:

Automated Confidential Report Multi-Level Protection Workflow

Apply comprehensive security to confidential financial reports:

Complete Scenario Steps:

  1. Trigger: Monthly financial report finalized and ready for distribution
  2. Get Financial Report: Retrieve completed report from Google Drive
  3. Secure Excel: Map File, File Name; set Excel Password = "Finance2024!"
  4. Protect Structure: Protect Workbook = True, Protect Workbook Password (or use Excel Password fallback)
  5. Protect Worksheets: Protect Worksheets = True, Worksheet Protection Password (or fallback), Worksheet Protection Type = All
  6. Target All Sheets: Leave Worksheets-By Name and Worksheets-By Index empty
  7. Upload Result: Map File Url from output to secure Google Drive executive folder
  8. Email CFO: Send protected report with password via separate secure channel

Business Benefits:

  • Secures 12 monthly financial reports automatically with 3-layer protection
  • File encryption prevents unauthorized opening completely
  • Structure + worksheet protection prevents any modifications
  • Eliminates manual protection application saving 20 minutes per report

Industry Use Cases & Applications​

  • Salary File Encryption: Apply file encryption to payroll and compensation files before HR distribution
  • Financial Template Protection: Protect structure and formula sheets in financial model templates
  • Audit Working Paper Security: Encrypt audit files with passwords before archive storage
  • Budget Template Protection: Lock budget formula sheets while allowing department data entry
  • Board Package Encryption: Apply file encryption to board meeting packages for confidentiality

Get Help​

Zapier IntegrationGet your API KeyZapier Documentation