Update Rows in Excel - Data Modifier for Zapier

PDF4me Update Rows in Excel keeps your spreadsheets current without manual intervention. Unlike adding new rows, this action modifies existing data in-place—perfect for refreshing inventory counts, updating customer information, syncing CRM records, or keeping reports aligned with your database. With intelligent header matching, it automatically converts JSON data types, handles date formatting for different locales, and respects your spreadsheet structure. Whether you're managing product catalogs, tracking customer data, or maintaining operational reports, this action ensures your Excel files stay synchronized with your business systems.

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 update services.

Get your API Key

Configure the Update Rows action—File input, JSON data, worksheet, and formatting options.

Configuration at a Glance

Example configuration from the Zapier interface

The screenshot above shows File and File Name mapped from a previous step, Worksheet Name = Sheet1, Json Input from step 14, Convert Numeric And Date = True, Date Format = yyyy-MM-dd, Numeric Format = N2, Ignore Null Values = True, Culture Name = en-US.

Worksheet Name

Sheet1

Json Input

JSON array from step

Convert Numeric And Date

True

Date Format

yyyy-MM-dd

Numeric Format

N2

Ignore Null Values

True

Culture Name

en-US

:::tip Map File and Json Input from previous steps Use the + button next to File and File Name to map from earlier Zap steps. Map Json Input from a step that outputs JSON array (e.g., API response, File Text from Parse CSV). 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 errors, select the option that provides the full file content instead. See Zapier & Power Automate Tips for details. :::

Key Features

• In-Place Updates: Modify existing cells; Json Input must be a JSON array
• Header Matching: Property names match Excel column headers
• Insert From Row / Insert From Column: 1-based start position (e.g., row 2 to skip headers)
• Convert Numeric And Date: True = convert strings to Excel numbers/dates
• Date Format / Numeric Format: Apply formatting when conversion enabled
• Ignore Null Values: True = skip nulls; False = update to empty
• Ignore Attribute Titles: Case-insensitive header matching when True

Parameters

Complete list of parameters for the Update Rows action. Parameter names match the Zapier configuration UI.

Quick setup checklist

1. Map File (Excel) and File Name from previous step
2. Map Json Input (JSON array from API, Parse CSV, or another step)
3. Set Worksheet Name (default Sheet1)
4. Set Insert From Row and Insert From Column (1-based; typically 2, 1 for data rows)
5. Configure Convert Numeric And Date, Date Format, Numeric Format, Ignore Null Values

Important: Parameters marked with an asterisk (***) are required. Json Input must be a JSON array—wrap single objects in [...].

Parameter	Type	Description	Example
File***	File	Excel File Content—map from previous step	[2. File from Step 2]
File Name	String	Excel Filename—with .xlsx or .xls extension	add_header_sample_file.xlsx
Worksheet Name	String	Target worksheet—default Sheet1	Sheet1
Json Input***	String	JSON array—each object updates one row. Property names match column headers	[{"Name":"John","Age":31}]
Insert From Row	Number	1-based first row to update—typically 2 to skip headers	1 or 2
Insert From Column	Number	1-based column offset for header matching	1
Convert Numeric And Date	Boolean	Convert JSON strings to Excel numbers/dates	True
Date Format	String	Excel date format when conversion enabled	yyyy-MM-dd
Numeric Format	String	Excel numeric format when conversion enabled	N2
Ignore Attribute Titles	Boolean	Case-insensitive header matching	False
Ignore Null Values	Boolean	Skip null values vs. update to empty	True
Culture Name	String	Locale for date/number parsing	en-US

Output

The PDF4me Update Rows in Excel action returns the modified Excel file for use in subsequent Zap steps. The output format is common across all PDF4me Excel file-returning actions in Zapier.

Key output fields (map these to your next step)

File Url

API endpoint to download the updated Excel file. Map this to the next step's file input.

api.pdf4me.com/Zapier/GetDocument?d=...

Alternate File Url

Alternative download URL with filename in path.

api.pdf4me.com/Zapier/GetAltDocument/.../add_header_sample_file.xlsx

Table

Parameter	Type	Description
Job Id	String	Unique identifier for the Zapier job execution
File Url	URL	API endpoint to download the updated 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
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

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",
  "Full File Name": "add_header_sample_file.xlsx",
  "File Extension": ".xlsx",
  "Document Id": "...",
  "File Size": 212764
}

Zap Integration

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

Scenario Examples

The PDF4me Update Rows in Excel action in Zapier provides comprehensive scenario templates designed for real-world data synchronization needs:

Database Sync

Automated Database-to-Excel Sync Scenario

Keep your Excel reports in sync with database changes automatically:

Complete Scenario Steps:

