Skip to main content
PDF4me APIIntegrationsKnowledge BaseExtensionsAPI TesterBlog

Add Text Watermark to Excel using Zapier

PDF4me Add Text Watermark is a Zapier action that stamps a WordArt watermark, such as CONFIDENTIAL or DRAFT, onto Excel worksheets. Only File and Watermark Text are required; font, color, transparency, and rotation are all optional styling. Apply to specific sheets or the whole workbook, and returns a new Excel file for the next Zap step.

What this action does

Takes an Excel workbook from a previous Zap step and renders your Watermark Text as a WordArt overlay across the worksheets you choose. Control font, size, bold/italic, hex color, transparency (0-100), and rotation (-360 to 360 degrees) for anything from a subtle gray DRAFT mark to a bold diagonal CONFIDENTIAL stamp. Target specific sheets by name or index, or leave both empty to watermark every sheet in the workbook.

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 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

Important Facts You Should Not Miss​

Only File and Watermark Text are required
File Name, every styling field, and both worksheet-targeting fields are optional in the Zapier configuration.
Full styling control per watermark
Font Family, Text Size presets, IsBold, IsItalic, Text Color, Transparency (0-100), and Rotation Angle (-360 to 360) all combine on the same watermark text.
Worksheet targeting is optional
Use Worksheet Names or Worksheet Indexes to limit the watermark to specific sheets. Leave both empty to apply it to every worksheet.
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.

PDF4me Excel Add Watermark Zapier configuration - File, File Name, Watermark Text, Font Family, Text Size, IsBold, IsItalic, Text Color, Transparency, Rotation Angle, Worksheet Names, Worksheet Indexes
Only File and Watermark Text carry an asterisk. Every other field, including File Name, is optional.

What Are the Key Features of Add Text Watermark?​

  • 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 -360deg to 360deg for diagonal placement
  • Worksheet Targeting by names or indexes, or all sheets

Parameters​

Complete list of parameters for the Add Text Watermark action. Parameter names match the Zapier configuration UI shown in the screenshot above.

Quick setup checklist
  1. Map File (Excel) from your trigger or a previous step
  2. Enter Watermark Text (e.g., "CONFIDENTIAL", "DRAFT")
  3. Optionally set Font Family, Text Size, Text Color, IsBold, IsItalic
  4. Optionally set Transparency (0-100) and Rotation Angle (e.g., -45 for diagonal)
  5. Optionally specify Worksheet Names or Worksheet Indexes (or leave empty for all sheets)
ParameterRequiredWhat it doesExample
FileRequiredExcel file to watermark. Map from a previous step. Must provide full file content.[2. File from Step 2]
File NameConditionalExcel filename, used for output file identification.add_header_sample_file.xlsx
Watermark TextRequiredText to display as the WordArt watermark.CONFIDENTIAL
Font FamilyConditionalFont used for the watermark text.Arial
Text SizeConditionalPreset size: Small, Medium, Large, or Extra Large.Medium
IsBoldConditionalTrue applies bold weight to the watermark text.True
IsItalicConditionalTrue applies italic style to the watermark text.False
Text ColorConditionalHex code or named color for the watermark.#808080
TransparencyConditionalOpacity from 0 (opaque) to 100 (fully transparent).50
Rotation AngleConditionalRotation in degrees, from -360 to 360.-45
Worksheet NamesConditionalComma-separated worksheet names to target. Combines with Worksheet Indexes if both are set. Empty with Indexes = all worksheets.Sheet4, Sheet1
Worksheet IndexesConditionalComma-separated 1-based worksheet positions to target. Combines with Worksheet Names.[1, 4]
Apply to all worksheets

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

Important: Only File and Watermark Text are required. Use the + button next to each field to map data from previous steps. Boolean values use True or False.

What Does Add Text Watermark Return?​

The PDF4me Add Text Watermark action returns the modified Excel file for use in subsequent Zap steps. The output format is common across all PDF4me Excel actions in Zapier.

File Url

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

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

Alternative download URL with the filename in the path.

