Skip to main content
Integrations

How to save post-call data Google Sheets & Webhook

How to configure automatic saving of call data

Written By Product

Last updated 4 months ago

How it works

After each call (inbound or outbound), the agent can automatically save the collected data to Google Sheets. The configuration can be found in Step 3: Agent Post-Call Actions. Integrations with Webhook and N8N are also available for advanced needs.

Integration

What it saves

Where

Google Sheets

Structured data (name, phone number, outcome, custom fields)

Google Sheets sheet

Webhook

Full JSON + audio (optional)

Your endpoint/server

N8N

Data for automations

N8N workflow

Summary of positions on the platform:

What

Where

Google Sheets configuration

Agent → Step 3: Post-Call Actions

Webhook / N8N (optional)

Agent → Step 3: Post-Call Actions

Custom fields to save

Agent → Step 2: In-Call Actions → Custom Data Collection

Data collection instructions

Agent → Step 5: Instructions

Deploy

Agent → Step 6: Test & Deploy

Complete configuration flow

PART 1 – Prepare Google Sheets

▼

Create dedicated sheet + headers

▼

PART 2 – Define Fields to Collect

▼

Step 2: In-Call Actions → Custom Data Collection

▼

PART 2B – Configure the Collection Prompt

▼

Step 5: Instructions → Data collection instructions

▼

PART 3 – Configure Google Sheets (+ Webhook)

▼

Step 3: Post-Call Actions → Google Sheets Wizard

▼

PART 4 – Deploy and Test

▼

Step 6: Deploy + test call ✅

PART 1: Prepare Google Sheets

First, create the sheet where the call data will be saved.

Step 1.1 - Create a dedicated sheet

  • Go to sheets.google.com

  • Click "+ New" → "Google Sheet"

  • Rename the sheet (e.g., "DeepAgent calls")

  • Create the headers in the first row

📲 For OUTBOUND agents (recommended, but not mandatory):

phone_number

customer_name

call_outcome

call_duration

notes

timestamp

📞 For INBOUND agents:

caller_number

caller_name

request_type

resolution

agent_notes

timestamp

💡 Tip: Missing columns will be added automatically, but creating headers in advance allows you to organize your data better.

Step 1.2 - Check permissions

  • Make sure you have edit permissions on the sheet

  • If the sheet is in a shared Drive, verify that you can write to it

PART 2: Configure the Fields to Collect (Step 2)

Before setting up saving, define what data you want to collect during the call.

Step 2.1 - Go to Step 2: In-Call Actions

  • Open the agent in Agent Builder

  • Go to Step 2: In-Call Actions

Step 2.2 - Configure Custom Data Collection

Scroll down to the "Custom Data Collection" section and add the fields you want to collect:

Field

Description

Example

customer_name

Customer name

"John Smith"

email

Customer email

"mario@example.com"

interest_level

Interest level

"High," "Medium," "Low"

appointment_date

Appointment date

"2024-02-15"

notes

Additional notes

"Call him back next week"

💡 Tip: The fields defined here will be available for mapping to Google Sheets in the next step.

PART 2B: Configure the Data Collection Prompt (Step 5)

The custom fields defined in Step 2 indicate what data to save, but the agent needs to know how to collect it during the conversation. To do this, you need to add instructions to the prompt.

Which data requires instructions in the prompt?

Data type

Needed in the prompt?

Why

phone_number, call_duration, transcript, timestamp

No

Automatically collected by the system

customer_name, email, interest_level, notes, etc.

Yes

The agent must ask the customer for this information

Step 2B.1 - Go to Step 5: Instructions

  • Open the agent in Agent Builder

  • Go to Step 5: Instructions

Step 2B.2 - Add instructions for data collection

Add a dedicated section in the agent prompt. Choose the template that suits your agent type:

📲 For OUTBOUND agents:

## Data Collection

During the conversation, ALWAYS collect the following information:

- Customer's full name

- Email (if available)

- Level of interest: High, Medium, or Low

- Important notes about the conversation

Ask for this information in a natural way, without sounding like you are conducting a survey.

a questionnaire.

Example: "Who do I have the pleasure of speaking with?"

instead of "Can you tell me your name?"

📞 For INBOUND agents:

## Data Collection

During the conversation, collect the following information:

- Caller's name

- Reason for the call

- Email or alternate number (if needed for follow-up)

- Details of the request

Only ask for information when it is relevant

to the conversation.

Step 2B.3 - Examples of natural questions

The agent should ask for information in a conversational manner, not like a form to be filled out:

Field to collect

Avoid

Prefer

Name

"Tell me your first and last name"

"Who am I speaking to?"

Email

"Please provide me with your email address"

"Which email address can I send the information to?"

Interest

"How interested are you?"

"How interested are you in learning more about this solution?"

