Resources: Config Spreadsheet · Apps Script
Once set up, this runs itself. Interview recordings upload automatically from each phone to Google Drive, the script sorts and renames them throughout the day, and recordings land in the right folder. The only thing you need to do is a 5-minute update before each retreat.
1. Create the recordings folder in Google Drive
Inside the shared Jhourney Drive, create a new folder. Follow the same naming pattern as previous retreats:
2. 260410 (Horizon) - Retreat recordings
2. Copy the folder ID
Open that folder. In the URL bar you'll see something like:
https://drive.google.com/drive/folders/ABC123xyz
The folder ID is everything after /folders/. In this example: ABC123xyz. Copy it.
3. Update the config spreadsheet
Open the Retreat Recording Config and update every row with the new retreat's details:
| Column | What to enter |
|---|---|
| Facilitator | Each facilitator's name |
| Retreat Code | e.g., 260410 (Horizon) |
| Start Date | First day of the retreat, e.g., 4/10/2026 |
| Recordings Folder ID | The ID from step 2 — same value for all 6 rows |
The Phone column (Phone-1 through Phone-6) stays the same every retreat.
Nothing to do. The script runs automatically at 12pm and every hour from 2–7pm.
To check it's working, open the recordings folder in Drive. Within an hour of a session being recorded, you should see a file named like: