Add Image Header Footer to Excel - Branding for Zapier

What this module does

PDF4me Add Image Header Footer to Excel automatically inserts images into Excel headers and footers for professional branding and document presentation. Place company logos, confidentiality watermarks, or decorative elements with precise alignment control—targeting specific worksheets or entire workbooks. Works with Google Drive, Dropbox, OneDrive, and any Zapier file source.

PNG is recommended for logo transparency

The action supports PNG, JPG, JPEG, and GIF image formats. PNG is strongly recommended for company logos and watermarks because it preserves transparency—ensuring your logo blends cleanly into the header without a white box background appearing on printed or exported worksheets.

Leave worksheet fields empty to target all sheets

Leave both Worksheet Names and Worksheet Indexes empty to apply the image header or footer to every worksheet in the workbook automatically. Specify names or indexes only when you need to brand a subset of sheets—useful for co-branded client deliverables where only the summary sheets get your logo.

Map full file content — not "Exists but not shown"

Both the File (Excel) and Image File fields must receive full binary content, not a URL reference labeled "Exists but not shown." If you see that message, select the option that passes the actual file data from your trigger or prior step. See the Zapier troubleshooting guide for details.

PDF4me Add Image Header Footer to Excel automatically inserts images into Excel headers and footers for professional branding and document presentation. Place company logos, confidentiality watermarks, or decorative elements with precise alignment control (left, center, or right). Target specific worksheets or apply images across entire workbooks, with full margin control to position images exactly where you want them. Perfect for adding professional branding to reports, marking documents confidential, or creating branded templates for consistent company presentation.

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 formatting services.

Get your API Key

Configure the Excel Add Image Header Footer action—File and Image inputs, placement, worksheet targeting, and margins.

Configuration at a Glance

Example configuration from the Zapier interface

The screenshot above shows a typical setup: adding an image (e.g., company logo) to the header or footer of an Excel file, with placement control and worksheet targeting.

File

add_header_sample_file.xlsx

Is Header

True

Position

Center

Worksheets

Sheet1, Sheet2

Margins

1.9 cm (default)

:::tip Map File and Image from previous steps Use the + button next to File and Image File to map from earlier Zap steps—e.g., Excel from Google Drive and logo from a previous action. Both the Excel file and the image file must provide full content, not "Exists but not shown" references. :::

:::warning File: (Exists but not shown) If you see "File: (Exists but not shown)" in the File or Image 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

• Header or Footer Placement: Choose top (header) or bottom (footer)
• Position Alignment: Left, Center, or Right segment placement
• Worksheet Targeting: Specific worksheet names or indexes, or all worksheets
• Margin Customization: Configure page margins (cm)
• Image Formats: PNG, JPG, JPEG, GIF supported—PNG recommended for transparency

Parameters

Complete list of parameters for the Add Image Header Footer action. Configure these to control image placement and page layout.

Quick setup checklist

1. Map File (Excel) from your trigger or a previous step
2. Map Image File (logo/watermark) from a previous step
3. Set Image Name with extension (e.g., company_logo.png)
4. Choose Is Header (True = header, False = footer) and Position (Left, Center, Right)
5. Optionally specify Worksheet Names or leave empty for all sheets

Important: Parameters marked with an asterisk (***) are required. Parameter names match the Zapier configuration UI. Use the + button next to each field to map data from previous steps. Worksheet indexes are 1-based.

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 image header/footer 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., Full File Name) • Used for output file identification	add_header_sample_file.xlsx
Image File***	File	Source Image Content • Binary image data (PNG, JPG, GIF) • Map from previous step (e.g., logo from Drive) • PNG recommended for transparency	[3. File from Step 3]
Image Name***	String	Source Image Filename • Name with extension for identification • Any standard image format	company_logo.png
Is Header	Boolean	Placement • True - Add to header (top) • False - Add to footer (bottom) • Default: True	True
Position	String	Horizontal Segment • Left, Center, Right • Controls which header/footer section is used	Center
Worksheet Names	Array	Target Worksheets by Name • Exact case-sensitive names • If both Names and Indexes empty → applies to all sheets • Add multiple with + button	Sheet1, Sheet2
Worksheet Indexes	Array	Target Worksheets by Index (1-based) • 1 = first worksheet • Union with Names when both provided • Empty with Names = all sheets	[1, 2]
Top Margin (cm)	Number	Top Page Margin • Affects header spacing from page edge • Default: 1.9 cm	1.9
Bottom Margin (cm)	Number	Bottom Page Margin • Affects footer spacing from page edge • Default: 1.9 cm	1.9
Left Margin (cm)	Number	Left Page Margin • Adjust to align with document layout	1.9
Right Margin (cm)	Number	Right Page Margin • Adjust to align with document layout	1.9

