Skip to main content
PDF4me APIIntegrationsKnowledge BaseExtensionsAPI TesterBlog

Update Rows in Excel in Zapier

PDF4me Update Rows in Excel is a Zapier action that modifies existing spreadsheet rows in place from a JSON array, matching property names to your column headers. Use it to sync CRM records, refresh inventory counts, or keep reports aligned with a database, all without breaking your spreadsheet's formulas or layout.

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

Get your API Key
PDF4me Excel Update Rows in a Worksheet Zapier configuration - File, File Name, Worksheet Name, Json Input, Insert From Row, Insert From Column, Convert Numeric And Date, Date Format, Numeric Format, Ignore Attribute Titles, Ignore Null Values, Culture Name
Configure the Update Rows action, File input, JSON data, worksheet, and formatting options.

Important Facts You Should Not Miss​

Json Input must be a JSON array, even for one row
Wrap a single object in square brackets, [{"Name":"John","Age":31}]. Each object in the array updates one row; property names are matched against your Excel column headers.
This action updates existing rows only
Update Rows never inserts brand-new rows. Set Insert From Row to the first row you want to overwrite (typically 2 to skip the header). To append rows instead, use Add Rows.
Map full file content, not a file reference
If File shows "Exists but not shown" and the step errors, pick the field from the prior step that carries the actual binary content. See Zapier & Power Automate Tips.
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.

How does Update Rows match my JSON data to Excel columns?​

Update Rows reads the header row of your worksheet and matches each property name in your Json Input array to a column header with the same name. Set Ignore Attribute Titles to True for case-insensitive matching, useful when your source system's field names don't exactly match Excel's casing (for example, a CRM export using customerName against an Excel header of Customer Name).

What is the difference between Update Rows and Add Rows?​

Update Rows overwrites data in rows that already exist, starting at the position set by Insert From Row and Insert From Column. It never creates new rows. If your JSON array has more records than existing rows below the start position, use Add Rows to append instead, or combine both actions in a Zap: Update Rows for existing IDs, Add Rows for new ones.

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

Required: File and Json Input. Json Input must be a JSON array, wrap single objects in [...].

ParameterRequiredWhat it doesExample
FileRequiredExcel file content, mapped from a previous step. Must provide full binary content, not a reference labeled Exists but not shown.2. File from Step 2
File NameConditionalExcel filename with .xlsx or .xls extension.add_header_sample_file.xlsx
Worksheet NameConditionalTarget worksheet name. Defaults to Sheet1 when left blank.Sheet1
Json InputRequiredJSON array where each object updates one row. Property names are matched against Excel column headers.[{"Name":"John","Age":31}]
Insert From RowConditional1-based first row to update. Use 2 to skip the header row.2
Insert From ColumnConditional1-based column offset used for header matching.1
Convert Numeric And DateConditionalWhen True, converts JSON string values into native Excel numbers and dates.True
Date FormatConditionalExcel date format applied when Convert Numeric And Date is True.yyyy-MM-dd
Numeric FormatConditionalExcel numeric format applied when Convert Numeric And Date is True.N2
Ignore Attribute TitlesConditionalWhen True, matches JSON property names to column headers case-insensitively.False
Ignore Null ValuesConditionalWhen True, null values in Json Input are skipped instead of clearing the cell.True
Culture NameConditionalLocale used to interpret dates and numbers during conversion.en-US

What does the Update Rows action return?​

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.

FieldTypeWhat it contains
Job IdStringUnique identifier for the Zapier job execution.
File UrlURLAPI endpoint to download the updated Excel file. Map this to the next step’s file input.
Alternate File UrlURLAlternate download URL with the filename embedded in the path.
File NameStringBase filename without extension.
File ExtensionStringFile extension of the output file.
Full File NameStringComplete filename with extension.
Document IdStringUnique identifier for the processed document.
File SizeNumberSize of the output file in bytes.

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
}

Typical Setups​

Scheduled database sync
A Schedule trigger queries the database on an interval, formats results as a JSON array, and Update Rows overwrites the matching rows in a shared report so it always reflects current data.
API-driven dashboard refresh
A scheduled Zap calls a REST API, parses the JSON response, and Update Rows writes the values into an Excel dashboard stored in Dropbox or Google Drive, preserving existing formulas and charts.
CRM opportunity tracking
A webhook fires when a CRM opportunity changes stage. The Zap builds a JSON object with the updated fields and Update Rows refreshes the matching row in an Excel opportunity tracker.

Practical Tips​

Always set Insert From Row to 2 when your worksheet has a header row in row 1, otherwise the header itself gets overwritten.

Use Ignore Null Values = True when your JSON source only sends changed fields, so unrelated cells aren't wiped to blank.

Test with a small JSON array (1-2 objects) first to confirm header matching before running against a full dataset.

Cheat Sheet​

  • Existing rows only: use Add Rows to append new ones.
  • Json Input is always an array, wrap single objects in [...].
  • Header matching is case-sensitive unless Ignore Attribute Titles is True.
  • Set Convert Numeric And Date to True to keep numbers and dates native, not text.
  • Map full file content in File, never an "Exists but not shown" reference.

Scenario Examples​

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

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

What this accomplishes:

  • Syncs database records to Excel automatically on a schedule
  • Removes manual data entry between the database and the report
  • Keeps Excel reports aligned with current database state
  • Preserves Excel formulas and formatting while updating data

Industry Use Cases & Applications​

  • 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

Common Questions​

How do I update multiple rows in Excel at once with Zapier?+
Map a JSON array to Json Input where each object represents one row. PDF4me matches each object's property names to your Excel column headers and updates every row in the array in a single action. See Microsoft's guidance on resizing Excel tables for how Excel itself expects table rows to grow.
What happens if Json Input has fields that don't match my column headers?+
By default, matching is case-sensitive, so Name and name are treated as different headers. Set Ignore Attribute Titles to True to match headers case-insensitively. Fields with no matching header are ignored, not added as new columns.
Does Update Rows add new rows if they don't already exist?+
No. Update Rows only modifies existing rows starting at the position set by Insert From Row and Insert From Column. To append brand-new rows, use the Add Rows action instead.
Why do my dates or numbers show up as plain text after updating?+
Set Convert Numeric And Date to True and specify a Date Format (for example yyyy-MM-dd) and Numeric Format (for example N2). Without this, JSON string values are written as text rather than native Excel numbers or dates.
How do I avoid the 'File: (Exists but not shown)' error?+
In the File field, pick the option from the previous step that provides full file content rather than a reference labeled "Exists but not shown." See the Zapier & Power Automate Tips guide for the full explanation.

Same Task on Other Platforms​

Get Help​

Zapier IntegrationGet your API KeyZapier Documentation