Retell Inbound Call Dynamic Variables from Google Sheets
detail.loadingPreview
Use n8n to fetch user data from Google Sheets and populate dynamic variables for Retell AI voice agents.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow allows you to dynamically populate variables for your Retell AI voice agents by fetching data from a Google Sheet. When Retell receives an inbound call, this workflow is triggered, looks up the caller's phone number in your specified Google Sheet, and returns relevant user information (like first name, last name, and email) to be used as dynamic variables within your Retell agent's prompts.
Key Features
- Automatically fetch user data from a Google Sheet based on the incoming caller's phone number.
- Populate Retell AI dynamic variables with fetched user information.
- Handles inbound webhook calls from Retell.
- Customizable Google Sheet configuration and response mapping.
How To Use
- Set up Retell AI: Ensure you have a Retell AI account, an agent created, and a phone number purchased and associated with your agent.
- Prepare Google Sheet: Create or copy a Google Sheet with at least a 'Phone Number' column. Other columns will be used for your dynamic variables (e.g., 'First Name', 'Last Name', 'E-Mail'). Ensure phone numbers in the sheet start with '+' and are formatted consistently.
- Configure n8n Workflow:
- Webhook Node: Set the
path(e.g.,retell-dynamic-variables). Note the generated Webhook URL. - Google Sheets Node: Configure the
Document IDandSheet Nameto point to your prepared Google Sheet. Set thefiltersUIto match the caller's phone number ({{ $json.body.call_inbound.from_number }}) with your 'Phone Number' column. - Respond to Webhook Node: Map the fields from your Google Sheet query to the
dynamic_variablesin theresponseBody. Ensure the variable names here match what you expect in Retell.
- Webhook Node: Set the
- Connect Webhook URL: In your Retell AI phone number settings, enable 'Add an inbound webhook' and paste the n8n Webhook URL.
- Use Variables in Retell: In your Retell agent's prompts, use the
{{variable_name}}syntax to reference the dynamic variables you configured (e.g.,{{first_name}}).
Apps Used
Workflow JSON
{
"id": "bfc7a861-52e5-465b-8536-8fd224ed239e",
"name": "Retell Inbound Call Dynamic Variables from Google Sheets",
"nodes": 0,
"category": "Integrations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: bfc7a861-52e5...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Google Sheets Syncro Call Logger
Logs phone call details from a webhook into Google Sheets and optionally adds them to Syncro.
Slack to ClickUp Task Generator
Automatically create ClickUp tasks from Slack commands.
Mattermost Webhook To Get Drink Suggestions
Receives a webhook and sends a suggested drink from an API to Mattermost.
Syncro to Clockify Time Tracker
Automatically create Clockify time entries from Syncro.
Save Telegram Reply to Google Sheet Journal
Logs replies from a specific Telegram user to a Google Sheet as journal entries.
Send Slack Message From Webflow Form Submission
Dynamically creates Slack channels for Webflow forms and sends submissions to them.