Apply to all worksheets

Leave both Worksheet Names and Worksheet Indexes empty to apply the image header/footer to all worksheets in the workbook. Use either or both fields to target specific sheets only.

Output

The PDF4me Add Image Header Footer 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, Add Text Header Footer, or other PDF4me Excel actions

:::info Same output for all PDF4me Excel actions This output structure is shared across Add Image Header Footer, Add Rows, Update Rows, Add Watermark, 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 Image Header Footer to Excel action in Zapier provides scenario templates designed for real-world branding workflows:

Corporate Branding

Automated Corporate Logo Header Workflow

Add your company logo to Excel report headers automatically.

Complete Scenario Steps:

1. Trigger: Scheduled weekly report generation
2. Get Excel Report: Retrieve workbook from Google Drive
3. Get Logo Image: Fetch company logo from Drive or assets folder
4. Add Image Header Footer: Map File (Excel), Image File (logo), Image Name = company_logo.png
5. Set Parameters: Is Header = True, Position = Center
6. Apply to All Sheets: Leave Worksheet Names and Worksheet Indexes empty
7. Set Margins: Use 1.9 cm defaults (or customize Top/Bottom/Left/Right Margin)
8. Upload Result: Map File Url from Add Image Header Footer output to Google Drive
9. Email Distribution: Send branded report to management

Business Benefits:

• Brands 52+ weekly reports annually automatically
• Ensures consistent corporate identity on all worksheets
• Eliminates manual header edits, saving 10+ minutes per report

Create Zap

Confidential Watermark

Automated Confidential Footer Watermark Workflow

Add a "Confidential" watermark image to Excel footers for sensitive documents.

Complete Scenario Steps:

1. Trigger: File uploaded to confidential folder in Dropbox
2. Get Document: Retrieve Excel workbook from storage
3. Get Watermark: Fetch "Confidential" watermark image from assets
4. Add Image Header Footer: Map File (Excel), Image File (watermark)
5. Set Parameters: Is Header = False, Position = Center (footer placement)
6. Target Specific Sheets: Worksheet Names = Sheet1, Sheet2 (or leave empty for all)
7. Set Margins: Increase Bottom Margin if needed (e.g., 2.5)
8. Upload Result: Map File Url from output to secure folder
9. Email Team: Distribute to authorized users only

Business Benefits:

• Watermarks 150+ sensitive files monthly
• Provides visible security marking across selected sheets
• Reduces risk of unbranded sensitive distribution

Create Zap

Client Deliverables

Automated Client Deliverable Co-Branding Workflow

Add company and client logos to Excel deliverables.

Complete Scenario Steps:

1. Trigger: Project deliverable marked final in form/database
2. Get Excel Deliverable: Retrieve workbook from Google Drive
3. Get Company Logo: Fetch your company logo
4. Add Image Header Footer (Run 1): Add company logo—Position = Right, Is Header = True
5. Get Client Logo: Fetch client logo from assets
6. Add Image Header Footer (Run 2): Add client logo—Position = Left, Is Header = True
7. Target Sheets: Worksheet Names = Executive Summary, Analysis (or leave empty)
8. Upload Result: Map File Url from output to client portal
9. Email Client: Send co-branded workbook to client

Business Benefits:

• Produces co-branded deliverables consistently
• Improves professionalism and client experience
• Saves 20+ minutes per deliverable in manual edits

Create Zap

Industry Use Cases & Applications

Finance & Accounting

• Financial Statements Branding: Add company logo to header of financial reports
• Audit Report Watermark: Add "Confidential" or audit firm logo to footer
• Compliance Documentation: Brand regulatory submission workbooks

Sales & Marketing

• Sales Reports: Add corporate logos to sales pipeline and performance reports
• Pricing Sheets: Brand pricing and quote documents with header logos
• Proposal Headers: Add company branding to proposal workbooks

Human Resources

• Payroll Reports: Add company branding to payroll summary headers
• Employee Handbooks: Brand internal document worksheets

Operations

• Production Summaries: Add facility or division logos to operational reports
• Inventory Reports: Brand inventory and stock reports

Get Help

Zapier IntegrationGet your API KeyZapier Documentation