Zoho

ZOHO_CLIENT_ID=your_client_id
ZOHO_CLIENT_SECRET=your_client_secret
ZOHO_REFRESH_TOKEN=your_refresh_token
ZOHO_ORG_ID=your_org_id
ZOHO_MEETING_ORG_ID=your_meeting_org_id
ZOHO_CRM_DOMAIN=https://www.zohoapis.com
ZOHO_PROJECTS_DOMAIN=https://projectsapi.zoho.com/restapi
ZOHO_MEETING_DOMAIN=https://meeting.zoho.com
ZOHO_ACCOUNTS_URL=https://accounts.zoho.com

.env
.token_cache

#!/usr/bin/env bash
# zoho — CLI wrapper for Zoho CRM + Projects APIs
# Handles token refresh, caching, and common operations.
set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "$(readlink -f "${BASH_SOURCE[0]}")")" && pwd)"
SKILL_DIR="$(dirname "$SCRIPT_DIR")"
ENV_FILE="${SKILL_DIR}/.env"
TOKEN_CACHE="${SKILL_DIR}/.token_cache"

# ── Load env ──────────────────────────────────────────────────────────
if [[ -f "$ENV_FILE" ]]; then
  set -a; source "$ENV_FILE"; set +a
fi

ZOHO_CRM_DOMAIN="${ZOHO_CRM_DOMAIN:-https://www.zohoapis.com}"
ZOHO_PROJECTS_DOMAIN="${ZOHO_PROJECTS_DOMAIN:-https://projectsapi.zoho.com/restapi}"
ZOHO_MEETING_DOMAIN="${ZOHO_MEETING_DOMAIN:-https://meeting.zoho.com}"
ZOHO_MEETING_ORG_ID="${ZOHO_MEETING_ORG_ID:-}"
ZOHO_ACCOUNTS_URL="${ZOHO_ACCOUNTS_URL:-https://accounts.zoho.com}"

# ── Helpers ───────────────────────────────────────────────────────────
die()  { echo "ERROR: $*" >&2; exit 1; }
info() { echo ":: $*" >&2; }

check_creds() {
  [[ -n "${ZOHO_CLIENT_ID:-}" ]]     || die "ZOHO_CLIENT_ID not set"
  [[ -n "${ZOHO_CLIENT_SECRET:-}" ]] || die "ZOHO_CLIENT_SECRET not set"
  [[ -n "${ZOHO_REFRESH_TOKEN:-}" ]] || die "ZOHO_REFRESH_TOKEN not set"
}

# ── Token management ─────────────────────────────────────────────────
get_access_token() {
  # Check cache (tokens valid for ~55 min, we cache for 50)
  if [[ -f "$TOKEN_CACHE" ]]; then
    local cached_time cached_token
    cached_time=$(head -1 "$TOKEN_CACHE")
    cached_token=$(tail -1 "$TOKEN_CACHE")
    local now
    now=$(date +%s)
    local age=$(( now - cached_time ))
    if (( age < 3000 )); then
      echo "$cached_token"
      return
    fi
  fi

  check_creds

  local response
  response=$(curl -s -X POST "${ZOHO_ACCOUNTS_URL}/oauth/v2/token" \
    -d "refresh_token=${ZOHO_REFRESH_TOKEN}" \
    -d "client_id=${ZOHO_CLIENT_ID}" \
    -d "client_secret=${ZOHO_CLIENT_SECRET}" \
    -d "grant_type=refresh_token")

  local token
  token=$(echo "$response" | jq -r '.access_token // empty')
  [[ -n "$token" ]] || die "Token refresh failed: $response"

  # Cache it
  echo "$(date +%s)" > "$TOKEN_CACHE"
  echo "$token" >> "$TOKEN_CACHE"
  chmod 600 "$TOKEN_CACHE"

  echo "$token"
}

api() {
  local method="$1" url="$2"
  shift 2
  local token
  token=$(get_access_token)
  curl -s -X "$method" "$url" \
    -H "Authorization: Zoho-oauthtoken $token" \
    -H "Content-Type: application/json" \
    "$@"
}

