This project gives a custom GPT the ability to interact with your Google Workspace Apps, essentially functioning as your executive assistant. It can currently do the following upon user request:
Gmail:
- Access your inbox
- Summarize email threads
- Generate reply drafts
- Mark emails as read/unread and archive them
Google Calendar:
- View your current schedule
- Create new events
- Update existing events
Personal CRM (Google Sheets):
- View all contacts
- Read profile details
- Create new profiles
- Update profiles
-
Email Triage
- Give me a quick summary of new emails I received today
- Archive anything that doesn't require a response
- Create 5-minute time slots on my calendar starting at 4 pm to respond to anything that requires a response.
- Link those emails in the event descriptions and then archive them
-
Remember Anything
- Tom's birthday is April 20th
- Update his CRM profile
- Add it as an all-day event to my calendar
-
Extract Key Details
- Read Tom's Christmas update email he sent 1 month ago
- Extract all personal details
- Update his CRM profile with relevant information
-
Speedy Response
- Summarize the long email chain from Tom
- Draft an encouraging response and give me the link
- Make a copy of this template
- Access the Apps Script code Extensions > Apps Script
- Update the values on the
API Handler.gsfile - Deploy > New Deployment | Execute as Me | Anyone has access
- Paste Instructions and YAML into your own custom GPT
- Update security key to match App Script