Add Text Watermark to Excel in Make

What this module does

Add Text Watermark to Excel is a Make module by PDF4me that applies WordArt text watermarks to Excel worksheets inside a Make scenario. Use it to stamp CONFIDENTIAL, DRAFT, INTERNAL ONLY, or any custom text as a visible overlay, with control over size (4 presets from 50pt to 150pt), color, font, transparency (0-100%), rotation (-360 to 360 degrees), and 9-position grid placement across selected sheets or all worksheets automatically.

Set transparency between 40-60 for readable watermarks

A Transparency of 0 means fully opaque (solid, blocks content), while 100 means invisible. For security watermarks like CONFIDENTIAL, 40-60 provides a strong visual mark while keeping the underlying data readable. DRAFT watermarks work well at 60-70. Copyright notices at 20 remain clearly visible without overwhelming the content.

Use -45 rotation with Position 4 for classic diagonal center watermark

The standard watermark appearance uses Rotation Angle = -45 (counter-clockwise diagonal) and Position = 4 (center). Text Size 4 (Extra Large, 150pt) maximizes visibility for security marks. For subtle copyright notices, use Text Size 1 (Small, 50pt) with Position 8 (bottom-right) and Rotation 0 for a horizontal footer-style watermark.

0-based worksheet indexes vs 1-based in other Excel modules

Selected Worksheet Indexes for this module use 0-based numbering: worksheet 0 is the first tab, 1 is the second. This differs from other Excel modules that use 1-based indexing. Double-check your index values when switching between modules. Leave both Selected Worksheet Names and Selected Worksheet Indexes empty to watermark all worksheets automatically.

Related Blog Posts

No blog post yet for this feature — coming soon.

In the meantime, browse the PDF4me blog for tutorials and workflows across every platform.

Visit the blog →

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 Excel watermarking services.

Get your API Key

Set Rotation Angle to -45 and Position to 4 (center) for a classic diagonal watermark. Adjust Transparency between 40-60 to keep cell data visible beneath the mark.

How Do I Add a Text Watermark to Excel in Make?

The PDF4me Add Text Watermark to Excel module integrates into any Make scenario that delivers an Excel file. A typical flow downloads the file from Google Drive or Dropbox, passes it into this module along with the watermark text and appearance settings, then uploads the result to the same or a different folder. According to the Make integration documentation, PDF4me modules process files as binary buffers, so the watermarked Excel file returns on the Doc Data output ready to upload or attach to an email without any intermediate conversion. The module applies the watermark as a WordArt overlay that does not affect formulas, formatting, or cell data in any way.

Parameters

Important: Parameters marked Required must be provided. Conditional parameters have built-in defaults and are optional unless you need to override the default behavior.

Parameter	Required	What it does	Example
Connection	Required	PDF4me connection holding your API key. Create one from the Make Connections panel using your API key from dev.pdf4me.com.	My PDF4me connection
File Name	Required	Excel filename with .xlsx or .xls extension. Used for the output filename. Map from a prior download module or use a dynamic expression.	data.xlsx
Document	Required	Binary Excel file content as a Make buffer. Map from Google Drive, Dropbox, SharePoint, or HTTP download module.	1. Data
Watermark Text	Required	Text to display as the WordArt watermark. Supports dynamic values from prior modules. Common values: CONFIDENTIAL, DRAFT, INTERNAL ONLY.	CONFIDENTIAL
Text Size	Conditional	Watermark size preset. 1 = Small (50pt), 2 = Medium (75pt), 3 = Large (100pt, default), 4 = Extra Large (150pt). Larger sizes are more visible but may obscure content.	4
Text Color	Conditional	Watermark color as hex code or named color. Default: Black. Examples: #FF0000 (red), #808080 (gray), DarkBlue.	#FF0000
Font Family	Conditional	Font name for the watermark text. Default: Calibri. Use any standard Excel font: Arial, Times New Roman, Calibri.	Arial
Is Bold	Conditional	When true, applies bold weight to the watermark text. Default: false. Bold enhances visibility for security marks.	false
Is Italic	Conditional	When true, applies italic style to the watermark text. Default: false. Often used with DRAFT status watermarks.	false
Transparency	Conditional	Opacity level 0-100. 0 = fully opaque (solid), 100 = invisible. Default: 50. Use 40-60 for visible security marks that allow content reading.	40
Rotation Angle	Conditional	Rotation in degrees, -360 to 360. Negative = counter-clockwise. Default: 0 (horizontal). Use -45 for classic diagonal watermarks.	-45
Position	Conditional	9-position grid placement. 0=Top-Left, 1=Top-Center, 2=Top-Right, 3=Middle-Left, 4=Center (default), 5=Middle-Right, 6=Bottom-Left, 7=Bottom-Center, 8=Bottom-Right.	4
Selected Worksheet Names	Conditional	Array of exact case-sensitive worksheet tab names to watermark. Leave empty to watermark all sheets. Example: ["Sheet1","Summary"].	["Sheet1"]
Selected Worksheet Indexes	Conditional	Array of 0-based worksheet indexes to watermark. Index 0 = first worksheet. Leave empty to watermark all sheets. Can combine with Names.	[0,2]