api_form() {
  local method="$1" url="$2"
  shift 2
  local token
  token=$(get_access_token)
  curl -s -X "$method" "$url" \
    -H "Authorization: Zoho-oauthtoken $token" \
    -H "Content-Type: application/x-www-form-urlencoded" \
    "$@"
}

# ── CRM helpers ──────────────────────────────────────────────────────
crm_base="${ZOHO_CRM_DOMAIN}/crm/v7"

crm_list() {
  local module="$1"; shift
  local params=""
  [[ $# -gt 0 ]] && params="?$1"
  api GET "${crm_base}/${module}${params}"
}

crm_get() {
  local module="$1" id="$2"
  api GET "${crm_base}/${module}/${id}"
}

crm_search() {
  local module="$1" criteria="$2"
  api GET "${crm_base}/${module}/search?criteria=${criteria}"
}

crm_create() {
  local module="$1" json="$2"
  api POST "${crm_base}/${module}" -d "$json"
}

crm_update() {
  local module="$1" id="$2" json="$3"
  api PUT "${crm_base}/${module}/${id}" -d "$json"
}

crm_delete() {
  local module="$1" id="$2"
  api DELETE "${crm_base}/${module}/${id}"
}

# ── Projects helpers ─────────────────────────────────────────────────
proj_base() {
  [[ -n "${ZOHO_ORG_ID:-}" ]] || die "ZOHO_ORG_ID not set (needed for Projects)"
  echo "${ZOHO_PROJECTS_DOMAIN}/portal/${ZOHO_ORG_ID}"
}

proj_list_projects() {
  api GET "$(proj_base)/projects/"
}

proj_get_project() {
  local id="$1"
  api GET "$(proj_base)/projects/${id}/"
}

proj_list_tasks() {
  local project_id="$1"; shift
  local params=""
  [[ $# -gt 0 ]] && params="?$1"
  api GET "$(proj_base)/projects/${project_id}/tasks/${params}"
}

proj_create_task() {
  local project_id="$1" form_data="$2"
  api_form POST "$(proj_base)/projects/${project_id}/tasks/" -d "$form_data"
}

proj_update_task() {
  local project_id="$1" task_id="$2" form_data="$3"
  api_form POST "$(proj_base)/projects/${project_id}/tasks/${task_id}/" -d "$form_data"
}

proj_list_milestones() {
  local project_id="$1"
  api GET "$(proj_base)/projects/${project_id}/milestones/"
}

proj_list_tasklists() {
  local project_id="$1"
  api GET "$(proj_base)/projects/${project_id}/tasklists/"
}

proj_list_bugs() {
  local project_id="$1"
  api GET "$(proj_base)/projects/${project_id}/bugs/"
}

proj_list_timelogs() {
  local project_id="$1"
  api GET "$(proj_base)/projects/${project_id}/logs/"
}

# ── Meeting helpers ───────────────────────────────────────────────────
meeting_base() {
  [[ -n "${ZOHO_MEETING_ORG_ID:-}" ]] || die "ZOHO_MEETING_ORG_ID not set (needed for Meeting API)"
  echo "${ZOHO_MEETING_DOMAIN}/meeting/api/v2/${ZOHO_MEETING_ORG_ID}"
}

meeting_list_recordings() {
  api GET "$(meeting_base)/recordings.json"
}

meeting_download_recording() {
  local url="$1" output="${2:--}"
  local token
  token=$(get_access_token)
  if [[ "$output" == "-" ]]; then
    curl -s -L -H "Authorization: Zoho-oauthtoken $token" "$url"
  else
    curl -s -L -o "$output" -w "%{http_code}" -H "Authorization: Zoho-oauthtoken $token" "$url"
  fi
}

meeting_list_meetings() {
  local params=""
  [[ $# -gt 0 ]] && params="?$1"
  api GET "$(meeting_base)/sessions.json${params}"
}

meeting_get_meeting() {
  local meeting_key="$1"
  api GET "$(meeting_base)/${meeting_key}.json"
}

# ── Raw API call ─────────────────────────────────────────────────────
# Usage: raw <METHOD> <full_url_or_path> [curl_args...]
# If path starts with /crm → uses CRM domain; /portal or /restapi → Projects domain
raw_api() {
  local method="$1" path="$2"
  shift 2
  if [[ "$path" == http* ]]; then
    api "$method" "$path" "$@"
  elif [[ "$path" == /crm* ]]; then
    api "$method" "${ZOHO_CRM_DOMAIN}${path}" "$@"
  elif [[ "$path" == /meeting* ]]; then
    api "$method" "${ZOHO_MEETING_DOMAIN}${path}" "$@"
  else
    api "$method" "${ZOHO_PROJECTS_DOMAIN}${path}" "$@"
  fi
}

# ── CLI dispatch ─────────────────────────────────────────────────────
usage() {
  cat <<'EOF'
zoho — Zoho CRM + Projects + Meeting CLI

USAGE:
  zoho <command> [args...]

TOKEN:
  token                          Print current access token (refreshes if needed)

CRM:
  crm list <Module> [params]     List records (e.g., Deals, Contacts, Leads)
  crm get <Module> <id>          Get a single record
  crm search <Module> <criteria> Search records (e.g., "(Deal_Name:contains:Acme)")
  crm create <Module> <json>     Create record(s) — JSON body
  crm update <Module> <id> <json> Update a record
  crm delete <Module> <id>       Delete a record

PROJECTS:
  proj list                      List all projects
  proj get <project_id>          Get project details
  proj tasks <project_id> [params] List tasks in a project
  proj create-task <project_id> <form_data>  Create task (URL-encoded form)
  proj update-task <project_id> <task_id> <form_data>  Update task
  proj milestones <project_id>   List milestones
  proj tasklists <project_id>    List task lists
  proj bugs <project_id>         List bugs
  proj timelogs <project_id>     List time logs

MEETING:
  meeting recordings             List all meeting recordings
  meeting download <url> [file]  Download a recording (url from recordings list)
  meeting list [params]          List meetings/sessions
  meeting get <meeting_key>      Get meeting details

RAW:
  raw <METHOD> <path> [curl_args...]   Raw API call (/crm, /meeting, or full URL)

EXAMPLES:
  zoho token
  zoho crm list Deals "page=1&per_page=5"
  zoho crm search Deals "(Stage:equals:Closed Won)"
  zoho crm create Contacts '{"data":[{"Last_Name":"Smith","Email":"j@co.com"}]}'
  zoho proj list
  zoho proj tasks 12345678
  zoho proj create-task 12345678 "name=Fix+bug&priority=High"
  zoho meeting recordings
  zoho meeting recordings | jq '[.recordings[] | {topic, sDate, durationInMins}]'
  zoho meeting download "https://files-accl.zohopublic.com/..." recording.mp4
  zoho raw GET /crm/v7/settings/fields?module=Deals
EOF
}

cmd="${1:-help}"
shift || true

case "$cmd" in
  token)
    get_access_token
    ;;
  crm)
    sub="${1:-}"; shift || die "crm needs a subcommand (list|get|search|create|update|delete)"
    case "$sub" in
      list)    crm_list "$@" ;;
      get)     crm_get "$@" ;;
      search)  crm_search "$@" ;;
      create)  crm_create "$@" ;;
      update)  crm_update "$@" ;;
      delete)  crm_delete "$@" ;;
      *)       die "Unknown crm subcommand: $sub" ;;
    esac
    ;;
  meeting)
    sub="${1:-}"; shift || die "meeting needs a subcommand (recordings|download|list|get)"
    case "$sub" in
      recordings)    meeting_list_recordings ;;
      download)      meeting_download_recording "$@" ;;
      list)          meeting_list_meetings "$@" ;;
      get)           meeting_get_meeting "$@" ;;
      *)             die "Unknown meeting subcommand: $sub" ;;
    esac
    ;;
  proj)
    sub="${1:-}"; shift || die "proj needs a subcommand"
    case "$sub" in
      list)          proj_list_projects ;;
      get)           proj_get_project "$@" ;;
      tasks)         proj_list_tasks "$@" ;;
      create-task)   proj_create_task "$@" ;;
      update-task)   proj_update_task "$@" ;;
      milestones)    proj_list_milestones "$@" ;;
      tasklists)     proj_list_tasklists "$@" ;;
      bugs)          proj_list_bugs "$@" ;;
      timelogs)      proj_list_timelogs "$@" ;;
      *)             die "Unknown proj subcommand: $sub" ;;
    esac
    ;;
  raw)
    raw_api "$@"
    ;;
  help|--help|-h)
    usage
    ;;
  *)
    die "Unknown command: $cmd (try 'zoho help')"
    ;;
