Google Chat application that creates AI summaries of a consolidation Chat threads and posts them back within the top-level Chat message. Use case is using AI to streamline Stand up content within Google Chat.
- Google Cloud Project (aka Standard Cloud Project for Apps Script) with billing enabled
- Create a Cloud Project
- Configure OAuth consent screen
- Enable the Admin SDK API
- Enable the Generative Language API
- Enable and configure the Google Chat API with the following values:
- App status: Live - available to users
- App name: “Standup”
- Avatar URL: “https://www.gstatic.com/images/branding/productlogos/chat_2020q4/v8/web-24dp/logo_chat_2020q4_color_2x_web_24dp.png”
- Description: “Standup App”
- Enable Interactive features: Disabled
- Create a Google Gemini API Key
- Navigate to https://aistudio.google.com/app/apikey
- Create API key for existing project from step 1
- Copy the generated key
- Create and open a standalone Apps Script project
- From Project Settings, change project to GCP project number of Cloud Project from step 1
- Add the following script properties:
- Set
API_KEYwith the API key previously generated as the value. - Set
SPREADSHEET_IDwith the file ID of a blank spreadsheet. - Set
SPACE_NAMEto the resource name of a Chat space (e.g.spaces/AAAXYZ)
- Set
- Enable the Google Chat advanced service
- Enable the AdminDirectory advanced service
- Add the project code to Apps Script
- Enable triggers:
- Add Time-driven to run function
standupat the desired interval frequency (e.g. Week timer) - Add Time-driven to run function
summarizeat the desired interval frequency (e.g. Hour timer)
- Add Time-driven to run function