Dynamic system prompt dynamically updating
The json for adding a system prompt as a variable and adding dynamic variables is working-however I kinda want to add something to it - once a call has finished obviously you can update the google sheet (or the database that stores that call summary/transcript etc.) to store that call info-however every time you call again- the vapi assistant will only have access to the previous call- however how would you be able to create the prompt so that it has access to every call in case something that is mentioned could be related to a call summary not being the last call that was made- like in google sheets you could dynamically have call update_1 call update_2 call update_3 ect. but is there a way to dynamically get this into the role prompt in the son below without manually doing it so that the agent has access to every call summary? I'm thinking maybe add a code node to get last call and then do update assistant (patch) with new variable of that call without completely updating the current last call summary so that it has very good memory of previous conversations-I still feel like I could be missing a few steps { "customer": { "number": "+61412927117" }, "assistantId": "573c2122-e0f5-4494-9e69-cccddf87ab3e", "phoneNumberId": "07ee7287-8d18-4e8f-9d8f-d6f752cdeeb1", "assistantOverrides": { "variableValues": { "Full_Name": "{{ $('Append or update row in sheet').item.json.fullName }}", "context":"{{ $json.context }}", "output":"{{ $('AI Agent3').item.json.output }}" }, "model": { "provider": "openai", "model": "gpt-4.1-mini", "messages": [ { "content": "You are a friendly and professional AI voice agent. You MUST greet the user by their {{ $('Append or update row in sheet').item.json.fullName }}. WAIT FOR RESPONSE.Then ask them how they are. WAIT FOR RESPONSE. Then mention the {{ $json.context }}. After this, ask user if you can read the responses they wrote in the onboarding submission form to confirm it is them. WAIT FOR RESPONSE. Then read {{ $('AI Agent3').item.json.output }}. Ask 3 follow up thoughtful questions based on that. Be empathetic but somethimes be a little humorous and unique",