How to Send Voiceflow Chat Data to a Spreadsheet With an API Step

Voiceflow's API block lets your bot call any HTTP endpoint mid-conversation. Pair it with a webhook from Zapier or Make and you can log every captured lead to a Google Sheet, CRM, or database without writing a backend. This guide wires capture to a POST request.

What you need

• A Voiceflow agent on the canvas
• A Zapier or Make account to create a Catch Hook / webhook trigger
• A Google Sheet (or any destination) connected to that automation

Step 1: Create the webhook in Zapier

In Zapier create a Zap with the Webhooks by Zapier trigger set to Catch Hook. Copy the unique URL it gives you. The second action sends a row to Google Sheets, mapping fields from the incoming payload.

Step 2: Capture the data in Voiceflow

On the canvas add a Capture block to store the user's email into {email}, and another to store their question into {topic}.

Step 3: Configure the API block

Drag in an API block. Set the method to POST, paste the Zapier URL, add a Content-Type header, and put your variables in the JSON body. Voiceflow substitutes the variable values at run time.

{
  "email": "{email}",
  "topic": "{topic}",
  "source": "voiceflow-web-agent"
}

Step 4: Run the flow end to end

Open the tester, complete the capture steps, and let the API block fire. Switch to your Google Sheet and confirm a new row appeared with the email and topic. If not, check the Zapier task history for the failed run.

Result

Your bot now writes every captured conversation to a spreadsheet in real time. Because the API block is generic, you can repoint the URL at any endpoint later, a CRM, your own server, or a Make scenario, without touching the rest of the flow.