n8n

How to Capture Sheets Airtable Notion Call Analytics?

Record analyzed phone call results into Google Sheets, Airtable, and Notion without manual data entry. Built for teams running voice agents who need clear transcripts, summaries, and costs stored in structured tools for reviews and reporting.

An incoming POST webhook receives a call analysis event. A filter keeps only the analyzed event type so you avoid partial data. A mapping step then prepares clean fields like call ID, start and end time, duration, transcript, summary, sentiment, phone number, and total cost. It converts cost from cents to dollars and formats timestamps to readable dates. The data is then written in parallel to Airtable as a new record, appended to a Google Sheet, and saved as a Notion database page with mapped properties and a title using the call summary.

To set this up, connect the webhook from your voice platform to the n8n URL and link your Google, Airtable, and Notion accounts. Match your table, sheet, and database columns to the mapped fields. Expect faster QA and reporting, consistent records across apps, and less manual work. Common uses include sales call reviews, support quality checks, and operations audit trails.

What are the key features?

  • Webhook trigger receives analyzed call events via POST.
  • Filter keeps only the analyzed event type to avoid partial data.
  • Field mapping prepares call ID, times, duration, transcript, summary, sentiment, and phone number.
  • Automatic conversions for cost to dollars and timestamps to ISO date strings.
  • Create a new Airtable record with mapped columns.
  • Append a new row in Google Sheets with useAppend enabled.
  • Create a Notion database page with a title from the call summary and typed properties.
  • Send to one or many destinations by enabling or disabling outputs.

What are the benefits?

  • Reduce manual logging from 15 minutes per call to under 1 minute
  • Automate up to 100% of call record entry across three systems
  • Improve data accuracy by removing copy paste errors
  • Unify transcripts, summaries, and costs in one consistent format
  • Support higher call volume without adding admin work

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets, Airtable, Notion and Retell. See the Tools Required section above for links to create accounts with these services.
  3. Open the Webhook node and copy the Production URL. In your voice platform settings, paste this URL into the agent webhook field for call analysis events and set the method to POST.
  4. In the Filter node, confirm the condition matches the analyzed event type so only complete call data passes through.
  5. Open the Set node and review field mappings. Keep call ID, start and end time, duration, transcript, summary, sentiment, phone number, and cost. Leave the cost and date conversions enabled.
  6. For Airtable: double click the Airtable node, then on the 'Credential to connect with' dropdown, click 'Create new credential' and follow the on screen instructions. Use a personal access token from your Airtable account. Select your base and the Transcripts table, then confirm each column mapping.
  7. For Google Sheets: open the Google Sheets node, create a new OAuth2 credential, and allow access to your account. Pick the target spreadsheet and the Transcripts sheet. Keep Append mode on.
  8. For Notion: open the Notion node, create a new credential, and choose your Notion integration. Share the database with the integration in Notion. Select the database and check each property type matches the mapped fields.
  9. Run a live test by triggering a sample call. After the analysis event is delivered, check Airtable, Google Sheets, and Notion for the new record.
  10. If records do not appear, verify the webhook URL in your voice platform, confirm the event type matches the Filter, and check that your database columns and property types exist and are spelled the same.
  11. Disable any output you do not use by turning off the Airtable, Google Sheets, or Notion nodes to simplify maintenance.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Notion

Sign up

Free plan: $0 per member / mo (Public API included)

Retell

Sign up

Pay-as-you-go: $0 / mo, $0.07+/minute for AI Voice Agents; $10 free credits; API access via REST/SDK

Credits:
Agent Studio

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.