Add Rows to Excel - Data Inserter for Zapier

What this module does

PDF4me Add Rows to Excel inserts JSON data into Excel spreadsheets directly inside your Zapier workflow. Whether you are exporting database records, API responses, form submissions, or CRM data, this module converts JSON arrays into properly formatted Excel rows with intelligent type conversion and date formatting. Works with Google Drive, Dropbox, OneDrive, and any Zapier file source.

Two insertion modes: table-based and coordinate-based

Set Table Name to insert into a named Excel table with automatic header matching. Leave Table Name empty and set Insert From Row and Insert From Column for coordinate-based mode — ideal for placing data at exact cell positions in fixed-layout templates or appending to a specific range.

Enable Convert Numeric And Date for clean formatting

Set Convert Numeric And Date to True to automatically convert JSON strings into Excel numbers and dates. Pair with Date Format (e.g., yyyy-MM-dd) and Numeric Format (e.g., N2) to ensure your data matches the locale and display requirements of your workbook without any extra Zapier formatting steps.

JSON Input must be a valid JSON array

Map Json Input from a previous Zap step that outputs a JSON array — for example, File Text from a Parse CSV step or an API response body. Single-object inserts must be wrapped in brackets: [{"Name":"John"}]. Property names in each object must match the column headers or the coordinate offset you define.

PDF4me Add Rows to Excel transforms how you move data into spreadsheets within your Zapier workflows. Whether you're exporting database queries, syncing API responses, logging form submissions, or compiling CRM reports, this action intelligently converts JSON data into properly formatted Excel rows. With support for both table-based insertion (automatically matching headers) and coordinate-based placement (precise positioning), it handles type conversion, date formatting, and internationalization automatically—saving hours of manual data entry while ensuring consistency across your workflows.

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 powerful Excel data insertion services.

Get your API Key

Configure the Excel Add Rows action—File and JSON input, worksheet targeting, and insertion coordinates.

Formatting options—type conversion, date and numeric formats, null handling.

Configuration at a Glance

Example configuration from the Zapier interface

The screenshot above shows a typical setup: inserting JSON data into Sheet2 starting at row 1, column 2, with automatic numeric and date conversion enabled.

File

add_header_sample_file.xlsx

Worksheet

Sheet2

Insert From

Row 1, Column 2

Date Format

yyyy-MM-dd

Numeric Format

N2

Ignore Null Values

True

Ignore Attribute Titles

False

Map JSON from a previous step

Use the + button next to the Json Input field to insert data from an earlier Zap step—for example, File Text from a form or API response. The action accepts a JSON array of objects like [{"Name":"John","Amount":"100"}].

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

• Dual Insertion Modes: Table-based with header matching or coordinate-based with exact positioning
• JSON Data Support: Insert single objects or arrays as Excel rows automatically
• Automatic Type Conversion: Convert JSON strings to Excel numbers and dates intelligently
• Custom Formatting: Apply date and numeric format patterns to inserted data
• Culture-Specific Parsing: Parse dates and numbers according to locale codes
• Null Value Handling: Skip null values or insert as empty cells

Parameters

Complete list of parameters for the Add Rows action. Configure these to control where and how JSON data is inserted into your Excel worksheet.

Quick setup checklist

