The Scenario
An editor spent the better part of last week moderating 40 submitted Endorsal testimonials. She read every one, edited the text for clarity and brand tone, and made approval decisions — approved, rejected, pending — based on the content. All of it is now in an Excel workbook: column A holds the testimonial ID, column B holds the revised text, column C holds the new approval status.
The problem: none of it is in Endorsal yet.
The handoff from the submission queue to the moderated state means pushing every row back into Endorsal with the updated text and status. Forty rows. Three fields each. All of it sitting in the workbook, waiting.
The bad version:
- Open Endorsal, search for the first testimonial ID, click into the record, paste the revised text from the workbook, set the approval status from the workbook, save
- Repeat for testimonial two, three, four — scrolling back to the workbook for each one to make sure you have the right ID and the right text
- Make an error on row 12 where you paste the text from row 11 into the wrong record because you've been doing this for 45 minutes and the IDs are starting to blur
The moderation work is done. This is the last step before the testimonials go live. It should not take three hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the moderation table and through its built-in Endorsal integration updates each testimonial record with the revised text and status — without you opening a single Endorsal form.
Read my Excel moderation table and update each Endorsal testimonial record's content and approval status using the testimonial ID in column A as the key — column B has the updated text, column C has the new status. Write the result to column D.
SheetXAI reads every row, updates the corresponding Endorsal testimonial, and writes a result status back to column D so you can see at a glance if anything failed.
What You Get
- Every row in the moderation workbook pushed back to Endorsal with updated text and approval status
- Column D written with "updated" for successful rows and the error message for any that failed
- No silent failures — every record is accounted for
- The original data in columns A through C left untouched so you can re-run failed rows if needed
What If the Data Is Not Quite Ready
Some rows are missing the testimonial ID (not yet submitted to Endorsal)
For each row in the moderation table, if column A is blank, skip the row and write "NO ID" to column D. For rows with an ID, update the Endorsal testimonial with the text in column B and status in column C, then write the result to column D.
Approval status is in longform ("Approved," "Rejected") but Endorsal expects lowercase
For each row in the moderation table, convert the value in column C to lowercase, then update the corresponding Endorsal testimonial — ID in column A — with the revised text in column B and the normalized status. Write the result to column D.
You need to update only approved testimonials and leave pending ones untouched
For each row in the moderation table where column C is "approved," update the Endorsal testimonial with the ID in column A using the text in column B. Skip rows where column C is not "approved" and write "SKIPPED" to column D for those rows.
Validate text length, normalize status, push updates, and pull back the final record to confirm
For each row in the moderation table: check that column B text is at least 40 characters (flag "TOO SHORT" in column E if not), normalize column C to lowercase, then for rows that pass the length check, update the Endorsal testimonial with the ID in column A. After updating, fetch the current state of the record from Endorsal and write the live approval status to column F to confirm the change went through.
One prompt covers validation, normalization, the update, and the confirmation — rather than four separate manual steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook holding your moderation table, then ask it to push all the updates back into Endorsal at once. Also see how to bulk import testimonials into Endorsal or return to the Endorsal integration overview.