Skip to main content

Remove Watermark from Excel using n8n action

PDF4me Remove Watermark from Excel enables removal of watermarks and shapes from Excel documents through n8n automation workflows with precise control and flexible targeting. Process Excel files via n8n triggers, binary data, base64 strings, or public URLs to delete specific watermarks by shape ID/name or remove all shapes from worksheets, with flexible worksheet selection by name or index (1-based), and culture-specific localization support. This solution is ideal for document finalization, rebranding preparation, automated watermark cleanup, and template reset workflows that require watermark removal with safety controls and seamless integration.

Setup

Add the PDF4me "Remove Watermark" node to your n8n workflow and configure the required parameters. For initial setup instructions, see our n8n Integration Guide.

Prerequisites:

  • PDF4me API credentials
  • n8n workflow access

Configuration:

  1. Add PDF4me node to workflow
  2. Select "Remove watermark" action
  3. Configure input parameters (see below)
Remove Watermark from Excel

Parameters

Complete list of parameters for the Remove Watermark action. Configure these parameters to control watermark deletion.

Important: Parameters marked with an asterisk (***) are required. Worksheet indexes use 1-based numbering (1 = first worksheet).

⚠️ Critical Warning: When WatermarkId is empty, ALL shapes are removed from selected worksheets, including watermarks, charts, images, drawings, and text boxes. Use with extreme caution!

ParameterTypeDescriptionExample
Input Data Type***StringExcel Input Format Selection
• Choose the format of your Excel data input
• PDF4me supports multiple input types
• Options: Binary Data, Base64 String, or URL
Binary Data
Input Binary Field***BinaryBinary Excel File Input (Required if Binary Data)
• Reference Excel file (.xlsx, .xls) from previous n8n node or file upload
• PDF4me processes binary Excel files with automatic format detection
• Required when Input Data Type is "Binary Data"
{{ $binary.data }}
Base64 Excel Content***StringBase64 Encoded Excel Input (Required if Base64 String)
• Provide Excel content (.xlsx, .xls) as base64 encoded string
• PDF4me automatically decodes and processes the Excel content
• Required when Input Data Type is "Base64 String"
UEsDBBQABgAI...
Excel URL***StringPublic Excel URL Input (Required if URL)
• Provide a public/open permission URL to the Excel file (.xlsx, .xls)
• PDF4me downloads and processes the Excel file from the provided URL
• Required when Input Data Type is "URL"
https://abc.com/data.xlsx
Excel Name***StringExcel Input Filename
• Specify the name of the input Excel file with proper extension (.xlsx, .xls)
• PDF4me uses this for format detection and processing optimization
data.xlsx
Watermark IDStringSpecific Watermark Shape Name
• Name/ID of specific watermark to delete - searches for shapes with matching Name
✅ Safe (Specified): Removes ONLY matching shapes, preserves all other shapes (charts, images, etc.)
⚠️ Dangerous (Empty): Executes worksheet.Shapes.Clear() - removes ALL shapes (watermarks, charts, images, drawings, text boxes) - cannot be undone
Case-sensitive exact match: "Confidential" ≠ "confidential" ≠ "CONFIDENTIAL"
• ⚠️ Use empty value ONLY if you want to remove everything
Confidential_Watermark
Worksheet NamesStringComma-Separated Worksheet Names
• List of worksheet names to process
• Format: "Sheet1,Summary"
Selection Logic: If has values → Process those named worksheets. If both parameters have values → Process worksheets matching EITHER (union). If BOTH empty → Process ALL worksheets
• Case-sensitive worksheet names
Sheet1,Summary
Worksheet IndexesStringComma-Separated Indexes (1-based)
• List of worksheet indexes to process
• Format: "1,3" (Index 1 = first worksheet, Index 2 = second worksheet, etc.)
1-based indexing: Index 1 = first worksheet, Index 2 = second worksheet, etc. (Valid range: 1 to total worksheet count)
Selection Logic: If has values → Process those indexed worksheets. Union with WorksheetNames
• Empty = apply to all worksheets (if names also empty)
1,3
Culture NameStringCulture Code for Localization
• Culture/locale code for processing
• Examples: "en-US", "de-DE", "fr-FR"
• Empty string uses default culture
• Default: "" (empty)
en-US
Binary Data Output Name***StringBinary Data Output Mapping
• Define the variable name for accessing generated Excel binary data
• Used in subsequent workflow actions
• Essential for workflow automation
document

Output

Output Parameters

ParameterTypeDescriptionExample
fileNameStringExcel document filename without watermark - The name of the output Excel document file after watermark removalexcel_without_watermark.xlsx
fileSizeNumberFile size in bytes - The size of the Excel document in bytes after watermark removal212810
successBooleanPDF4me operation status - Boolean flag indicating the success or failure of the watermark removal process. PDF4me returns true for successful operations and false for any errorstrue
originalFileNameStringOriginal Excel document filename - The name of the input Excel document filemyExcelFile.xlsx
watermarkIdStringWatermark ID used - The watermark ID/name that was used for removal. Empty string if all shapes were removed``
cultureNameStringCulture/Locale code - Culture code used for processing (empty string if default culture was used)``
worksheetSelectionNumberWorksheet selection mode - The worksheet selection mode used. Values: 0 = all worksheets, 1 = selected worksheets1
selectedWorksheetNamesArraySelected worksheet names - Array of worksheet names where watermark removal was applied (empty if all worksheets)[]
selectedWorksheetIndexesArraySelected worksheet indexes - Array of worksheet indexes where watermark removal was applied (empty if all worksheets)[]
messageStringOperation message - Descriptive message indicating the result of the watermark removal operationWatermark removed from Excel file successfully

N8N Action Response

The PDF4me Remove watermark API returns a response that can be viewed in multiple formats. Choose the view that best fits your needs:

JSON Response Format

The raw JSON response from the API:

[
{
"fileName": "excel_without_watermark.xlsx",
"fileSize": 212810,
"success": true,
"originalFileName": "myExcelFile.xlsx",
"watermarkId": "",
"cultureName": "",
"worksheetSelection": 1,
"selectedWorksheetNames": [],
"selectedWorksheetIndexes": [],
"message": "Watermark removed from Excel file successfully"
}
]

Note: No error is thrown if WatermarkId doesn't exist - operation completes silently.

Use Cases

Document Finalization

  • Remove "DRAFT" watermarks from approved documents
  • Clean up review watermarks before final distribution
  • Prepare documents for publication by removing status markers

Rebranding Preparation

  • Remove old watermarks before applying new branding
  • Clean templates for rebranding initiatives
  • Update document appearance by removing outdated watermarks

Template Reset and Cleanup

  • Remove sample watermarks from templates
  • Clean up watermarks from reusable document templates
  • Reset templates for new use by removing previous markings

Get Help