Add Text Header Footer to Excel using Zapier

PDF4me Add Text Header Footer to Excel adds professional headers and footers to your spreadsheets automatically—perfect for branding, page numbering, or adding disclaimers and titles. Set text, color, and font size independently for each section (left, center, right) in both header and footer. Apply to specific worksheets or across entire workbooks for consistent document presentation and professional branding.

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

Configure the Excel Add Text Header Footer action—File input and header text, color, and font size for left, center, and right sections.

Footer settings, worksheet targeting, and culture options.

Configuration at a Glance

Example configuration from the Zapier interface

The screenshots above show a typical setup: adding text to header and footer sections (left, center, right) with customizable color and font size for each section.

File

add_header_sample_file.xlsx

Header Left

Text, Color, Font Size

Header Center

Text, Color, Font Size

Header Right

Text, Color, Font Size

Footer L/C/R

Text, Color, Font Size

Default Color

Black

Default Font Size

11

:::tip 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. :::

:::warning 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. :::

Key Features

• 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.

Quick setup checklist

1. Map File (Excel) from your trigger or a previous step
2. 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)

Important: Parameters marked with an asterisk (***) are required. 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).

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 text headers/footers 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., File Name + File Ext) • Used for output file identification	add_header_sample_file.xlsx
Header Left-Text	String	Text for left header section	Ynoox or map dynamic value
Header Left-Color	String	Color for left header text. Hex or color name	Black
Header Left-Font Size	Number	Font size (points) for left header	11
Header Center-Text	String	Text for center header section	Q4 2024 Report
Header Center-Color	String	Color for center header text	Black
Header Center-Font Size	Number	Font size for center header	11
Header Right-Text	String	Text for right header section	—
Header Right-Color	String	Color for right header text	Black
Header Right-Font Size	Number	Font size for right header	11
Footer Left-Text	String	Text for left footer section	—
Footer Left-Color	String	Color for left footer text	Black
Footer Left-Font Size	Number	Font size for left footer	11
Footer Center-Text	String	Text for center footer section	Confidential
Footer Center-Color	String	Color for center footer text	Black
Footer Center-Font Size	Number	Font size for center footer	11
Footer Right-Text	String	Text for right footer section	—
Footer Right-Color	String	Color for right footer text	Black
Footer Right-Font Size	Number	Font size for right footer	11
Target Worksheets-By Name	Array	Target worksheets by exact name. Empty = all sheets	Sheet1, Sheet2
Target Worksheets-By Index	Array	Target worksheets by index (1-based). Empty = all	[1, 2]
Culture & Language Settings	String	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.

Output

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

:::info 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. :::

Scenario Examples

The PDF4me Add Text Header Footer to Excel action in Zapier provides comprehensive scenario templates designed for real-world branding and compliance needs:

Financial Reports

Automated Financial Report Text Branding Workflow

Transform your financial reporting with automated header and footer text branding:

Complete Scenario Steps:

1. Trigger: Monthly financial close completion event
2. Get Financial Report: Retrieve monthly workbook from Google Drive
3. Add Title Header: Set Header Center-Text = "Q4 2024 Financial Results", Header Center-Font Size = 14, Header Center-Color = #003366
4. Add Confidential Footer: Set Footer Center-Text = "Confidential - Internal Use Only"
5. Apply to All Sheets: Leave Target Worksheets-By Name and Target Worksheets-By Index empty
6. Upload Branded Report: Map File Url from output to Google Drive executive folder
7. Email CFO: Send notification with download link to finance leadership
8. Archive Report: Store in monthly reports archive

Business Benefits:

• Brands 12 monthly financial reports automatically each year
• Ensures consistent confidentiality marking on all worksheets
• Eliminates manual header/footer edits, saving 15 minutes per report
• Professional appearance for executive distribution and compliance

Create Zap

Client Deliverables

Automated Client Deliverable Date Stamping Workflow

Enhance your client deliverables with automated company branding and date stamping:

Complete Scenario Steps:

1. Trigger: Client deliverable marked final in project management system
2. Get Client Workbook: Retrieve final workbook from project folder
3. Add Company Header: Set Header Left-Text = "Acme Consulting - Strategic Analysis", Header Left-Font Size = 10, Header Left-Color = Black
4. Add Date Footer: Set Footer Right-Text = "Generated: {{now}}" (map dynamic date from Zapier)
5. Set Footer Font: Footer Right-Font Size = 9
6. Apply to Visible Sheets: Target worksheets via Target Worksheets-By Name (e.g., Sheet1, Summary)
7. Upload to Client Portal: Map File Url from output to client-accessible location
8. Email Client: Send notification with branded deliverable download link
9. Archive Delivery: Store final version in project archives

Business Benefits:

• Processes 50+ client deliverables monthly automatically
• Automatic date stamping ensures version clarity and tracking
• Consistent professional branding on all client-facing materials
• Reduces manual formatting time by 20 minutes per deliverable

Create Zap

Confidential Marking

Automated Confidential Document Marking Workflow

Secure your sensitive documents with automated confidential marking:

Complete Scenario Steps:

1. Trigger: Document uploaded to confidential folder in storage system
2. Get Sensitive Document: Retrieve workbook from secure storage location
3. Add CONFIDENTIAL Header: Set Header Center-Text = "CONFIDENTIAL", Header Center-Color = #FF0000, Header Center-Font Size = 16
4. Apply to All Sheets: Leave Target Worksheets empty so marking appears on every worksheet
5. Save Marked Document: Map File Url from output to secure storage
6. Email Authorized Users: Distribute with access controls to authorized recipients
7. Log Distribution: Record distribution event in audit log

Business Benefits:

• Marks 200+ confidential files monthly automatically
• Diagonal red text provides clear visual security indicator
• Semi-transparency allows content visibility while maintaining clear marking
• Reduces risk of unmarked sensitive document distribution by 95%

Create Zap

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