Sending call data from Retell AI into Google Sheets or Airtable
I am getting super frustrated and feel like I'm missing something simple. I'm working with a business that wants an inbound agent who can answer questions and take messages and then send them on to a spreadsheet they can review later. It doesn't matter if it's google sheets or Airtable or whatever. I just need it to work. 1. I'm having issues with the n8n webhook not triggering when the Retell agent receives a call. It will get the call data when I run it as a test, but when I switch to the production link nothing happens. I've tried it with a chat trigger and it works perfectly. It gets the data, parses it, and sends it on to the correct fields 2. Even when I get the webhook test data, there's a problem with the simple memory. It says there is no sessionId coming in from the Retell webhook and I can't find a sessionId. I'm new to n8n so I have no idea what I'm doing wrong. I've spent days working on this and watched hours of tutorials. If n8n isn't the solution, I need to know what is. I gave up on n8n last night and started trying Zapier. It is receiving the call data from the webhook, but it's not parsing out the categories like Name, Phone Number, etc. and sending them on to the correct fields in my spreadsheets. It would be great if it would message them via Telegram, WhatsApp, or something else to notify them know there's a new call to review, but at this point, I don't even care about that. Any help would be really appreciated. I'm drowning here.