The Scenario
The website redesign project kicked off Monday. The content strategist is on it — she owns the testimonial selection for three new pages and a homepage refresh. The brief says to pull the best quotes from Endorsal, annotate them with ratings, and surface the strongest ones for each page section.
She has never touched Endorsal's backend. She was handed a login, poked around, found the testimonials list, and then realized there's no easy way to get all of them out in a format she can actually work with. The testimonials are paginated. There are over 90 of them.
The bad version:
- Page through Endorsal's testimonials UI, reading each one and manually copying author name, company, rating, and text into an Excel workbook
- Lose count of which page you're on and re-copy three testimonials you already have
- End up with 85 of the 92 testimonials because you couldn't tell which ones you'd missed
The redesign review is in four days. This is supposed to take an afternoon, not a week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Endorsal, fetches the full testimonial library, and writes the results into the workbook — without requiring access to any export UI.
Export all my Endorsal testimonials into my Excel sheet with columns for author name, email, company, rating, and testimonial body for content selection, starting at row 2 with headers in row 1.
Every testimonial lands in the workbook with full metadata — ready for sorting, filtering, and annotation without any manual copying.
What You Get
- Every Endorsal testimonial written to the worksheet in one pass
- Columns for author name, email, company, rating, and full testimonial body
- Headers in row 1 for immediate readability
- Row count at the end confirming all records were returned
What If the Data Is Not Quite Ready
You only want approved testimonials
Fetch all approved testimonials from Endorsal and write each one's author name, company, rating, and text into the "Approved" worksheet starting at row 2.
You want to sort by rating as you pull
Fetch all Endorsal testimonials, sort them by rating descending, and write author name, company, rating, and text into the testimonials worksheet with the highest-rated entries at the top.
You need testimonials joined with contact metadata from a second worksheet
Fetch all Endorsal testimonials and write them to columns A through E of the "Testimonials" worksheet. Then look up each author email in the "Contacts" worksheet (column A = email, column B = plan tier) and write the matching tier to column F.
Pull the full library, flag short testimonials, and mark the top 10 for the homepage
Fetch all Endorsal testimonials, write all fields to the "Raw" worksheet, then in column F flag any testimonial where the text is shorter than 80 characters as "TOO SHORT." Sort by rating descending and mark the top 10 longest entries with "HOMEPAGE PICK" in column G.
One pass to get the data out, annotate it, and flag the best candidates — rather than exporting, filtering in a separate tool, and reformatting the output manually.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull your full Endorsal testimonial library into the workbook. See also how to filter Endorsal testimonials by rating or status or go back to the Endorsal integration overview.