Recipe · Google Sheets

Every new testimonial to a Google Sheet

Automatically save each testimonial that lands in Testivora as a row in a spreadsheet. Great for reporting, backup, or letting your team review without opening the admin.

Read time · ~4 min

How it works

Testivora fires the testimonial.created event when a testimonial comes in. Your connector (n8n, Zapier or Make) catches it and appends a row to your Google Sheet with the mapped data.

Prepare the sheet with its columns

Create a new Google Sheet (or use an existing one) and put these headers in the first row. The order doesn't matter for the automation, but clear columns make mapping easier:

text

Fecha | Nombre | Empresa | Rating | Testimonio | Estado

These six columns cover the essentials of a testimonial. Add more later if you want.

Catch testimonial.created in your connector

In your connector (n8n, Zapier or Make) create a new flow that starts with a webhook. Copy that URL and register it in Testivora: Settings → Webhooks → New endpoint, paste the URL and pick the testimonial.created event. Per-connector guides at /docs/automate.

Append a row to your Google Sheet

Connect your Google account and add the 'Append Row' action pointing at your sheet. Map each event field to its column. The testimonial lives under data:

text

created_at          → Fecha
data.author.name    → Nombre
data.author.company → Empresa
data.rating         → Rating
data.text           → Testimonio
data.status         → Estado

data.author.company can be empty and data.rating can be null for video testimonials; your sheet just leaves those cells blank.

Test with 'Send test'

From Testivora hit 'Send test' on your endpoint. Your connector receives the event and a new row should appear in the sheet. If it all lines up, keep the flow active — every real testimonial will save itself from now on.

Bring in what you already have

The webhook only captures new testimonials from now on. To dump the ones already in your account in one shot, use the REST API: GET /v1/testimonials?space_id=… returns the list. Details at /docs/api.

http

# Volcado inicial de los testimonios que ya tienes
GET https://api.testivora.com/v1/testimonials?space_id=spc_123
Authorization: Bearer tv_live_...

Webhooks and API require the Growth or Agency plan. Your API key (tv_live_…) is created in Settings → API.