Add Text Watermark to Excel using Zapier

PDF4me Add Text Watermark to Excel adds professional WordArt watermarks to your spreadsheets automatically. Whether marking documents CONFIDENTIAL, adding DRAFT status, or branding with your company name, this action gives you complete control over text, font, size, color, bold/italic styling, transparency, and rotation. Apply to selected worksheets or all sheets at once for consistent branding or security marking throughout your workbook.

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

Get your API Key

Configure the Excel Add Watermark action—File input, watermark text and styling, worksheet targeting.

Configuration at a Glance

Example configuration from the Zapier interface

The screenshot above shows a typical setup: adding a WordArt watermark (e.g., "CONFIDENTIAL") with font, color, transparency, and worksheet targeting.

File

add_header_sample_file.xlsx

Watermark Text

Ynoox / CONFIDENTIAL

Font Family

Arial

Text Size

Medium

Text Color

#808080

Transparency

50

Worksheets

Sheet4, Sheet1

Map File and File Name from previous steps

Use the + button next to File and File Name to map from earlier Zap steps—e.g., Excel from Google Drive. You can combine File Name and File Ext from a previous step. 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 "File is Empty" errors, select the option that provides the full file content instead. See Zapier & Power Automate Tips for details.

Key Features

• WordArt Watermarks with size presets (Small, Medium, Large, Extra Large)
• Font & Style customization: Font Family, IsBold, IsItalic
• Color & Transparency control (hex colors, 0–100% transparency)
• Rotation -360° to 360° for diagonal placement
• Worksheet Targeting by names or indexes, or all sheets

Parameters

Complete list of parameters for the Add Watermark action. Parameter names match the Zapier configuration UI.

Quick setup checklist

1. Map File (Excel) from your trigger or a previous step
2. Map File Name (e.g., File Name + File Ext from previous step)
3. Enter Watermark Text (e.g., "CONFIDENTIAL", "DRAFT")
4. Optionally set Font Family, Text Size, Text Color, IsBold, IsItalic
5. Set Transparency (0–100) and Rotation Angle (e.g., -45 for diagonal)
6. Optionally specify Worksheet Names or Worksheet Indexes (or leave empty for all sheets)

Important: Parameters marked with an asterisk (***) are required. Use the + button next to each field to map data from previous steps. Boolean values use True or False.

