Custom Dashboards in Retell Ai

// Replace with your Retell API key

const RETELL_API_KEY = ‘Your private Key Here’;

const SHEET_NAME = ‘Sheet1’;  // Change to your sheet name if different

// Pre-defined product prices per second (Updated)

const predefinedPrices = {

  “elevenlabs_tts”: 0.07 / 60,  // Price per second

  “openai_deepgram_tts”: 0.08 / 60,  // Price per second

  “gpt_4o_mini”: 0.006 / 60,  // Price per second

  “gpt_4o”: 0.05 / 60,  // Price per second

  “claude_3_haiku”: 0.012 / 60,  // Price per second

  “claude_3_5_sonnet”: 0.06 / 60,  // Price per second

  “retell_platform”: 0.01 / 60  // Updated price for retell_platform, per second

};

function fetchRetellCallData() {

  // Set up the Retell API request

  const url = ‘https://api.retellai.com/v2/list-calls’;

  const options = {

    method: ‘post’,

    headers: {

      ‘Authorization’: `Bearer ${RETELL_API_KEY}`,

      ‘Content-Type’: ‘application/json’

    },

    muteHttpExceptions: true,

    payload: JSON.stringify({ limit: 100 })

  };

  // Call the Retell API

  const response = UrlFetchApp.fetch(url, options);

  const data = JSON.parse(response.getContentText());

  // Reference to the Google Sheet

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME);

  // Clear the sheet and set headers

  sheet.clear();

  sheet.appendRow([

    “TotalCost”, “CallID”, “AgentID”, “CallStatus”, “StartTimestamp”, “EndTimestamp”,

    “Transcript”, “RecordingURL”, “UserSentiment”, “CallSuccessful”, “CallSummary”,

    “ProductsUsed”, “DurationSeconds”, “DisconnectionReason”, “name”, “appointment”, “age”, // For custom analysis data

  ]);

  // Iterate through each call entry and add it to the sheet

  data.forEach(call => {

    // Initialize default values

    let dynamicColumns = [];

    let finalPrice = 0;

    const productsUsed = [];

    const durationSeconds = call.call_cost?.total_duration_seconds || 0;

    let callId = call.call_id || ‘-‘;

    let agentId = call.agent_id || ‘-‘;

    let callStatus = call.call_status || ‘-‘;

    let startTimestamp = call.start_timestamp ? new Date(call.start_timestamp).toLocaleString() : ‘-‘;

    let endTimestamp = call.end_timestamp ? new Date(call.end_timestamp).toLocaleString() : ‘-‘;

    let transcript = call.transcript || ‘-‘;

    let recordingUrl = call.recording_url || ‘-‘;

    let userSentiment = call.call_analysis?.user_sentiment || ‘-‘;

    // Modify this logic to handle true, false, or empty values for CallSuccessful

    let callSuccessful = ‘-‘;

    if (call.call_analysis?.call_successful === true) {

      callSuccessful = ‘true’;

    } else if (call.call_analysis?.call_successful === false) {

      callSuccessful = ‘false’;

    }

    let callSummary = call.call_analysis?.call_summary || ‘-‘;

    let disconnectionReason = call.disconnection_reason || ‘-‘;

    // Handle dynamic custom analysis data

    const customAnalysisData = call.call_analysis?.custom_analysis_data || {};

    let customDataColumns = [];

    for (const key in customAnalysisData) {

      if (customAnalysisData.hasOwnProperty(key)) {

        // Only add the value of each key (not the key itself)

        customDataColumns.push(customAnalysisData[key]);

      }

    }

    // Calculate the final price based on predefined prices per second

    for (const [product, pricePerSecond] of Object.entries(predefinedPrices)) {

      const isProductUsed = call.call_cost?.product_costs?.some(cost => cost.product === product);

      if (isProductUsed) {

        productsUsed.push(product);

        finalPrice += pricePerSecond * durationSeconds; // Multiply by seconds

      }

    }

    // Round the final price to 4 decimal places

    finalPrice = finalPrice > 0 ? finalPrice.toFixed(4) : ‘-‘;

    // Append the row to the sheet, ensuring placeholders for missing or invalid data

    sheet.appendRow([

      `$${finalPrice}`,  // Total Cost in first column

      callId,

      agentId,

      callStatus,

      startTimestamp,

      endTimestamp,

      transcript,

      recordingUrl,

      userSentiment,

      callSuccessful,  // Now this will be ‘true’, ‘false’, or ‘-‘

      callSummary,

      productsUsed.join(“, “),

      durationSeconds > 0 ? durationSeconds : ‘-‘,  // Duration in seconds

      disconnectionReason,

      …customDataColumns // Add the custom data as additional columns (only values)

    ]);

  });

}

// Create a trigger that runs the fetchRetellCallData function every 5 minutes

function createTimeDrivenTrigger() {

  // This will create a time-driven trigger to run the fetchRetellCallData function every 30 minutes

  ScriptApp.newTrigger(‘fetchRetellCallData’)

    .timeBased()

    .everyMinutes(30)

    .create();

}