1. Trigger: Scheduled trigger runs every 4 hours for data refresh
2. Query Database: Execute SQL query to fetch updated records since last sync
3. Format JSON: Convert SQL results to JSON array format with proper property names
4. Get Excel Report: Fetch master report template from Google Drive
5. Update Rows: Map File, File Name, Json Input (from step 3); set Worksheet Name, Insert From Row = 2, Convert Numeric And Date = True, Ignore Null Values = True, Date Format = MM/dd/yyyy, Numeric Format = $#,##0.00
6. Upload Result: Map File Url from output to Google Drive replacing old version
7. Email Team: Send notification of data refresh completion to team
8. Log Sync: Record sync timestamp and record count in sync log

Business Benefits:

• Syncs 500+ database records to Excel 6 times daily automatically
• Eliminates manual data entry and reduces errors by 100%
• Ensures Excel reports always reflect current database state
• Maintains Excel formulas and formatting while updating data

Create Zap

API Data Refresh

Automated API-to-Excel Data Refresh Scenario

Keep Excel dashboards current with external API data automatically:

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 calculations and transformations
5. Get Excel Dashboard: Retrieve live dashboard from Dropbox
6. Update Rows: Map File, File Name, Json Input (API data); set Insert From Row = 2, Convert Numeric And Date = True, Culture Name = en-US
7. Upload Result: Map File Url from output to Dropbox

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
• Preserves dashboard structure, formulas, and charts while updating data

Create Zap

CRM Data Update

Automated CRM-to-Excel Update Scenario

Synchronize Excel reports with CRM opportunity updates automatically:

Complete Scenario Steps:

1. Trigger: Webhook receives CRM opportunity update event
2. Get Opportunity Details: Query CRM for full opportunity record
3. Find Excel Row: Search Excel for matching opportunity ID row
4. Create JSON Update: Build JSON object with updated fields
5. Get Excel Report: Retrieve opportunities tracking Excel from Google Drive
6. Update Rows: Map File, File Name, Json Input; set Ignore Attribute Titles = True, Numeric Format = $#,##0.00
7. Upload Result: Map File Url from output to Google Drive
8. Email Sales Manager: Send notification of opportunity update

Business Benefits:

• Updates 200+ opportunity records monthly automatically
• Ensures Excel reports match CRM state in real-time
• Flexible header matching handles CRM field name variations
• Reduces manual CRM-to-Excel data copying by 100%

Create Zap

Inventory Refresh

Automated Inventory Level Update Scenario

Keep Excel inventory sheets synchronized with real-time stock levels:

Complete Scenario Steps:

1. Trigger: Inventory update event from warehouse management system
2. Get Updated Stock Levels: Query inventory database for current levels
3. Format Inventory JSON: Convert to JSON array with SKU and quantity
4. Get Inventory Excel: Retrieve master inventory Excel from SharePoint
5. Update Rows: Map File, File Name, Json Input; set Insert From Row = 2, Ignore Null Values = True, Numeric Format = 0
6. Upload Result: Map File Url from output to SharePoint
7. Trigger Alerts: Check for low stock and send alerts if needed

Business Benefits:

• Updates 1000+ SKU inventory levels multiple times daily
• Provides real-time inventory visibility in Excel format
• Eliminates manual inventory data entry and reconciliation
• Supports proactive stock management with current data

Create Zap

Industry Use Cases & Applications

Sales & Marketing

• CRM Opportunity Updates: Modify opportunity rows in Excel with latest status, amounts, and close dates
• Campaign Performance Refresh: Update campaign metrics rows with current impressions, clicks, conversions
• Lead Score Updates: Refresh lead scoring data in Excel tracking sheets from marketing automation
• Customer Database Sync: Update customer record rows with latest contact info and purchase history
• Sales Forecast Updates: Modify forecast rows with updated pipeline data and win probabilities

Finance & Accounting

• Transaction Updates: Modify transaction rows with corrected amounts, dates, or account codes
• Account Balance Refresh: Update account balance rows with current balances from accounting system
• Budget Tracking Updates: Modify actual spending rows in budget vs. actual templates
• Expense Report Updates: Update expense rows with approval status and reimbursement amounts
• Invoice Status Updates: Refresh invoice rows with payment status and dates from billing system

Human Resources

• Employee Record Updates: Modify employee rows with promotions, salary changes, department transfers
• Attendance Updates: Update attendance rows with corrected clock-in/out times and PTO usage
• Performance Score Updates: Refresh review score rows with updated ratings and goal progress
• Benefits Enrollment Updates: Modify enrollment rows with plan selections and dependent changes
• Training Status Updates: Update training completion rows with dates and certification status

Operations & Supply Chain

• Inventory Level Updates: Modify stock level rows with real-time quantity updates from warehouse
• Order Status Updates: Refresh order rows with current fulfillment and shipping status
• Production Updates: Update production run rows with actual output, downtime, and quality metrics
• Supplier Updates: Modify supplier rows with updated contact info, lead times, and pricing
• Equipment Status Updates: Refresh equipment rows with maintenance dates and operational status

Get Help

Zapier IntegrationGet your API KeyZapier Documentation