Output

The PDF4me Add Text Watermark to Excel module returns two fields on the output bundle:

Field	Type	What it contains
Name	String	Output Excel filename derived from the File Name input. Use in the destination upload module File Name field.
Doc Data	Buffer	Binary Excel content with the WordArt watermark applied as a Make buffer. Map into Google Drive Upload, Dropbox Upload, SharePoint Create File, or Email Send attachment. Workbook formulas, formatting, and cell data are fully preserved.

Scenario Examples

The PDF4me Add Text Watermark to Excel module in Make provides comprehensive scenario templates designed for real-world security and compliance needs:

Confidential Marking

Automated Confidential Document Watermarking Workflow

Secure your sensitive documents with automated WordArt watermarking:

1. Trigger: Document uploaded to confidential folder in storage system
2. Get Sensitive Document: Retrieve Excel workbook from secure storage
3. Add CONFIDENTIAL Watermark: WatermarkText = "CONFIDENTIAL"
4. Set Center Position: Position = 4 (center) for maximum visibility
5. Set Large Size: TextSize = 4 (Extra Large, 150pt) for clear marking
6. Set Red Color: TextColor = #FF0000 for attention-grabbing red
7. Set Transparency: Transparency = 40 (allows content reading)
8. Rotate Diagonal: RotationAngle = -45 for classic diagonal watermark
9. Apply to All Sheets: Leave worksheet selectors empty for all-sheet coverage
10. Email Authorized Users: Distribute with access controls to authorized recipients

Business Benefits: Watermarks 200+ confidential files monthly automatically. Large diagonal red WordArt provides unmistakable security indicator. 40% transparency maintains content readability while marking.

Create Scenario

Draft Marking

Automated Draft Version Marking Workflow

Mark work-in-progress documents automatically before review distribution:

1. Trigger: Document saved to "Draft" folder in project workspace
2. Get Draft Document: Retrieve Excel workbook from draft storage
3. Add DRAFT Watermark: WatermarkText = "DRAFT", IsItalic = true
4. Set Diagonal Position: RotationAngle = -45 for diagonal placement
5. Set Gray Color: TextColor = #808080 (gray) for subtle appearance
6. Set Medium Size: TextSize = 2 (Medium, 75pt) for non-intrusive marking
7. Set High Transparency: Transparency = 60 for subtle visibility
8. Apply to Visible Sheets: Target selected worksheets for review
9. Email Review Team: Send draft with clear DRAFT watermark for feedback

Business Benefits: Marks 150+ draft documents monthly automatically. Gray italic diagonal watermark clearly indicates draft status. Prevents accidental distribution of draft versions as final by 95%.

Create Scenario

Copyright Branding

Automated Copyright Watermarking Workflow

Protect intellectual property with automated copyright watermarks on external deliverables:

1. Trigger: Deliverable marked final and ready for external distribution
2. Get Final Document: Retrieve finalized Excel workbook
3. Build Copyright Text: Format "2024 Acme Corporation" dynamically
4. Add Copyright Watermark: Insert copyright notice as WordArt
5. Set Bottom-Right Position: Position = 8 (bottom-right) for standard placement
6. Set Small Size: TextSize = 1 (Small, 50pt) for unobtrusive copyright
7. Set Black Color: TextColor = #000000 for professional appearance
8. Set Low Transparency: Transparency = 20 for clear visibility
9. Apply to All Sheets: Ensure copyright on every worksheet
10. Distribute to External Parties: Send protected document

Business Benefits: Protects 100+ external deliverables monthly with copyright. Bottom-right placement follows industry standard practice. Reduces intellectual property disputes and unauthorized use.

