Secure Excel - Protection for Make

PDF4me Secure Excel module applies comprehensive password protection to Excel documents within Make scenarios with multi-level security control. This powerful security service supports three independent protection levels: file encryption (password to open file), workbook structure protection (prevent sheet modifications), and worksheet content protection (prevent cell edits), with flexible password hierarchy allowing separate passwords for each level or single password for all, plus selective worksheet targeting and four protection types (Contents, Objects, Scenarios, All)—perfect for confidential data protection, template security, controlled access workflows, and sensitive document distribution across cloud storage platforms and business applications.

Authenticating Your API Request

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

Get your API Key

Key Features

• Three Protection Levels: File encryption, workbook structure, worksheet content
• Independent Passwords: Use different passwords for each protection level
• Password Fallback: Automatically use main password if level-specific password not provided
• Flexible Worksheet Selection: Protect specific worksheets or all worksheets
• Protection Type Options: Contents, Objects, Scenarios, or All (comprehensive)
• 0-Based Indexing: Worksheet indexes use standard 0-based numbering

Parameters

Complete list of parameters for the Secure Excel module. Configure these parameters to control protection levels and passwords.

Important: Parameters marked with an asterisk (***) are required and must be provided for the module to function correctly. At least one password must be provided for respective protection level. Worksheet indexes use 0-based numbering (0 = first worksheet).

Parameter	Type	Description	Example
File Name***	String	Excel Document Name • Filename with .xlsx or .xls extension • Used for processing and output file identification • Supports dynamic naming from scenario variables • Required for protection operation	data.xlsx
Document***	Buffer	Excel File Content • Map from previous module (Drive/Dropbox/HTTP) • Binary Excel document to protect • Must be valid Excel format • Data and formatting preserved during protection	[Buffer]
Password	String	File Encryption Password (Level 1) • Password required to open the file - encrypts entire workbook • Also used as fallback for workbook and worksheet protection if their passwords empty • Optional - no file encryption if empty • User Experience: Prompts "Enter password to open" - cannot open without password • Case-sensitive, recommend strong password	Open123!
Protect Workbook	Boolean	Enable Workbook Structure Protection (Level 2) • True = Protect structure - prevents add/delete/rename/move/hide sheets • False = No structure protection (default) • Requires password (Protect Workbook Password or Password fallback) • User Experience: "This workbook is protected" when modifying structure • Default: false	true
Protect Workbook Password	String	Workbook Protection Password (Level 2) • Password for workbook structure protection • Password Fallback Priority: 1st: This parameter (if provided), 2nd: Password parameter • Required if Protect Workbook = true and Password empty • Case-sensitive	Struct456
Protect Worksheets	Boolean	Enable Worksheet Content Protection (Level 3) • True = Protect selected worksheets - prevents data modifications • False = No worksheet protection (default) • Requires password (Worksheet Protection Password or Password fallback) • User Experience: "Cell is protected" when trying to edit • Default: false	true
Worksheet Protection Type	String	Type of Worksheet Protection • "Contents" = Protect cell values, formulas, formatting • "Objects" = Protect charts, images, shapes, drawings • "Scenarios" = Protect what-if analysis scenarios • "All" = Full protection (Contents + Objects + Scenarios) - Default • Case-insensitive • Read-only access when "All" applied	All
Worksheet Protection Password	String	Worksheet Protection Password (Level 3) • Password for worksheet content protection • Password Fallback Priority: 1st: This parameter, 2nd: Password parameter • Required if Protect Worksheets = true and Password empty • Case-sensitive	Edit789
Worksheet Names	String	Comma-Separated Worksheet Names • List of worksheet names to protect • Empty = protect all worksheets • Case-sensitive exact matching • Union with Worksheet Indexes	Sheet1,Summary
Worksheet Indexes	String	Comma-Separated Indexes (0-based) • List of worksheet indexes to protect • 0-based indexing (0 = first sheet, 1 = second) • Empty = protect all worksheets • Union with Worksheet Names	0,2

Output

The PDF4me Secure Excel module returns comprehensive output data for seamless Make scenario integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
Name	String	Output Excel filename
Doc Data	Buffer	Password-protected Excel document

JSON

JSON Response Format

The raw JSON response from the module:

{
  "Name": "data.xlsx",
  "Doc Data": "[Buffer Data]"
}

