The Scenario
You're a UX researcher three weeks into a study. Twenty customer interviews are done, all recorded in Fathom. The recording IDs are in column A of your analysis sheet — some pasted from Slack, some from a shared Notion doc, some you typed in yourself. Column B is empty.
You need the full transcript for each recording in column B so you can run thematic analysis.
A colleague tried to help by exporting a few transcripts manually from the Fathom dashboard. The exports came down as PDFs. You spent an hour reformatting the first two before giving up and going back to the UI.
The bad version:
- Open Fathom, search for the first recording ID, click into the transcript view
- Select all text, copy it, switch to the sheet, paste it into B2, scroll back up, hope you copied the right one
- Repeat nineteen more times while managing the fact that some of the IDs in column A have a stray space at the end from wherever they were copied
Nobody hired you to be a clipboard operator for two hours. You have 20 transcripts to code and an analysis deadline next week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the IDs in column A, connects to Fathom for each one, and writes the transcript into column B — without you clicking through each recording.
For each Fathom recording ID in column A of this sheet, fetch the full transcript and write the timestamped transcript text into column B in the same row
What You Get
- Column B filled with the complete transcript for each recording ID in column A
- Each entry includes speaker labels and timestamps as Fathom returns them
- Rows where an ID is invalid or the recording isn't accessible get a clear error note in column B rather than silently staying blank
- Any trailing whitespace in column A is trimmed automatically before the lookup
What If the Data Is Not Quite Ready
Some IDs in column A are call IDs, not recording IDs
For each value in column A of this sheet, try fetching the Fathom transcript by recording ID first; if that returns not found, try treating it as a call ID and fetch by call ID, then write the transcript result into column B
You need speaker and timestamp in separate columns rather than combined
For each Fathom recording ID in column A, fetch the transcript and write the speaker name into column B, the timestamp into column C, and the transcript text into column D — one row per transcript segment
Some rows in column A are blank and should be skipped
For each non-empty cell in column A of this sheet, fetch the Fathom transcript by recording ID and write the result into column B of the same row; skip any blank rows in column A
The full pipeline: deduplicate IDs, fetch transcripts, flag anomalies in one shot
Remove any duplicate recording IDs in column A, then for each unique ID fetch the Fathom transcript, write the full transcript into column B, and if the transcript text is under 200 characters flag the row in column C with "short or incomplete" — do this for all rows with a value in column A
Ask once, get clean data back.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you have your Fathom recording IDs, then ask it to pull the transcript for each one into the adjacent column. See also the spoke on exporting meeting summaries or the Fathom integration overview.