esac

#!/usr/bin/env bash
# standup-summarizer.sh — Pull Zoho Meeting recordings, transcribe via Gemini, summarize
# Usage: ./standup-summarizer.sh [--date YYYY-MM-DD] [--force-id <erecordingId>]
set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "$(readlink -f "${BASH_SOURCE[0]}")")" && pwd)"
ZOHO_SKILL_DIR="${ZOHO_SKILL_DIR:-$(cd "$(dirname "$(readlink -f "${BASH_SOURCE[0]}")")/.." && pwd)}"
PROCESSED_FILE="${ZOHO_DATA_DIR:-${ZOHO_SKILL_DIR}/data}/standup-processed.json"
TMP_DIR="/tmp/standup-$$"

# ── Load env ──────────────────────────────────────────────────────────
source "${ZOHO_SKILL_DIR}/.env"
GEMINI_API_KEY="${GEMINI_API_KEY:-}"
ZOHO_MEETING_ORG_ID="${ZOHO_MEETING_ORG_ID:-853106938}"

[[ -n "$GEMINI_API_KEY" ]] || { echo "ERROR: GEMINI_API_KEY not set" >&2; exit 1; }

# ── Args ──────────────────────────────────────────────────────────────
TARGET_DATE=""
FORCE_ID=""
while [[ $# -gt 0 ]]; do
  case "$1" in
    --date) TARGET_DATE="$2"; shift 2 ;;
    --force-id) FORCE_ID="$2"; shift 2 ;;
    *) echo "Unknown arg: $1" >&2; exit 1 ;;
  esac