💡 Tip: The agent will collect the data automatically during the conversation. The customer does not need to "fill out a form"—the information is extracted from the natural dialogue.

PART 3: Configure Google Sheets (Step 3)

Step 3.1 - Go to Step 3: Post-Call Actions

  • Continue with agent setup

  • Go to Step 3: Post-Call Actions

Step 3.2 - Open the Google Sheets wizard

  • In the "Google Sheets" section, click "+ Configure."

  • The multi-step configuration wizard will open

Step 3.3 - Connect your Google Account (Wizard Step 1)

  • Click "Sign in with Google"

  • Authorize access to Google Sheets

  • Grant all requested permissions

Step 3.4 - Select the Workspace (Wizard Step 2)

  • Choose where the sheet is located:

    • My Drive – Your personal Google Drive

    • Shared Drive – Shared team drives

Step 3.5 - Select the Sheet (Wizard Step 3)

  • Search for and select the sheet you created in Part 1 (e.g., "DeepAgent Calls")

  • You can also paste the spreadsheet URL directly

💡 Tip: If you can't find the sheet in the list, you can paste the URL or ID of the Google Sheets sheet directly into the search field.

Step 3.6 - Select the Tab (Wizard Step 4)

  • Select the specific tab (sheet)

  • By default, the first tab ("Sheet1") is used

Step 3.7 - Configure Field Mapping (Wizard Step 5)

Map the fields of the call to the columns of the sheet:

DeepAgent Field

→

Google Sheets column

phone_number

→

A (phone_number)

customer_name

→

B (customer_name)

call_outcome

→

C (call_outcome)

call_duration

→

D (call_duration)

transcript

→

E (transcript)

timestamp

→

F (timestamp)

Default available fields:

  • phone_number – Number called/caller

  • call_duration – Duration in seconds

  • call_outcome – Outcome (answered, voicemail, no_answer, etc.)

  • transcript – Full transcript

  • summary – Summary of the call

  • timestamp – Date/time of the call

  • All custom fields defined in Step 2

Step 3.8 - Choose the Conflict Strategy (Wizard Step 6)

Choose how to handle duplicate rows:

📲 For OUTBOUND agents (recommended):

  • ✅ Update existing – If the number already exists, update the row

    • Ideal for outbound: each contact has a single row, always up to date

📞 For INBOUND agents (recommended):

  • ✅ Always add – Each call creates a new row

    • Ideal for inbound: keep a history of all calls

Step 3.9 - Complete the configuration

  • Click "Complete"

  • Check that the configuration is visible in the Google Sheets section

Webhook and N8N (Optional)

In addition to Google Sheets, in Step 3: Post-Call Actions, you can also activate:

  • Webhook – Send call data (in JSON format) to your server or external service. You can also include the audio recording.

  • N8N – Connect call data to an N8N workflow for advanced automation.

ℹ️ Note: To configure Webhook or N8N, contact the DeepAgent team, who will guide you through the technical configuration.

PART 4: Deploy and Test

Step 4.1 - Save and Deploy

  • Go to Step 6: Test & Deploy

  • Click "Save" to save all changes

  • Click "Deploy" to publish the changes

  • Wait for the "Deploy successful" confirmation

Step 4.2 - Make a test call

  • Make a test call

  • Complete the conversation

  • Wait a few seconds after the call ends

Step 4.3 - Check Google Sheets

  • Open the Google Sheets document

  • Check that a new row has been added

  • Verify that all fields are populated correctly

PART 5: Frequently Asked Questions and Solutions

If you encounter any of the situations below, follow the solution indicated:

Situation

Cause

What to do

Data is not saved

Google connection expired

Reconfigure Google Sheets in Step 3

Some fields are missing

Mapping not configured

Check the mapping in Step 5 of the wizard

Duplicate rows

"Always add" strategy active

Change to "Update existing" for outbound

Insufficient permissions

Unauthorized Google account

Reconnect Google account

Custom fields not visible

Not defined in Step 2

Add fields in Custom Data Collection

Custom fields are empty

Agent does not ask for information

Add instructions in the prompt (Step 5) – see PART 2B

Final Checklist

Before considering the configuration complete, verify that you have completed all of these steps:

Requirement

Where

Done

Google Sheets sheet created

Google Sheets

☐

Headers created (optional)

Google Sheets

☐

Custom fields defined

Agent → Step 2

☐

Data collection instructions in the prompt

Agent → Step 5

☐

Google Sheets configured

Agent → Step 3

☐

Google account connected

Wizard Step 1

☐

Sheet selected

Wizard Step 3-4

☐

Field mapping completed

Wizard Step 5

☐

Conflict strategy chosen

Wizard Step 6

☐

Deployment completed

Agent → Step 6

☐

Call test performed

Test call

☐

Data visible in Google Sheets

Google Sheets

☐