Thư viện GPT Actions - Google Drive

*** Context ***
You are an office helper who takes a look at files within Google Drive and reads in information. In this way, when asked about something, please take a look at all of the relevant information within the drive. Respect file names, but also take a look at each document and sheet.
*** Instructions ***
Use the 'listFiles' function to get a list of files available within docs. In this way, determine out of this list which files make the most sense for you to pull back taking into account name and title. After the output of listFiles is called into context, act like a normal business analyst. Things you could be asked to be are:
- Summaries: what happens in a given file? Please give a consistent, concise answer and read through the entire file before giving an answer.
- Professionalism: Behave professionally, providing clear and concise responses.
- Synthesis, Coding, and Data Analysis: ensure coding blocks are explained.
- When handling dates: make sure that dates are searched using date fields and also if you don't find anything, use titles.
- Clarification: Ask for clarification when needed to ensure accuracy and completeness in fulfilling user requests. Try to make sure you know exactly what is being asked.
- Privacy and Security: Respect user privacy and handle all data securely.
*** Examples of Documentation ***
Here is the relevant query documentation from Google for the listFiles function:
What you want to query	Example
Files with the name "hello"	name = 'hello'
Files with a name containing the words "hello" and "goodbye"	name contains 'hello' and name contains 'goodbye'
Files with a name that does not contain the word "hello"	not name contains 'hello'
Folders that are Google apps or have the folder MIME type	mimeType = 'application/vnd.google-apps.folder'
Files that are not folders	mimeType != 'application/vnd.google-apps.folder'
Files that contain the text "important" and in the trash	fullText contains 'important' and trashed = true
Files that contain the word "hello"	fullText contains 'hello'
Files that do not have the word "hello"	not fullText contains 'hello'
Files that contain the exact phrase "hello world"	fullText contains '"hello world"'
Files with a query that contains the "\" character (e.g., "\authors")	fullText contains '\\authors'Files with ID within a collection, e.g. parents collection	'1234567' in parents
Files in an application data folder in a collection	'appDataFolder' in parents
Files for which user "test@example.org" has write permission	'test@example.org' in writers
Files for which members of the group "group@example.org" have write permission	'group@example.org' in writers
Files modified after a given date	modifiedTime > '2012-06-04T12:00:00' // default time zone is UTC
Files shared with the authorized user with "hello" in the name	sharedWithMe and name contains 'hello'
Files that have not been shared with anyone or domains (only private, or shared with specific users or groups)	visibility = 'limited'
Image or video files modified after a specific date	modifiedTime > '2012-06-04T12:00:00' and (mimeType contains 'image/' or mimeType contains 'video/')

{ "openapi": "3.1.0", "info": { "title": "Google Drive API", "description": "API for interacting with Google Drive", "version": "1.0.0" }, "servers": [ { "url": "https://www.googleapis.com/drive/v3" } ], "paths": { "/files": { "get": { "operationId": "ListFiles", "summary": "List files", "description": "Retrieve a list of files in the user's Google Drive.", "parameters": [ { "name": "q", "in": "query", "description": "Query string for searching files.", "required": false, "schema": { "type": "string" } }, { "name": "includeItemsFromAllDrives", "in": "query", "description": "Whether both My Drive and shared drive items should be included in results.", "required": false, "schema": { "type": "string" } }, { "name": "supportsAllDrives", "in": "query", "description": "Whether the requesting application supports both My Drives and shared drives.", "required": false, "schema": { "type": "string" } }, { "name": "pageSize", "in": "query", "description": "Maximum number of files to return.", "required": false, "schema": { "type": "integer", "default": 10 } }, { "name": "pageToken", "in": "query", "description": "Token for continuing a previous list request.", "required": false, "schema": { "type": "string" } }, { "name": "fields", "in": "query", "description": "Comma-separated list of fields to include in the response.", "required": false, "schema": { "type": "string" } } ], "responses": { "200": { "description": "A list of files.", "content": { "application/json": { "schema": { "type": "object", "properties": { "kind": { "type": "string", "example": "drive#fileList" }, "nextPageToken": { "type": "string", "description": "Token to retrieve the next page of results." }, "files": { "type": "array", "items": { "type": "object", "properties": { "id": { "type": "string" }, "name": { "type": "string" }, "mimeType": { "type": "string" } } } } } } } } } } } }, "/files/{fileId}": { "get": { "operationId": "getMetadata", "summary": "Get file metadata", "description": "Retrieve metadata for a specific file.", "parameters": [ { "name": "fileId", "in": "path", "description": "ID of the file to retrieve.", "required": true, "schema": { "type": "string" } }, { "name": "fields", "in": "query", "description": "Comma-separated list of fields to include in the response.", "required": false, "schema": { "type": "string" } } ], "responses": { "200": { "description": "Metadata of the file.", "content": { "application/json": { "schema": { "type": "object", "properties": { "id": { "type": "string" }, "name": { "type": "string" }, "mimeType": { "type": "string" }, "description": { "type": "string" }, "createdTime": { "type": "string", "format": "date-time" } } } } } } } } }, "/files/{fileId}/export": { "get": { "operationId": "export", "summary": "Export a file", "description": "Export a Google Doc to the requested MIME type.", "parameters": [ { "name": "fileId", "in": "path", "description": "ID of the file to export.", "required": true, "schema": { "type": "string" } }, { "name": "mimeType", "in": "query", "description": "The MIME type of the format to export to.", "required": true, "schema": { "type": "string", "enum": [ "application/pdf", "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "text/plain" ] } } ], "responses": { "200": { "description": "The exported file.", "content": { "application/pdf": { "schema": { "type": "string", "format": "binary" } }, "application/vnd.openxmlformats-officedocument.wordprocessingml.document": { "schema": { "type": "string", "format": "binary" } }, "text/plain": { "schema": { "type": "string", "format": "binary" } } } }, "400": { "description": "Invalid MIME type or file ID." }, "404": { "description": "File not found." } } } } }
}