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 a Google Sheet: 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 sheet, waiting.
The bad version:
- Open Endorsal, search for the first testimonial ID, click into the record, paste the revised text from the sheet, set the approval status from the sheet, save
- Repeat for testimonial two, three, four — scrolling back to the sheet 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 Google Sheet. 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.
For each row in the "Moderation" tab, update the Endorsal testimonial with the ID in column A — set the testimonial text to the content in column B and the approval status to the value in column C. Write "updated" or the error message 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 sheet 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 "Moderation," 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 "Moderation," 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 "Moderation" 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 "Moderation": 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 Google Sheet 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.