Enrich Algolia Records With New Fields Using a Spreadsheet

The Scenario

You are a catalog manager at a fashion retailer. Marketing launched a sustainability initiative: every product record in Algolia needs a sustainability_score field, rated 1 to 5, sourced from a supplier assessment.

You have an Excel workbook with 2,000 rows: columns for objectID and sustainability_score. The Algolia records already exist. You need to add the new field without touching price, inventory count, or any other field.

The bad version of this Tuesday:

• You look up Algolia's partial update API
• You write a script to batch the rows into chunks
• It fails in production because you used a search-only API key
• You get the right key and re-run
• The second batch errors on row 1,200 due to a timeout
• You re-run from row 1,200 but the records between 1,100 and 1,200 get written twice
• Partial updates are idempotent so the data is fine, but you spent three hours on what should have taken twenty minutes

The fast version is one prompt.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your Excel workbook that reads the mapping data and sends partial updates to Algolia, handling batching automatically.

Open the SheetXAI sidebar and type:

For each row in the Badges tab with columns objectID and sustainability_score, send a partial update to my Algolia index 'products' adding the sustainability_score field without touching any other fields. Report how many records were updated successfully.

SheetXAI reads the 2,000 rows, batches the partial update requests, and submits them to Algolia. It reports the count on completion.

What You Get

2,000 Algolia records enriched with the new field:

• Only sustainability_score is written — no other fields are touched
• Batched automatically — SheetXAI handles chunking so you never hit API limits
• Completion count — written back to confirm 2,000 of 2,000 updated

The nightly price update job runs unaffected. Partial updates are additive.

What If the Data Is Not Quite Ready

Enrichment workbooks come from different sources and are rarely uniform.

When the objectID column had leading zeros stripped by Excel

Someone opened the mapping file and the objectIDs starting with "0" lost the leading zero.

Before updating, check column A of the Badges tab for any objectID shorter than 8 characters and pad it with leading zeros back to 8 digits. Then send partial updates to my Algolia index 'products' adding the sustainability_score field.

When scores are on a 1-to-100 scale but Algolia expects 1 to 5

Your supplier used a different scale than the Algolia display layer expects.

Read column B of the Badges tab as a raw score from 1 to 100. Convert it to a 1-to-5 scale by dividing by 20 and rounding to the nearest integer. Write the converted score to column C, then send partial updates to my Algolia index 'products' using the converted value as sustainability_score.

When only records scoring 3 or above should get the badge field

Products below 3 should not show the sustainability badge in search results.

Read the Badges tab. For rows where sustainability_score is 3 or higher, send a partial update to my Algolia index 'products' adding the sustainability_score field. For rows where the score is below 3, skip the update and write "Skipped" to column C.

When you need to add three new fields in one partial update pass

The initiative also added certifications and eco_packaging. All three should land in a single update per record.

For each row in the Enrichment tab with columns objectID, sustainability_score, certifications, and eco_packaging, send a single partial update to my Algolia index 'products' adding all three fields simultaneously. Do not touch existing fields. Report the final count.

The pattern: the workbook is the source, Algolia is the destination, SheetXAI handles the API translation and the batching.

Try It

Get the 7-day free trial of SheetXAI and open your enrichment mapping workbook, then ask it to send partial updates to your Algolia index. The Algolia integration is included in every SheetXAI plan. For related workflows, see how to bulk import a full catalog from Excel or the Algolia in Excel overview.