The goal is to create form for leads intake onto google sheets, from which the data is read and call is forwarded to the particular lead through elevenlabs agent. And then using post call transcription analyze and categorize them automatically for the developer even an option for doing it manually.
1st flow:
on form submission, data intake
then normalize the phone number
check for duplicates in that sheet, and else accordingly append onto the sheet.
2nd flow:
read the sheet, then call elevenlabs
analyze the post call and automatically cut the call and the callback logic as well on the agent in elevenlabs
integrate gmail and whatsapp for notification for followup after call for scheduling a booking on calendly
after booking on calendly, an status of booking done should be visible on google sheets.
for call- if sudden call is cut then a followup call should be done after 1 hour and 24 hours.
main idea to keep in mind is the unique id for both
drop a Crypto node right after your form trigger to generate a random UUID. append that UUID straight into your google sheet along with the normalized phone number.
when the second flow runs the elevenlabs call, pass that UUID into the api request as custom metadata. elevenlabs will send it back in the post-call webhook. then you just use a Google Sheets node to find that ID and update the exact row with the transcription.
for the dropped calls, don’t overcomplicate the sheet with retry statuses. just route your post-call webhook through an IF node. if the call dropped early, send it right into an n8n Wait node set for 1 hour, then fire the call api again.
just make calendly a completely separate third workflow. use the standard calendly trigger node. grab the phone number from the new booking, look it up in your sheet, and flip the status.
Hi @Anshul_Namdev Thanks for welcome, I’ve build this flow but i had faced problems in -
generating unique id for record ( thanks to @A_A4 i got it!)
Cleaning the data of phone number, errors like runtime error of 60 seconds keeps on happening
I have no clue on how to use wati for whatsapp ( no need of alternate trying to use wati ). I have no idea on how to use wati even after youtube videos.
Hope everything makes sense. Im very new to this field, sorry for asking lots of questions…
For the 60 second timeout on phone number cleaning you’re probably doing too much in a single Code node or hitting an external API that’s slow, try breaking it into smaller steps or bumping up the node timeout in the node settings. For WATI specifically their API is pretty straightforward, you just need an HTTP Request node pointed at https://live-mt-server.wati.io/api/v1/sendTemplateMessage with your API key as a header and the template name + phone number in the body, their docs have the exact payload format.