Scenario Integration

Make Scenario Usage

Use protected Excel files in subsequent modules:

• Secure Distribution: Email encrypted files to authorized recipients
• Template Protection: Protect formula sheets and reference data
• Confidential Sharing: Share sensitive data with password protection
• Archive Storage: Store encrypted files in cloud storage

Scenario Examples

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

Confidential Reports

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. Apply File Encryption: Set Password = "Finance2024!" for file opening protection
4. Protect Structure: Set Protect Workbook = true to prevent sheet modifications
5. Use Same Password: Leave Protect Workbook Password empty to use main password
6. Protect All Worksheets: Set Protect Worksheets = true for read-only access
7. Full Protection: Set Worksheet Protection Type = "All"
8. Apply to All Sheets: Leave worksheet selectors empty for all-sheet protection
9. Upload Secured Report: Save to secure Google Drive executive folder
10. 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

Create Scenario

Template Distribution

Automated Template Formula Protection Workflow

Protect calculation sheets while allowing data entry sheets:

Complete Scenario Steps:

1. Trigger: Template approved for enterprise distribution
2. Get Master Template: Retrieve template with formulas from library
3. Protect Structure: Set Protect Workbook = true, Protect Workbook Password = "StructPwd"
4. Protect Calculation Sheets: Set Protect Worksheets = true
5. Target Calc Sheets: Set Worksheet Names = "Calculations,Reference,Formulas"
6. Set Worksheet Password: Worksheet Protection Password = "EditPwd"
7. Full Worksheet Protection: Worksheet Protection Type = "All"
8. Leave Input Sheets: Data entry sheets not in list remain unprotected
9. Upload Protected Template: Save to shared Google Drive templates folder
10. Email Users: Send protected template with edit password for authorized changes

Business Benefits:

• Protects 25+ enterprise templates monthly automatically
• Formula sheets locked preventing accidental formula corruption
• Structure protection prevents users from deleting/renaming sheets
• Reduces formula corruption incidents by 95%

Create Scenario

Read-Only Distribution

Automated Read-Only Report Distribution Workflow

Create read-only protected reports for wide distribution:

Complete Scenario Steps:

1. Trigger: Weekly performance report generation completed
2. Get Performance Report: Retrieve report from Dropbox
3. Apply Simple Protection: Set Password = "View2024" for opening
4. Protect All Worksheets: Set Protect Worksheets = true
5. Use Same Password: Leave Worksheet Protection Password empty (fallback to Password)
6. Full Protection: Worksheet Protection Type = "All" for read-only
7. Apply to All Sheets: Leave worksheet selectors empty
8. Upload Protected Report: Save to shared Dropbox folder
9. Email Team: Send report to entire team with single view password
10. Log Distribution: Record distribution event with recipient count

Business Benefits:

• Distributes 52 weekly reports annually as read-only
• Single password simplifies distribution to large teams
• Prevents accidental edits to official reports by 100%
• Maintains report integrity for all stakeholders

Create Scenario

Industry Use Cases & Applications

Finance & Accounting

• 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

Legal & Professional

• Client File Protection: Encrypt client matter files with case-specific passwords
• Template Formula Protection: Protect legal template calculation sheets from modification
• Discovery Material Security: Apply worksheet protection to financial exhibits for read-only review
• Privileged Document Encryption: Encrypt attorney-client privileged Excel files
• Settlement Worksheet Protection: Lock settlement calculation sheets preventing unauthorized changes

Human Resources

• Performance Review Protection: Protect review template reference sheets and rating formulas
• Compensation File Encryption: Encrypt salary survey and compensation analysis files
• Benefits Template Protection: Protect benefits calculation sheets while allowing enrollment data entry
• Employee Data Security: Apply file encryption to personnel records and org charts
• Headcount Planning Protection: Protect headcount model formulas while allowing scenario data entry

Operations

• Production Schedule Protection: Protect master production schedule formulas from unauthorized changes
• Inventory Template Security: Lock inventory calculation sheets while allowing count data entry
• Quality Dashboard Protection: Protect QC dashboard charts and calculation sheets as read-only
• Equipment Log Encryption: Encrypt maintenance logs containing asset and cost information
• Capacity Model Protection: Lock capacity planning formulas while allowing demand data updates

Get Help

Make IntegrationGet your API KeyMake Documentation