Add Text Header Footer to Excel using Zapier

PDF4me Add Text Header Footer is a Zapier action that writes branded header and footer text onto Excel worksheets automatically. Use it to add titles, page references, disclaimers, or company names to the left, center, and right sections of the header and footer, with independent color and font size per section. Returns a new Excel file for the next Zap step.

What this action does

Takes an Excel workbook from a previous Zap step and writes text into the six header/footer sections (left, center, right for each), each with its own color and font size. Apply to specific worksheets by name or index, or leave both fields empty to apply the same header and footer to every sheet in the workbook. Useful for branding, page titles, confidentiality notices, or generation dates on reports that leave your workflow automatically.

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 text branding services.

Get your API Key

Important Facts You Should Not Miss

Only File is strictly required

Every header, footer, worksheet-targeting, and culture field is optional in the Zapier configuration. Leave any text field empty to skip that section entirely.

Six independent, individually styled sections

Header Left/Center/Right and Footer Left/Center/Right each take their own Text, Color, and Font Size, so you can mix a bold red center title with a small gray left-aligned date.

Worksheet targeting is optional

Use Target Worksheets-By Name or Target Worksheets-By Index to limit changes to specific sheets. Leave both empty to apply to every worksheet in the workbook.

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 to build the full filename. 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.

Configure the Excel Add Text Header Footer action: map File (required), then header text, color, and font size for the left, center, and right sections.

Footer text sections, worksheet targeting by name or index, and culture/language settings.

What Are the Key Features of Add Text Header Footer?

• Six Text Sections: Add text to header left, center, right and footer left, center, right
• Per-Section Styling: Set text, color, and font size independently for each section
• Worksheet Targeting: Target specific sheets by name or index, or leave empty for all
• Culture & Language: Configure locale for date and number formatting

Parameters

Complete list of parameters for the Add Text Header Footer action. Parameter names match the Zapier configuration UI shown in the screenshots above.

Quick setup checklist

1. Map File (Excel) from your trigger or a previous step
2. Optionally map File Name (e.g., combine File Name + File Ext from previous step)
3. Enter text for Header Left-Text, Header Center-Text, Header Right-Text (or leave empty)
4. Enter text for Footer Left-Text, Footer Center-Text, Footer Right-Text (or leave empty)
5. Optionally set Color and Font Size for each section (defaults: Black, 11)
6. Optionally specify Target Worksheets-By Name or Target Worksheets-By Index (or leave empty for all sheets)

Parameter	Required	What it does	Example
File	Required	Excel file to add text headers/footers to. Map from a previous step. Must provide full file content.	[2. File from Step 2]
File Name	Conditional	Excel filename with .xlsx or .xls extension, used for output file identification.	add_header_sample_file.xlsx
Header Left-Text	Conditional	Text for the left header section.	Ynoox
Header Left-Color	Conditional	Color for the left header text. Hex or color name.	Black
Header Left-Font Size	Conditional	Font size in points for the left header.	11
Header Center-Text	Conditional	Text for the center header section.	Q4 2024 Report
Header Center-Color	Conditional	Color for the center header text.	Black
Header Center-Font Size	Conditional	Font size for the center header.	11
Header Right-Text	Conditional	Text for the right header section.	-
Header Right-Color	Conditional	Color for the right header text.	Black
Header Right-Font Size	Conditional	Font size for the right header.	11
Footer Left-Text	Conditional	Text for the left footer section.	-
Footer Left-Color	Conditional	Color for the left footer text.	Black
Footer Left-Font Size	Conditional	Font size for the left footer.	11
Footer Center-Text	Conditional	Text for the center footer section.	Confidential
Footer Center-Color	Conditional	Color for the center footer text.	Black
Footer Center-Font Size	Conditional	Font size for the center footer.	11
Footer Right-Text	Conditional	Text for the right footer section.	-
Footer Right-Color	Conditional	Color for the right footer text.	Black
Footer Right-Font Size	Conditional	Font size for the right footer.	11
Target Worksheets-By Name	Conditional	Target worksheets by exact name. Empty applies to all sheets.	Sheet1, Sheet2
Target Worksheets-By Index	Conditional	Target worksheets by 1-based index. Empty applies to all sheets.	[1, 2]
Culture & Language Settings	Conditional	Locale for date/number formatting.	en-US

Apply to all worksheets

Leave both Target Worksheets-By Name and Target Worksheets-By Index empty to apply text headers/footers to all worksheets in the workbook.

