Add Image Header Footer to Excel - Branding for Zapier

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

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)

Parameters

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

Important: Parameters marked with an asterisk (***) are required. Worksheet indexes follow Power Automate convention for this action (1-based).

Parameter	Type	Description	Example
File Name***	String	Excel Document Name • Filename with .xlsx or .xls extension • Used for processing and output naming • Supports dynamic naming from Zap variables	report.xlsx
Document***	File	Excel File Content • Map from previous step (Drive/Dropbox/HTTP) • Binary Excel file to update headers/footers • Workbook remains otherwise unchanged	[File from Dropbox]
Image Name***	String	Source Image Filename • Name with extension used for identification • Any standard image format	company_logo.png
Image File***	File	Source Image Content • Binary image data (PNG, JPG, GIF) • PNG recommended for transparency	[Image File]
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 the header/footer section used	Center
Worksheet Names	Array	Target Worksheets by Name • Exact case-sensitive names • If both Names and Indexes empty → applies to all sheets	["Summary","Report"]
Worksheet Indexes	Array	Target Worksheets by Index (1-based) • 1 = first worksheet • Union with Names when both provided • Empty together with Names = all sheets	[1,3]
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

Output

Table

Table View

Parameter	Type	Description
File	URL	Direct URL to access the Excel with image header/footer
File Name	String	The filename without extension
Full File Name	String	Complete filename with .xlsx extension
File Extension	String	File extension (.xlsx)

JSON

JSON Response Format

The raw JSON response from the action:

{
  "File": "https://...",
  "File Name": "report",
  "Full File Name": "report.xlsx",
  "File Extension": ".xlsx"
}

Zap Integration

Zapier Workflow Usage

• Email Distribution: Send branded Excel reports to stakeholders
• Cloud Storage: Upload to Google Drive/Dropbox for collaboration
• Convert to PDF: Create PDF outputs with newly branded headers/footers

Scenario Examples

Corporate Branding

Automated Corporate Logo Header Workflow

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 assets
4. Add Logo Header: Insert image to header center
5. Apply to All Sheets: Leave worksheet selectors empty
6. Set Margins: Use 1.9 cm defaults for professional layout
7. 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

Complete Scenario Steps:

1. Trigger: File uploaded to confidential folder
2. Get Document: Retrieve workbook from storage
3. Get Watermark: Fetch "Confidential" watermark image
4. Add Footer Image: Insert to footer center
5. Target Specific Sheets: Provide worksheet names/indexes
6. Set Margins: Increase bottom margin if needed
7. 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

Client Deliverables

Automated Client Deliverable Co‑Branding Workflow

Complete Scenario Steps:

1. Trigger: Project deliverable marked final
2. Add Company Logo: Header right position
3. Add Client Logo: Header left position (second run)
4. Target Sheets: Apply to executive and analysis sheets
5. 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

Industry Use Cases & Applications

Finance & Accounting

• Financial statements branding
• Audit report watermark footer

Sales & Marketing

• Sales reports with corporate logos
• Pricing sheets with header logos

Human Resources

• Payroll reports with company branding

Operations

• Production summaries with facility logos

Get Help

Zapier IntegrationGet your API KeyZapier Documentation