done

# Default: today (Cairo time = UTC+2)
if [[ -z "$TARGET_DATE" ]]; then
  TARGET_DATE=$(TZ="Africa/Cairo" date +%Y-%m-%d)
fi

# Convert target date to epoch range (Cairo timezone)
TARGET_START_MS=$(TZ="Africa/Cairo" date -d "${TARGET_DATE} 00:00:00" +%s)000
TARGET_END_MS=$(TZ="Africa/Cairo" date -d "${TARGET_DATE} 23:59:59" +%s)999

echo "📅 Target date: ${TARGET_DATE} (Cairo)"
echo "⏰ Range: ${TARGET_START_MS} - ${TARGET_END_MS}"

# ── Ensure dirs ──────────────────────────────────────────────────────
mkdir -p "$TMP_DIR" "$(dirname "$PROCESSED_FILE")"
[[ -f "$PROCESSED_FILE" ]] || echo '[]' > "$PROCESSED_FILE"

cleanup() { rm -rf "$TMP_DIR"; }
trap cleanup EXIT

# ── Get Zoho access token ────────────────────────────────────────────
get_token() {
  "${ZOHO_SKILL_DIR}/bin/zoho" token
}

# ── Fetch recordings ────────────────────────────────────────────────
echo "🔍 Fetching recordings from Zoho Meeting..."
TOKEN=$(get_token)
RECORDINGS=$(curl -s -X GET \
  "https://meeting.zoho.com/meeting/api/v2/${ZOHO_MEETING_ORG_ID}/recordings.json" \
  -H "Authorization: Zoho-oauthtoken ${TOKEN}" \
  -H "Content-Type: application/json")

# Check for errors
if echo "$RECORDINGS" | jq -e '.error' &>/dev/null; then
  echo "ERROR: Zoho API error: $(echo "$RECORDINGS" | jq -r '.error')" >&2
  exit 1
fi

# ── Filter today's recordings ───────────────────────────────────────
echo "🔎 Filtering for date: ${TARGET_DATE}..."

if [[ -n "$FORCE_ID" ]]; then
  TODAY_RECORDINGS=$(echo "$RECORDINGS" | jq --arg fid "$FORCE_ID" \
    '[.recordings[] | select(.erecordingId == $fid)]')
else
  TODAY_RECORDINGS=$(echo "$RECORDINGS" | jq --argjson start "$TARGET_START_MS" --argjson end "$TARGET_END_MS" \
    '[.recordings[] | select(.startTimeinMs >= $start and .startTimeinMs <= $end)]')