Important: Only File is required. Every other field, including File Name, is Conditional, meaning it only matters if you want that specific section styled. Use the + button next to each field to map data from previous steps. Worksheet indexes are 1-based. Color accepts hex codes (#RRGGBB) or color names (e.g., Black, Red).

What Does Add Text Header Footer Return?

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

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.

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

Field	Type	What it contains
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 the filename in the path.
File Name	String	Base filename without extension.
File Extension	String	File extension of the returned file, 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 (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": ""
}

Zap Integration

Use + to map File Url or Alternate File Url to the next step, Drive, Dropbox, Email, or another PDF4me Excel action.

Same output for all PDF4me Excel actions

This output structure is shared across Add Text 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.

Typical Setups

Workflow ExamplesCommon Zapier workflow patterns using Add Text Header Footer.

Branded financial report distribution

1. A trigger fires when a monthly financial workbook lands in a Google Drive folder.
2. PDF4me Add Text Header Footer sets Header Center-Text to the report title and Footer Center-Text to "Confidential - Internal Use Only", applied with Target Worksheets left empty so every sheet gets the same treatment.
3. A Drive step uploads the branded workbook to an executive-facing folder.

Client deliverable with company header

1. A project-management trigger fires when a deliverable workbook is marked final.
2. PDF4me Add Text Header Footer sets Header Left-Text to the consulting firm's name and Footer Right-Text to a mapped date value from a previous step, targeting only the client-facing sheets via Target Worksheets-By Name.
3. An email step sends the client the branded, date-stamped workbook.

Confidential marking across a whole workbook

1. A trigger fires when a workbook is uploaded to a restricted-access storage folder.
2. PDF4me Add Text Header Footer sets Header Center-Text to "CONFIDENTIAL" with a red Header Center-Color, leaving Target Worksheets empty so the marking appears on every sheet.
3. The marked workbook is saved back to secure storage and its distribution is logged.

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 is required, everything else is optional

Leave any Header or Footer Text field empty to skip that section. There is no need to fill in all six sections if you only need one or two.

Culture & Language Settings affects formatting, not layout

This field controls locale-specific date and number formatting inside the values you provide, it does not reposition or reorder the header/footer sections.

Only one worksheet-targeting field is needed

Use either Target Worksheets-By Name or Target Worksheets-By Index, not both. Leaving both empty applies the header and footer to every sheet.

Color accepts hex or named values

Use a hex code like #FF0000 for exact brand colors, or a plain color name like Black or Red when precision does not matter.

Cheat Sheet

Field	Value
Action	Add Text Header Footer
File	[Mapped from previous step]
File Name	add_header_sample_file.xlsx
Header Center-Text	Q4 2024 Report
Footer Center-Text	Confidential
Default Color	Black
Default Font Size	11
Target Worksheets-By Name	Sheet1, Sheet2 (or empty for all)
Culture & Language Settings	en-US

Common Questions

How do I add a header and footer to an Excel file automatically in Zapier?+

Add the PDF4me Add Text Header Footer action to a Zap, map the Excel file from a previous step using the full-content option, and fill in the Header and Footer Text fields for the sections you want. See Microsoft's guide on Excel headers and footers for how these sections behave on the printed page.

Can I apply a header and footer to only specific worksheets?+

Yes. Use Target Worksheets-By Name to list exact sheet names, or Target Worksheets-By Index for 1-based sheet positions. Leave both fields empty to apply the header and footer to every worksheet in the workbook.

How do I create a footer with different text on the left, center, and right?+

Set Footer Left-Text, Footer Center-Text, and Footer Right-Text independently. Each section also has its own Color and Font Size fields, so you can style them differently within the same footer.

Is the File field the only required parameter?+

Yes. Only File is marked required in the Zapier configuration. File Name and every header, footer, worksheet-targeting, and culture field are optional, leaving a text field empty simply skips that section.

Does adding a header and footer change the data in the spreadsheet?+

No. The action only writes to the worksheet's header and footer regions, the same print areas described in Microsoft's header and footer documentation. Cell data, formulas, and formatting in the worksheet body are untouched.

Related Actions

Add Image Header Footer to Excel

Use a logo or image instead of text in the header or footer, a common companion when text branding alone is not enough.

Add Text Watermark to Excel

Stamp diagonal or repeating watermark text across worksheet cells, complementary to header/footer branding.

Remove Header Footer from Excel

The opposite operation, strip existing header and footer text from a workbook before applying new branding.

Same Task on Other Platforms

Add Text Header Footer in Make

Same six-section text branding module, wired into visual Make scenarios with cloud-storage triggers.

Add Text Header Footer in n8n

The equivalent n8n node for developers who want the branding logic inside a self-hosted or code-heavy workflow.

Add Text Header Footer in Power Automate

Microsoft 365 flows with SharePoint and OneDrive for organizations already standardized on Power Automate.

Add Text Header Footer REST API

The raw PDF4me API endpoint behind this action, for custom backend code or Postman testing.

Industry Use Cases & Applications

Finance & Accounting

• Financial Statement Titles: Add period titles to header (e.g., "Q4 2024 Statement of Cash Flows")
• Confidentiality Footers: Insert "Confidential - Internal Use Only" footer on all financial reports
• Report Generation Dates: Add "Generated: MM/DD/YYYY" footer for version control and tracking
• Budget Report Headers: Insert department and period headers on budget vs. actual reports
• Audit Trail Footers: Add "Prepared By: [Name]" and "Review Date: [Date]" for compliance

Sales & Marketing

• Sales Report Titles: Add "Monthly Sales Performance - [Region]" headers dynamically per region
• Campaign Report Dates: Insert campaign name and date range in header for tracking
• Pricing Sheet Footers: Add "Valid Until: [Date]" and contact information footer for quotes
• Proposal Headers: Insert company name and proposal title on all proposal worksheets
• Territory Headers: Add sales territory and manager name headers to regional reports

Human Resources

• Payroll Period Headers: Add "Payroll Period: [Start] to [End]" header on payroll sheets
• Confidential HR Footers: Insert "HR Confidential - Authorized Personnel Only" on sensitive documents
• Performance Review Titles: Add employee name and review period header to review worksheets
• Benefits Enrollment Footers: Insert enrollment period and deadline information for employees
• Employee Handbook Headers: Add document version and effective date headers

Operations

• Shift Report Headers: Add shift number, date, and supervisor name header to operational reports
• Plant Location Identifiers: Insert plant/facility name and code in header for multi-site operations
• Maintenance Log Footers: Add "Last Updated: [DateTime]" footer for equipment tracking
• Quality Control Headers: Insert inspection date and QC officer name for compliance records
• Production Run Footers: Add batch number and production date footer to manufacturing logs

Get Help

Zapier IntegrationGet your API KeyZapier Documentation