Create Scenario

Industry Use Cases & Applications

Finance & Accounting

• Confidential Financial Reports: Add "CONFIDENTIAL" watermark center-diagonal on quarterly financial statements
• Draft Budget Workbooks: Apply "DRAFT" watermark with 60% transparency on preliminary budget documents
• Internal Audit Files: Insert "INTERNAL USE ONLY" watermark on audit working papers and schedules
• Pre-Announcement Results: Watermark earnings reports with "EMBARGOED UNTIL [DATE]" before public release
• Sensitive Analysis: Apply diagonal watermarks to M&A financial models and valuation spreadsheets

Legal & Professional

• Draft Legal Documents: Mark contract templates and agreements with "DRAFT" gray diagonal watermark
• Privileged Materials: Apply "ATTORNEY-CLIENT PRIVILEGED" watermark on sensitive legal spreadsheets
• Review Versions: Insert "FOR REVIEW ONLY" watermark on documents circulated for partner review
• Confidential Discovery: Watermark financial exhibits with "CONFIDENTIAL - DISCOVERY MATERIAL"
• Settlement Worksheets: Apply "CONFIDENTIAL SETTLEMENT" watermark on negotiation spreadsheets

Operations

• Draft Production Schedules: Mark preliminary production plans with "PRELIMINARY" diagonal watermark
• Internal Operational Metrics: Apply "INTERNAL ONLY" watermark on performance dashboards
• Quality Control Logs: Insert status watermarks ("UNDER REVIEW", "APPROVED") on QC spreadsheets
• Maintenance Schedules: Watermark equipment maintenance plans with approval status indicators
• Capacity Planning: Apply "DRAFT FORECAST" watermark on preliminary capacity analysis workbooks

Human Resources

• Payroll Worksheets: Insert "CONFIDENTIAL - HR USE ONLY" watermark on salary and payroll files
• Performance Review Drafts: Mark preliminary review spreadsheets with "DRAFT" gray watermark
• Compensation Analysis: Apply "STRICTLY CONFIDENTIAL" red watermark on salary survey data
• Reorganization Plans: Watermark organizational charts with "CONFIDENTIAL - DO NOT DISTRIBUTE"
• Benefits Comparison: Insert "INTERNAL PLANNING" watermark on benefits cost analysis workbooks

When Should I Use Add Text Watermark to Excel in Make?

Use this module whenever your workflow needs to visually classify an Excel file before distribution or archiving. The most common trigger is a status change in a connected system: a document moves from draft to review, a financial report is cleared for external sharing, or a file lands in a folder designated for confidential recipients. According to Microsoft's Excel WordArt documentation, WordArt overlays are rendered at the drawing layer and do not interfere with cell data or formulas, which is why this approach is safe for live financial models and structured data sheets. If you need to watermark PDF documents rather than Excel files, the PDF4me Add Text Watermark to PDF module is the right tool for that workflow.

Common Questions

How do I add a text watermark to Excel automatically in Make?

Add the PDF4me Add Text Watermark to Excel module after a trigger and a file-download step. Map File Name and Document from the download module, set Watermark Text to your desired label, configure Position = 4 and Rotation Angle = -45 for a diagonal center watermark, then map Doc Data from the output into an upload module. For detailed scenario setup, see the PDF4me Make integration guide.

What is the difference between Selected Worksheet Names and Selected Worksheet Indexes?

Selected Worksheet Names targets sheets by their exact case-sensitive tab names (e.g. ["Sheet1", "Summary"]). Selected Worksheet Indexes targets sheets by 0-based position: index 0 is the first worksheet, 1 is the second. You can provide both; the module watermarks the union. Leave both empty to apply the watermark across all worksheets in the workbook. Note that this module uses 0-based indexing, which differs from other PDF4me Excel modules that use 1-based numbering.

What Transparency value produces the best result for a CONFIDENTIAL watermark?

Between 40 and 60 is the standard range for security watermarks. At 0 the watermark is fully opaque and completely covers the cells below. At 100 it is invisible. A value of 40-50 creates a strong visual mark while keeping the spreadsheet data readable underneath. For DRAFT watermarks that need to be more subtle, 60-70 works well. For copyright notices that should be clearly visible but not intrusive, 20-30 is common. See best practices for document watermarking for compliance context.

Make IntegrationGet your API KeyMake Documentation