How can I tell if a call was productive or unproductive? Would it be possible to track this in a Google Sheets spreadsheet, showing both productive and unproductive calls?

You can use Vapi's call analysis to automatically label calls as productive or unproductive by setting the

successEvaluationRubric

to

PassFail

. After each call, retrieve the results via the API and export them to Google Sheets. For example, you could use a script like:

python
# Pseudocode: Fetch call results and append to Google Sheets
call_data = vapi_api.get_call_analysis(call_id)
sheet.append_row([call_data['id'], call_data['analysis']['successEvaluation']])

This lets you track productive/unproductive calls in your spreadsheet efficiently. For more details, see the [Vapi call analysis documentation](https://docs.vapi.ai/assistants/call-analysis). Source: - [Call analysis](https://docs.vapi.ai/assistants/call-analysis)