1. Map File from your trigger or a previous step (Dropbox, Drive, etc.)
2. Map Json Input from form data, API response, or database output
3. Set Worksheet Name (e.g., Sheet2) and Insert From Row/Column for coordinate mode
4. Enable Convert Numeric And Date = True for automatic formatting

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.

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 data to receive new rows • 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: add_header_sample_file.xlsx) • Displayed as "File Name: add_header_sample_file" + "File Ext: .xlsx" in Zapier • Used for output file identification	add_header_sample_file.xlsx
Json Input***	String	JSON Data to Insert • JSON array of objects or single object • Map from previous step via + (e.g., "4. File Text" from form/API response) • Array format: [{"Name":"John","Amount":"100"}] inserts multiple rows • Property names match column headers or determine column order	[4. File Text]
Worksheet Name	String	Target Worksheet Name • Name of worksheet to insert data into • Default: "Sheet1" if not specified • Must match worksheet name exactly • Case-sensitive worksheet matching	Sheet2
Table Name	String	Excel Table Name • Name of Excel table for table-based insertion • Empty triggers coordinate-based mode • Non-empty triggers table-based mode • Determines insertion behavior	empty
Excel Row Number	Integer	Table Position (Table Mode) • 1-based position within table for insertion • 1 = first data row after headers • Must be ≥ 1 within table bounds • Ignored in coordinate mode	N/A (coordinate mode)
Insert From Row	Integer	Start Row (Coordinate Mode) • 1-based row number for insertion start • Coordinate mode only - must be ≥ 1 • Error if used with TableName • First worksheet row = 1	1
Insert From Column	Integer	Start Column (Coordinate Mode) • 1-based column number for insertion • Coordinate mode only - must be ≥ 1 • Error if used with TableName • Column A = 1, B = 2, etc.	2
Convert Numeric And Date	Boolean	Enable Type Conversion • True - Convert JSON strings to Excel numbers/dates • False - Insert all values as-is without conversion • Applies DateFormat and NumericFormat when enabled • Default: True for intelligent type handling	True
Date Format	String	Excel Date Format Pattern • Excel date format to apply • Examples: "yyyy-MM-dd", "MM/dd/yyyy", "dd-MMM-yyyy" • Default: "yyyy-MM-dd" • Used when Convert Numeric And Date enabled	yyyy-MM-dd
Numeric Format	String	Excel Numeric Format Pattern • Excel numeric format to apply • Examples: "N2", "#,##0.00", "0.00%" • Default: "N2" • Used when Convert Numeric And Date enabled	N2
Ignore Null Values	Boolean	Null Value Handling • True - Skip null values (don't insert into cells) • False - Insert null as empty cells • Default: False • Affects JSON null processing	True
Ignore Attribute Titles	Boolean	Case-Insensitive Matching • True - Case-insensitive header matching • False - Case-sensitive matching • Default: False • Useful for flexible JSON property naming	False
Culture Name	String	Culture for Date/Number Parsing • Culture code for parsing (e.g., "en-US", "de-DE") • Default: "en-US" • Affects date and number interpretation • Important for international data	en-US

Coordinate mode vs. Table mode

Coordinate mode (Table Name empty): Specify Insert From Row and Insert From Column to place data at exact cell positions. Ideal for fixed templates or appending to a specific range.

Table mode (Table Name set): Data is inserted into a named Excel table, with headers matched automatically. Use Excel Row Number to control position within the table.

Output

The PDF4me Add Rows 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 (e.g., add_header_sample_file, add_header_sample_file.xlsx, .xlsx).

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 Update Rows, Add Watermark, Secure Excel, or other PDF4me Excel actions

Same output for all PDF4me Excel actions

This output structure is shared across Add Rows, Update Rows, Delete Rows, Add Watermark, Merge Files, 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 Rows to Excel action in Zapier provides comprehensive scenario templates designed for real-world automation needs:

Database Export

Automated Daily Sales Data Export Scenario

Transform your sales reporting with automated database-to-Excel data insertion:

Complete Scenario Steps:

1. Trigger: Scheduled trigger runs daily at 11 PM
2. Query Database: Execute SQL query to fetch today's sales transactions
3. Format JSON: Convert SQL results to JSON array format
4. Get Excel Template: Fetch sales report template from Google Drive
5. Add Rows: Insert JSON data into "DailySales" table (Table Name = DailySales)
6. Set Parameters: Table Name = DailySales, Convert Numeric And Date = True
7. Apply Formats: Date Format = MM/dd/yyyy, Numeric Format = $#,##0.00
8. Upload Result: Map File Url from Add Rows output to Google Drive upload
9. Email Report: Send updated Excel to sales managers via Gmail
10. Archive Data: Store in monthly reports archive

Business Benefits:

• Inserts 200+ daily sales records into Excel automatically
• Eliminates manual data entry saving 2 hours daily
• Ensures consistent date and currency formatting
• Maintains Excel table structure and formulas automatically

Create Zap

API Data Population

Automated REST API to Excel Integration Scenario

Streamline your data integration with automated API-to-Excel data population. This scenario uses coordinate mode (matching the configuration in the screenshot above—Sheet2, Row 1, Column 2).

Complete Scenario Steps:

1. Trigger: Scheduled hourly data refresh runs every hour
2. Call REST API: Execute HTTP GET to external analytics service
3. Parse Response: Extract JSON array from API response body
4. Transform Data: Apply business logic and calculations
5. Get Excel Template: Retrieve dashboard template from Dropbox (e.g., add_header_sample_file.xlsx)
6. Add New Rows: Insert API data using coordinate mode—Worksheet Name = Sheet2, Insert From Row = 1, Insert From Column = 2
7. Enable Conversion: Convert Numeric And Date = True, Date Format = yyyy-MM-dd, Numeric Format = N2
8. Handle Nulls: Ignore Null Values = True for optional API fields
9. Upload Updated: Map output File Url from Add Rows to Dropbox upload step
10. Email Notification: Send confirmation with updated file link (optional)

Business Benefits:

• Refreshes Excel dashboard with API data 24 times daily
• Provides near real-time visibility in familiar Excel format
• Automatically formats numbers and dates from API responses
• Eliminates manual API data extraction and Excel updates

Create Zap

Form Response Logging

Automated Form Submissions to Excel Logging Scenario

Optimize your form data collection with automated Excel logging:

Complete Scenario Steps:

1. Trigger: Webhook receives new form submission data
2. Parse Submission: Extract form field values from webhook
3. Create JSON Object: Format submission data as JSON array
4. Get Excel Log: Retrieve form responses log from Google Drive
5. Add Row: Insert using coordinate mode (e.g., Sheet2, Insert From Row = 1, Insert From Column = 2 as in the screenshot)
6. Set Parameters: Worksheet Name = Sheet2, Insert From Row = 1, Insert From Column = 2
7. Handle Nulls: Ignore Null Values = True for optional form fields
8. Set Culture: Culture Name = en-US for US date formats
9. Upload Log: Map File Url from Add Rows output to Google Drive
10. Email Confirmation: Send submission receipt to form submitter

Business Benefits:

• Logs 500+ form submissions monthly automatically
• Eliminates manual form response transcription entirely
• Handles optional fields with null value skipping
• Provides real-time Excel log of all submissions

Create Zap

CRM Export

Automated Weekly CRM Data Export Scenario

Enhance your reporting with automated CRM-to-Excel data export:

Complete Scenario Steps:

1. Trigger: Scheduled weekly on Monday at 8 AM
2. Query CRM: Get all new opportunities from last week via API
3. Filter Data: Apply business logic filters and transformations
4. Format JSON Array: Convert CRM records to JSON array
5. Get Excel Template: Fetch weekly opportunities template from Dropbox
6. Add Rows: Insert into "Opportunities" table (Table Name = Opportunities)
7. Set Parameters: Table Name = Opportunities, Excel Row Number = 2, Convert Numeric And Date = True, Numeric Format = $#,##0.00, Ignore Attribute Titles = True
8. Upload Result: Map File Url from Add Rows output to Google Drive
9. Email Sales Team: Distribute Excel to sales leadership via Gmail
10. Archive/Notify: Store report and notify stakeholders

Business Benefits:

• Exports 100+ CRM opportunities weekly automatically
• Ensures accurate currency and date formatting
• Flexible header matching handles CRM field name variations
• Reduces manual CRM reporting time by 95%

Create Zap

Industry Use Cases & Applications

Sales & Marketing

• CRM Pipeline Reports: Insert opportunity data into Excel sales pipelines
• Lead Tracking Sheets: Add new leads from forms to Excel tracking logs
• Campaign Analytics: Populate marketing results from analytics APIs
• Customer Database: Export customer data from databases to Excel lists

Finance & Accounting

• Transaction Logs: Insert daily financial transactions into Excel ledgers
• Expense Tracking: Add employee expense submissions to Excel reports
• Budget vs Actual: Populate actual spending data into budget templates
• Invoice Generation: Insert invoice line items into Excel invoice templates

Human Resources

• Employee Records: Add new hire information to Excel employee databases
• Attendance Tracking: Insert daily attendance data into Excel timesheets
• Payroll Processing: Populate hours worked into Excel payroll templates
• Performance Data: Add review scores and metrics to Excel trackers

Operations & Supply Chain

• Inventory Updates: Insert stock level changes into Excel inventory sheets
• Production Logs: Add production run data to Excel manufacturing logs
• Quality Metrics: Populate QC results into Excel quality reports
• Maintenance Records: Insert equipment maintenance data into Excel logs

Get Help

Zapier IntegrationGet your API KeyZapier Documentation