Parameter	Type	Description	Example
File***	File	Excel File Content • Labeled "File" in Zapier—map from previous step • Source from Dropbox, Google Drive, HTTP request • Binary Excel file to add watermark to • Shows "File: (Exists but not shown)" when mapped—ensure full file content is passed	[2. File from Step 2]
File Name***	String	Excel Filename • Specify filename with .xlsx or .xls extension • Map from previous step (e.g., File Name + File Ext) • Used for output file identification	add_header_sample_file.xlsx
Watermark Text***	String	Watermark Display Text • Text to display as WordArt watermark • Examples: "CONFIDENTIAL", "DRAFT", "INTERNAL ONLY" • Supports dynamic values from previous steps	CONFIDENTIAL
Font Family	String	Font Family Name • Arial, Calibri, Times New Roman, etc. • Default: Calibri	Arial
Text Size	String	Watermark Size • Small (50pt), Medium (75pt), Large (100pt), Extra Large (150pt) • Select from dropdown in Zapier	Medium
IsBold	Boolean	Bold font weight • True - Apply bold • False - Normal weight	True
IsItalic	Boolean	Italic font style • True - Apply italic • False - Normal style	False
Text Color	String	Watermark color • Hex code (#RRGGBB) or named color • Examples: #FF0000, #808080, Black	#808080
Transparency	Number	Opacity (0–100) • 0 = fully opaque, 100 = fully transparent • 40–60 typical for visible but non-intrusive	50
Rotation Angle	Number	Rotation in degrees • -360 to 360 • -45 typical for diagonal watermarks	-45
Worksheet Names	Array	Target worksheets by name • Exact case-sensitive names • Empty with Indexes = all sheets	Sheet4, Sheet1
Worksheet Indexes	Array	Target worksheets by index (1-based) • 1 = first worksheet • Union with Names when both provided	[1, 4]

Apply to all worksheets

Leave both Worksheet Names and Worksheet Indexes empty to apply the watermark to all worksheets in the workbook.

Output

The PDF4me Add Text Watermark to Excel action returns the modified Excel file for use in subsequent Zap steps. The output format is common across all PDF4me Excel actions in Zapier—use the fields below to map results to your next step.

Key output fields (map these to your next step)

File Url

API endpoint to download the processed Excel file. Map this to the next step's file input (e.g., Google Drive, Dropbox, or another PDF4me Excel action).

Generated URLs follow this format (example—not a working link):

api.pdf4me.com/Zapier/GetDocument?d=...

Alternate File Url

Alternative download URL with the filename in the path. Use when the receiving app expects a human-readable filename in the URL.

Generated URLs follow this format (example—not a working link):

api.pdf4me.com/Zapier/GetAltDocument/.../add_header_sample_file.xlsx

File Name / Full File Name / File Extension

Use for naming the saved file or passing metadata to the next step. Values match your input filename.

Complete output structure

Table

All output fields (Zapier Test/Output panel)

Parameter	Type	Description
Job Id	String	Unique identifier for the Zapier job execution
File Url	URL	API endpoint to download the processed Excel file
Alternate File Url	URL	Alternate download URL with filename in path
File Name	String	Base filename without extension
File Extension	String	File extension (e.g., .xlsx)
Full File Name	String	Complete filename with extension
Document Id	String	Unique identifier for the processed document
File Size	Number	Size of the output file in bytes
Doc Text	String	Extracted text (typically empty for Excel operations)

JSON

Example JSON output

The action generates unique URLs when it runs. The values below show the structure—actual URLs will be different and valid for your job only:

{
  "Job Id": "969f2da3-f10a-49bf-b084-6fc4759991ec",
  "File Url": "api.pdf4me.com/Zapier/GetDocument?d=...",
  "Alternate File Url": "api.pdf4me.com/Zapier/GetAltDocument/.../add_header_sample_file.xlsx",
  "File Name": "add_header_sample_file",
  "File Extension": ".xlsx",
  "Full File Name": "add_header_sample_file.xlsx",
  "Document Id": "07386627-184a-44b2-a040-5ea2712a4bc5",
  "File Size": 212764,
  "Doc Text": ""
}

Map File Url or Alternate File Url to the next step's file input for uploads or chained Excel operations.

Zap Integration

Using output in subsequent steps

Use the + button to map output fields:

• File Url → Primary choice for file input (Drive, Dropbox, Email attachments, next PDF4me action)
• Alternate File Url → Use when the app expects filename in the URL
• Full File Name → Use when the next step needs the filename for saving or display

Common downstream actions:

• Upload to Google Drive, Dropbox, or OneDrive
• Attach to email via Gmail, Outlook
• Chain to Convert to PDF, Remove Watermark, or other PDF4me Excel actions

Same output for all PDF4me Excel actions

This output structure is shared across Add Text Watermark, Add Rows, Add Image Header Footer, and other PDF4me Excel actions in Zapier. The URLs are temporary—use them in the next step before they expire.

Scenario Examples

The PDF4me Add Text Watermark to Excel action in Zapier 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:

Complete Scenario Steps:

1. Trigger: Document uploaded to confidential folder in storage system
2. Get Sensitive Document: Retrieve Excel workbook from secure storage
3. Add Watermark: Map File, File Name; set Watermark Text = "CONFIDENTIAL"
4. Set Large Size: Text Size = Extra Large for clear marking
5. Set Red Color: Text Color = #FF0000 for attention-grabbing red
6. Set Transparency: Transparency = 40 (60% visible, allows content reading)
7. Rotate Diagonal: Rotation Angle = -45 for classic diagonal watermark
8. Apply to All Sheets: Leave Worksheet Names and Worksheet Indexes empty
9. Upload Result: Map File Url from output to secure storage
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
• Eliminates risk of unmarked sensitive document distribution by 100%

Create Zap

Draft Marking

Automated Draft Version Marking Workflow

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

Complete Scenario Steps:

1. Trigger: Document saved to "Draft" folder in project workspace
2. Get Draft Document: Retrieve Excel workbook from draft storage
3. Add Watermark: Set Watermark Text = "DRAFT"
4. Set Diagonal: Rotation Angle = -45 for diagonal placement
5. Set Gray Color: Text Color = #808080 for subtle appearance
6. Set Italic Style: IsItalic = True for draft document convention
7. Set Medium Size: Text Size = Medium for non-intrusive marking
8. Set High Transparency: Transparency = 60 for subtle visibility
9. Target Sheets: Specify Worksheet Names if needed (or leave empty for all)
10. Upload & Email: Map File Url from output; send to review team

Business Benefits:

• Marks 150+ draft documents monthly automatically
• Gray italic diagonal watermark clearly indicates draft status
• High transparency keeps watermark subtle and non-intrusive
• Prevents accidental distribution of draft versions as final by 95%

Create Zap

Copyright Branding

Automated Copyright Watermarking Workflow

Protect intellectual property with automated copyright watermarks:

Complete Scenario Steps:

1. Trigger: Deliverable marked final and ready for external distribution
2. Get Final Document: Retrieve finalized Excel workbook
3. Add Watermark: Set Watermark Text = "© 2024 Acme Corporation" (map dynamic year if needed)
4. Set Small Size: Text Size = Small for unobtrusive copyright
5. Set Black Color: Text Color = #000000 for professional appearance
6. Set Low Transparency: Transparency = 20 for clear visibility
7. Apply to All Sheets: Leave Worksheet Names and Worksheet Indexes empty
8. Upload Result: Map File Url from output to storage
9. Distribute: Send protected document to external parties

Business Benefits:

• Protects 100+ external deliverables monthly with copyright
• Bottom-right placement follows industry standard practice
• Low transparency ensures copyright is clearly visible
• Reduces intellectual property disputes and unauthorized use

Create Zap

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

Get Help

Zapier IntegrationGet your API KeyZapier Documentation