fi

RECORDING_COUNT=$(echo "$TODAY_RECORDINGS" | jq 'length')
echo "📊 Found ${RECORDING_COUNT} recording(s) for ${TARGET_DATE}"

if [[ "$RECORDING_COUNT" -eq 0 ]]; then
  echo '{"status":"no_recordings","date":"'"${TARGET_DATE}"'","count":0}'
  exit 0
fi

# ── Process each recording ──────────────────────────────────────────
RESULTS="[]"
for i in $(seq 0 $((RECORDING_COUNT - 1))); do
  REC=$(echo "$TODAY_RECORDINGS" | jq ".[$i]")
  EREC_ID=$(echo "$REC" | jq -r '.erecordingId')
  TOPIC=$(echo "$REC" | jq -r '.topic')
  DURATION_MINS=$(echo "$REC" | jq -r '.durationInMins')
  DOWNLOAD_URL=$(echo "$REC" | jq -r '.downloadUrl // .publicDownloadUrl')
  FILE_SIZE=$(echo "$REC" | jq -r '.fileSize // .FileSize')
  START_MS=$(echo "$REC" | jq -r '.startTimeinMs')
  
  echo ""
  echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
  echo "📹 Recording: ${TOPIC}"
  echo "   Duration: ${DURATION_MINS} min | Size: ${FILE_SIZE}"
  echo "   ID: ${EREC_ID}"
  
  # Check if already processed
  if jq -e --arg id "$EREC_ID" '.[] | select(. == $id)' "$PROCESSED_FILE" &>/dev/null; then
    echo "   ⏭️  Already processed, skipping"
    continue
  fi
  
  # Download recording
  echo "   ⬇️  Downloading..."
  TOKEN=$(get_token)
  MP4_FILE="${TMP_DIR}/recording_${i}.mp4"
  HTTP_CODE=$(curl -s -w "%{http_code}" -o "$MP4_FILE" -L \
    -H "Authorization: Zoho-oauthtoken ${TOKEN}" \
    "$DOWNLOAD_URL")
  
  if [[ "$HTTP_CODE" != "200" ]] || [[ ! -s "$MP4_FILE" ]]; then
    echo "   ❌ Download failed (HTTP ${HTTP_CODE})"
    # Try public download URL if different
    PUB_URL=$(echo "$REC" | jq -r '.publicDownloadUrl // empty')
    if [[ -n "$PUB_URL" && "$PUB_URL" != "$DOWNLOAD_URL" ]]; then
      echo "   🔄 Trying public URL..."
      HTTP_CODE=$(curl -s -w "%{http_code}" -o "$MP4_FILE" -L "$PUB_URL")
    fi
    if [[ "$HTTP_CODE" != "200" ]] || [[ ! -s "$MP4_FILE" ]]; then
      echo "   ❌ Download failed completely"
      continue
    fi
  fi
  
  ACTUAL_SIZE=$(du -h "$MP4_FILE" | cut -f1)
  echo "   ✅ Downloaded: ${ACTUAL_SIZE}"
  
  # Extract audio
  echo "   🎵 Extracting audio..."
  WAV_FILE="${TMP_DIR}/audio_${i}.wav"
  ffmpeg -i "$MP4_FILE" -vn -acodec pcm_s16le -ar 16000 -ac 1 "$WAV_FILE" -y -loglevel error 2>&1
  
  if [[ ! -s "$WAV_FILE" ]]; then
    echo "   ❌ Audio extraction failed"
    continue
  fi
  
  WAV_SIZE=$(du -h "$WAV_FILE" | cut -f1)
  echo "   ✅ Audio extracted: ${WAV_SIZE}"
  
  # Check if audio is too large for Gemini inline (20MB limit for audio)
  WAV_BYTES=$(stat -c%s "$WAV_FILE")
  
  # Transcribe via Gemini Flash
  echo "   🧠 Transcribing via Gemini Flash..."
  
  if [[ "$WAV_BYTES" -gt 20000000 ]]; then
    # Large file: upload via File API first
    echo "   📤 Large file — uploading to Gemini File API..."
    UPLOAD_RESP=$(curl -s -X POST \
      "https://generativelanguage.googleapis.com/upload/v1beta/files?key=${GEMINI_API_KEY}" \
      -H "X-Goog-Upload-Command: start, upload, finalize" \
      -H "X-Goog-Upload-Header-Content-Length: ${WAV_BYTES}" \
      -H "X-Goog-Upload-Header-Content-Type: audio/wav" \
      -H "Content-Type: audio/wav" \
      --data-binary "@${WAV_FILE}")
    
    FILE_URI=$(echo "$UPLOAD_RESP" | jq -r '.file.uri // empty')
    if [[ -z "$FILE_URI" ]]; then
      echo "   ❌ File upload failed: $(echo "$UPLOAD_RESP" | jq -r '.error.message // "unknown"')"
      continue
    fi
    echo "   ✅ Uploaded: ${FILE_URI}"
    
    GEMINI_BODY=$(jq -n \
      --arg uri "$FILE_URI" \
      '{
        "contents": [{
          "parts": [
            {"file_data": {"mime_type": "audio/wav", "file_uri": $uri}},
            {"text": "Transcribe this meeting recording. The speakers are Egyptian and speak in Egyptian Arabic mixed with English technical terms. Provide a faithful transcription preserving the language as spoken (Arabic parts in Arabic script, English parts in English). Include speaker changes where detectable. Do NOT summarize — provide the full transcription."}
          ]
        }],
        "generationConfig": {"temperature": 0.1, "maxOutputTokens": 8192}
      }')
  else
    # Small file: inline base64 — write to temp file to avoid arg-list-too-long
    B64_FILE="${TMP_DIR}/audio_${i}.b64"
    base64 -w0 "$WAV_FILE" > "$B64_FILE"
    PROMPT_TEXT="Transcribe this meeting recording. The speakers are Egyptian and speak in Egyptian Arabic mixed with English technical terms. Provide a faithful transcription preserving the language as spoken (Arabic parts in Arabic script, English parts in English). Include speaker changes where detectable. Do NOT summarize — provide the full transcription."
    GEMINI_BODY=$(jq -n --rawfile audio "$B64_FILE" --arg prompt "$PROMPT_TEXT" \
      '{
        "contents": [{
          "parts": [
            {"inline_data": {"mime_type": "audio/wav", "data": $audio}},
            {"text": $prompt}
          ]
        }],
        "generationConfig": {"temperature": 0.1, "maxOutputTokens": 8192}
      }')
    rm -f "$B64_FILE"
  fi
  
  GEMINI_BODY_FILE="${TMP_DIR}/gemini_body_${i}.json"
  echo "$GEMINI_BODY" > "$GEMINI_BODY_FILE"
  GEMINI_RESP=$(curl -s -X POST \
    "https://generativelanguage.googleapis.com/v1beta/models/gemini-2.0-flash:generateContent?key=${GEMINI_API_KEY}" \
    -H "Content-Type: application/json" \
    -d "@${GEMINI_BODY_FILE}")
  rm -f "$GEMINI_BODY_FILE"
  
  TRANSCRIPT=$(echo "$GEMINI_RESP" | jq -r '.candidates[0].content.parts[0].text // empty')
  
  if [[ -z "$TRANSCRIPT" ]]; then
    echo "   ❌ Transcription failed: $(echo "$GEMINI_RESP" | jq -r '.error.message // "unknown"')"
    # Try with gemini-2.5-flash as fallback
    echo "   🔄 Retrying with gemini-2.5-flash..."
    GEMINI_BODY_FILE="${TMP_DIR}/gemini_body_${i}.json"
    echo "$GEMINI_BODY" > "$GEMINI_BODY_FILE"
    GEMINI_RESP=$(curl -s -X POST \
      "https://generativelanguage.googleapis.com/v1beta/models/gemini-2.5-flash:generateContent?key=${GEMINI_API_KEY}" \
      -H "Content-Type: application/json" \
      -d "@${GEMINI_BODY_FILE}")
    rm -f "$GEMINI_BODY_FILE"
    TRANSCRIPT=$(echo "$GEMINI_RESP" | jq -r '.candidates[0].content.parts[0].text // empty')
    if [[ -z "$TRANSCRIPT" ]]; then
      echo "   ❌ Transcription failed on both models"
      continue
    fi
  fi
  
  TRANSCRIPT_LEN=${#TRANSCRIPT}
  echo "   ✅ Transcribed: ${TRANSCRIPT_LEN} chars"
  
  # Save transcript
  TRANSCRIPT_FILE="${TMP_DIR}/transcript_${i}.txt"
  echo "$TRANSCRIPT" > "$TRANSCRIPT_FILE"
  
  # Build result JSON
  RESULT=$(jq -n \
    --arg id "$EREC_ID" \
    --arg topic "$TOPIC" \
    --arg duration "$DURATION_MINS" \
    --arg date "$TARGET_DATE" \
    --arg start_ms "$START_MS" \
    --arg transcript "$TRANSCRIPT" \
    '{
      "erecordingId": $id,
      "topic": $topic,
      "durationMins": ($duration | tonumber),
      "date": $date,
      "startMs": ($start_ms | tonumber),
      "transcript": $transcript
    }')
  
  RESULTS=$(echo "$RESULTS" | jq --argjson r "$RESULT" '. + [$r]')
  
  # Mark as processed
  jq --arg id "$EREC_ID" '. + [$id]' "$PROCESSED_FILE" > "${PROCESSED_FILE}.tmp"
  mv "${PROCESSED_FILE}.tmp" "$PROCESSED_FILE"
  
  echo "   ✅ Done processing"
  
  # Clean up large files immediately to save disk
  rm -f "$MP4_FILE" "$WAV_FILE"
done

# ── Output results ──────────────────────────────────────────────────
RESULT_COUNT=$(echo "$RESULTS" | jq 'length')
echo ""
echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━"
echo "✅ Processed ${RESULT_COUNT} recording(s)"

if [[ "$RESULT_COUNT" -eq 0 ]]; then
  echo '{"status":"nothing_new","date":"'"${TARGET_DATE}"'","count":0}'
  exit 0
fi

# Output the full results JSON for the caller to summarize
echo "---RESULTS_JSON_START---"
echo "$RESULTS" | jq '.'
echo "---RESULTS_JSON_END---"

{
  "name": "zoho",
  "version": "1.3.0",
  "description": "Interact with Zoho CRM, Projects, and Meeting APIs. Manage deals, contacts, leads, tasks, projects, milestones, meeting recordings, and standups.",
  "author": "shreefentsar",
  "tags": ["zoho", "crm", "projects", "meetings", "standup", "recordings"],
  "env": [
    {
      "name": "ZOHO_CLIENT_ID",
      "description": "Zoho OAuth2 Client ID (from api-console.zoho.com)",
      "required": true,
      "secret": true
    },
    {
      "name": "ZOHO_CLIENT_SECRET",
      "description": "Zoho OAuth2 Client Secret",
      "required": true,
      "secret": true
    },
    {
      "name": "ZOHO_REFRESH_TOKEN",
      "description": "Zoho OAuth2 Refresh Token",
      "required": true,
      "secret": true
    },
    {
      "name": "ZOHO_ORG_ID",
      "description": "Zoho CRM Organization ID",
      "required": true,
      "secret": false
    },
    {
      "name": "ZOHO_MEETING_ORG_ID",
      "description": "Zoho Meeting Organization ID",
      "required": false,
      "secret": false
    },
    {
      "name": "GEMINI_API_KEY",
      "description": "Google Gemini API key — used by standup-summarizer.sh to transcribe meeting audio via Gemini 2.0 Flash",
      "required": false,
      "secret": true
    },
    {
      "name": "ZOHO_DATA_DIR",
      "description": "Optional: override directory for persistent data files (e.g. standup-processed.json). Defaults to <skill_dir>/data/",
      "required": false,
      "secret": false
    }
  ],
  "files": [
    "SKILL.md",
    "README.md",
    ".env.example",
    "bin/zoho",
    "scripts/standup-summarizer.sh",
    "references/"
  ],
  "notes": "Requires the bin/zoho CLI wrapper to be executable (chmod +x bin/zoho). The standup-summarizer.sh script requires GEMINI_API_KEY for audio transcription and writes state to ZOHO_DATA_DIR (configurable)."
}