Add Image Header Footer to Excel - Branding for Make

What this module does

PDF4me Add Image Header Footer to Excel automatically inserts company logos, watermark images, and branding elements into Excel headers or footers within Make scenarios. Control horizontal alignment (left, center, or right), target specific worksheets by name or index, and fine-tune page margins, delivering professional report branding at scale. Works with Google Drive, Dropbox, SharePoint, and email attachment workflows.

Use PNG for logos that need transparent backgrounds

PNG images with transparency blend cleanly into Excel headers and footers regardless of sheet background color. JPG images will show a white rectangular background. Always use PNG for logos, signatures, and watermark graphics where background transparency matters.

Leave worksheet selectors empty to brand all sheets at once

When both Worksheet Names and Worksheet Indexes are left empty, the module applies the image header or footer to every worksheet in the workbook in a single operation. For selective branding, provide names like ["Summary","Report"] or 1-based indexes like [1,3] to target only specific tabs.

Adjust top and bottom margins to prevent header/footer overlap

The default margin of 1.9 cm works for most logos. If your logo image is tall, increase the top margin (for headers) or bottom margin (for footers) to prevent the image from overlapping into the printable content area. Margins are set in centimeters and apply to all targeted worksheets.

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 Make, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Make scenarios 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 Image Header Footer to Excel module. 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 scenario variables	report.xlsx
Document***	Buffer	Excel File Content • Map from previous module (Drive/Dropbox/HTTP) • Binary Excel file to update headers/footers • Workbook remains otherwise unchanged	[Buffer from Get File]
Image Name***	String	Source Image Filename • Name with extension used for identification • Any standard image format	company_logo.png
Image File***	Buffer	Source Image Content • Binary image data (PNG, JPG, GIF) • PNG recommended for transparency	[Image Buffer]
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
Name	String	Output Excel filename
Doc Data	Buffer	Excel document with image header/footer

JSON

JSON Response Format

The raw JSON response from the module:

{
"Name": "report.xlsx",
"Doc Data": "[Buffer Data]"
}

Scenario Integration

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

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

Make IntegrationGet your API KeyMake Documentation