Google Apps Script for Meeting Transcript Management

This script automates the process of finding and organizing meeting transcripts from Google Calendar events. It is designed to be used with a Google Sheet.

Features

• Fetches Today's Calendar Events: The script retrieves all events from the user's primary Google Calendar for the current day.
• Identifies Transcripts: It checks each event for a Google Doc attachment, which is assumed to be the meeting transcript.
• Copies Transcripts: If a transcript is found, it is copied to a designated "Transcripts" folder in the user's Google Drive.
• Logs Transcript Information: The script logs the following information to the active Google Sheet:
  • Time of the meeting
  • Event title
  • Google Meet link
  • Transcript name
  • Transcript link
  • Copy status (Copied, Not Found, or Error)
  • Error message (if any)

Installation

1. Create a new Google Sheet: Go to sheets.new.
2. Open the Script Editor: Go to Extensions > Apps Script.
3. Copy the code: Copy the entire contents of the Code.js file from this project.
4. Paste the code: Paste the code into the Code.gs file in the Apps Script editor, replacing any existing code.
5. Save the project: Click the save icon or press Ctrl + S.

Services to Enable

This script requires the following Google Workspace services to be enabled:

• Google Calendar API: To fetch calendar events.

To enable the Google Calendar API:

1. In the Apps Script editor, click on Services +.
2. Select Google Calendar API.
3. Click Add.

How to Use

1. Open the Google Sheet: Open the Google Sheet that you want to use with the script.
2. Run the Script:
   • In the Google Sheet, a new menu item called Meeting Tools will appear.
   • Click on Meeting Tools > Get Today's Transcripts.
   • The script will run and populate the sheet with the transcript information.

The "Transcripts" Folder

The first time the script is run, it will create a folder named "Transcripts" in the root of your Google Drive. All subsequent transcripts will be copied to this folder.

Notes

• The script assumes that the transcript is a Google Doc attached to the calendar event.
• The script will overwrite the contents of the active sheet each time it is run.
• If you want to use a different calendar, you can change the calendarId variable in the getTodaysMeetingTranscripts function.