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. There's no CSV export she can find. 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 a Google Sheet
- 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 Google Sheet. It connects to Endorsal, fetches the full testimonial library, and writes the results into the sheet — without requiring access to any export UI.
Fetch all testimonials from Endorsal and write each one's author name, company, rating, text, and approval status into the "Testimonials" tab starting at row 2, with headers in row 1.
Every testimonial lands in the sheet with full metadata — ready for sorting, filtering, and annotation without any manual copying.
What You Get
- Every Endorsal testimonial written to the sheet in one pass
- Columns for author name, company, rating, testimonial text, and approval status
- Headers in row 1 so the data is immediately sortable and filterable
- Row count at the end confirming how many 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" tab 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" tab with the highest-rated testimonials at the top.
You need testimonials joined with contact details from a second tab
Fetch all Endorsal testimonials and write them to column A through E of the "Testimonials" tab. Then look up each author email in the "Contacts" tab (column A = email, column B = plan tier) and write the matching plan 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" tab, then in column G 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 H.
One pass to get the data out, annotate it, and flag the best candidates — rather than exporting, filtering in a separate tool, and copying results back.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull your full Endorsal testimonial library into the sheet. See also how to filter Endorsal testimonials by rating or status or go back to the Endorsal integration overview.