api.pdf4me.com/Zapier/GetAltDocument/.../add_header_sample_file.xlsx
FieldTypeWhat it contains
Job IdStringUnique identifier for the Zapier job execution.
File UrlURLAPI endpoint to download the watermarked Excel file.
Alternate File UrlURLAlternate download URL with the filename in the path.
File NameStringBase filename without extension.
File ExtensionStringFile extension of the returned file, e.g. .xlsx.
Full File NameStringComplete filename with extension.
Document IdStringUnique identifier for the processed document.
File SizeNumberSize of the output file in bytes.
Doc TextStringExtracted text, typically empty for Excel operations.

Example JSON output (URLs show format only, not working links):

{
"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": ""
}
Same output for all PDF4me Excel actions

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

Typical Setups​

Workflow ExamplesCommon Zapier workflow patterns using Add Text Watermark.
Confidential marking on upload
  1. A trigger fires when a workbook is uploaded to a restricted-access storage folder.
  2. PDF4me Add Text Watermark sets Watermark Text to "CONFIDENTIAL" with a red Text Color and Rotation Angle -45, leaving Worksheet Names and Worksheet Indexes empty so every sheet is marked.
  3. The watermarked workbook is saved back to secure storage.
Draft status before review
  1. A trigger fires when a workbook is saved to a project's draft folder.
  2. PDF4me Add Text Watermark sets Watermark Text to "DRAFT" with a gray Text Color, IsItalic set to True, and a higher Transparency for a subtle mark.
  3. An email step sends the marked draft to the review team.
Copyright notice on export
  1. A trigger fires when a deliverable is marked final for external distribution.
  2. PDF4me Add Text Watermark sets Watermark Text to a company copyright line with a small Text Size and low Transparency for a subtle but visible mark.
  3. The protected workbook is sent to the external recipient.

Practical Tips​

File: (Exists but not shown) causes errors
Select the mapping option that provides the file's full binary content instead of a reference. See Zapier & Power Automate Tips for the exact steps.
Only File and Watermark Text are required
Every styling option and both worksheet-targeting fields are optional, there is no need to set them if the defaults are fine.
Rotation Angle around -45 gives the classic diagonal look
Rotation accepts any value from -360 to 360, but roughly -45 produces the familiar corner-to-corner CONFIDENTIAL stamp appearance.
Only one worksheet-targeting field is needed
Use either Worksheet Names or Worksheet Indexes, not both. Leaving both empty applies the watermark to every sheet.
This adds a watermark, it does not remove one
Use the separate Remove Watermark action if you need to strip an existing watermark before applying a new one.

Cheat Sheet​

FieldValue
ActionAdd Text Watermark
File[Mapped from previous step]
Watermark TextCONFIDENTIAL
Font FamilyArial
Text SizeMedium
Text Color#808080
Transparency50
Rotation Angle-45
Worksheet NamesSheet4, Sheet1 (or empty for all)

Common Questions​

How do I add a watermark to an Excel file automatically in Zapier?+
Add the PDF4me Add Text Watermark action to a Zap, map the Excel file from a previous step, and enter Watermark Text such as CONFIDENTIAL or DRAFT. See Microsoft's guide to watermarks in Excel for how watermarks behave natively in the desktop app.
Is File Name a required field?+
No. Only File and Watermark Text are marked required in the Zapier configuration. File Name, font, color, transparency, rotation, and worksheet-targeting fields are all optional.
Can I apply the watermark to only specific worksheets?+
Yes. Use Worksheet Names to list exact sheet names, or Worksheet Indexes for 1-based sheet positions. Leave both fields empty to apply the watermark to every worksheet in the workbook.
How do I make the watermark diagonal like a typical CONFIDENTIAL stamp?+
Set Rotation Angle to a negative value such as -45. Rotation accepts a range from -360 to 360 degrees, so any angle is possible, but roughly -45 produces the familiar diagonal watermark look.
Does adding a watermark change the data in the spreadsheet?+
No. The watermark is a WordArt overlay rendered on the worksheet, not a change to cell values, formulas, or formatting, similar in concept to the native watermark feature described in Microsoft's Excel watermark documentation. Removing it later requires the separate Remove Watermark action.

Same Task on Other Platforms​

Industry Use Cases & Applications​

  • Confidential Financial Reports: add "CONFIDENTIAL" watermark on quarterly financial statements
  • Draft Budget Workbooks: apply "DRAFT" watermark with high 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

Get Help​

Zapier IntegrationGet your API KeyZapier Documentation