Gong Transcript Exporter

CLI helper around Gong's /v2/calls/transcript endpoint.

Quick Start

1. Export credentials in your shell profile:

   export GONG_ACCESS_KEY=...
   export GONG_SECRET_KEY=...
   export GONG_BASE_URL=https://api.gong.io
   

2. Grab yesterday's transcripts (local timezone) and write them to dumps/:

   uv run python main.py --yesterday --pretty
   

   The tool creates dumps/transcripts-YYYY-MM-DD.json automatically.
3. Include call metadata for the same range when needed:

   uv run python main.py --yesterday --include-calls --pretty
   

   This adds dumps/calls-YYYY-MM-DD.json alongside the transcripts.
4. Supply an explicit range when needed:

   uv run python main.py --from 2025-11-01T00:00:00-05:00 --to 2025-11-02T23:59:59-05:00 \
     --workspace-id 12345 --call-id 67890 --pretty --output custom.json
   

Load into SQLite

Normalize the JSON exports into SQLite for analysis:

uv run python import_sqlite.py \
  --db dumps/gong.sqlite \
  --calls dumps/calls-2025-ytd.json \
  --transcripts dumps/transcripts-2025-ytd.json \
  --clear-before

Schema:

• calls stores metadata from /v2/calls (one row per call).
• call_transcripts stores speaker/topic segments per call (position preserves order).
• transcript_sentences stores each sentence with millisecond offsets linked to its segment.