The Scenario
The product team ran a post-onboarding survey through Typeform. Sixty responses came in over three weeks — written testimonials with author name, email, company, job title, numeric rating, and the full text of what they said. Typeform exported everything to a Google Sheet. The responses are sitting in rows 2 through 61, organized, ready to use.
The Endorsal library is empty. The testimonials aren't in there yet. A website redesign is waiting on them.
The bad version:
- Open Endorsal, go to Testimonials, click "Add testimonial," and manually paste the author name, company, rating, and text for the first entry from the sheet
- Repeat sixty times, reading across the row each time to make sure the right text lands in the right field
- Realize on entry 40 that you've been entering the company name in the job title field and need to go back through the ones you've already submitted
Nobody hired you to re-enter survey data that already exists in a structured format. The design team is waiting. The marketing team is waiting. And the sixty testimonials aren't getting any fresher sitting in a Typeform export.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the testimonial data directly and through its built-in Endorsal integration submits each one as a new testimonial record — no form fills, no row-by-row copying.
Create an Endorsal testimonial for each row in the "Testimonials" tab — columns are Author Name (A), Email (B), Company (C), Job Title (D), Rating (E), and Testimonial Text (F) — and write each returned testimonial ID to column G.
SheetXAI reads every row, submits the testimonial to Endorsal with all fields populated, and writes the new testimonial ID back to column G. When it finishes, all sixty entries exist in Endorsal exactly as they were captured in the survey.
What You Get
- A new Endorsal testimonial record for every row in the specified range
- Each returned testimonial ID written to column G
- Rating submitted as a numeric value matching Endorsal's 1–5 scale
- Any rows that fail (missing required field, invalid rating) flagged in a status column rather than silently skipped
What If the Data Is Not Quite Ready
Rating is stored as text ("5 stars") instead of a number
For each row in "Testimonials," extract the numeric value from the Rating column (E) — where ratings may be formatted as "5 stars" or just "5" — then create an Endorsal testimonial using that numeric rating along with Author Name (A), Email (B), Company (C), and Testimonial Text (F). Write the testimonial ID to column G.
Some testimonials are too short to be useful
Create an Endorsal testimonial for each row in "Testimonials" where the text in column F is longer than 50 characters — skip rows with shorter text — and write the returned ID to column G. Mark skipped rows with "TOO SHORT" in column H.
You need to join author details from a second tab
Look up the Company and Job Title for each author email in column B against the "Contacts" tab (column A = email, column B = company, column C = job title), then create an Endorsal testimonial for each row in "Testimonials" using the full name (A), enriched company, enriched job title, rating (E), and text (F). Write the testimonial ID to column G.
Clean the testimonial text, set approval status, and submit all at once
For each row in "Testimonials," trim leading and trailing whitespace from the text in column F, set the approval status to "approved" for any row with a rating of 4 or 5 and "pending" for ratings below 4, then create the Endorsal testimonial and write the ID to column G and the approval status to column H.
One prompt, one pass — rather than cleaning the export first, then importing, then manually approving.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet holding your survey export, then ask it to push all the testimonials into Endorsal in one shot. You can also see how to export Endorsal testimonials back to a sheet or return to the Endorsal integration overview.