AccountingGPT · GPT 작업

{
  "openapi": "3.1.0",
  "info": {
    "title": "AccountingGPT with Google Sheets API",
    "version": "1.0.0",
    "description": "A custom GPT integration with Google Sheets API for accounting purposes."
  },
  "servers": [
    {
      "url": "https://sheets.googleapis.com/v4/spreadsheets",
      "description": "Google Sheets API Service"
    }
  ],
  "paths": {
    "/{spreadsheetId}": {
      "get": {
        "operationId": "getSpreadsheetData",
        "summary": "Retrieve Spreadsheet Data",
        "parameters": [
          {
            "name": "spreadsheetId",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "The ID of the spreadsheet to retrieve."
          }
        ],
        "responses": {
          "200": {
            "description": "Spreadsheet data successfully retrieved.",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/SpreadsheetData"
                }
              }
            }
          },
          "404": {
            "description": "Spreadsheet not found."
          }
        }
      },
      "put": {
        "operationId": "updateSpreadsheetData",
        "summary": "Update Spreadsheet Data",
        "parameters": [
          {
            "name": "spreadsheetId",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "The ID of the spreadsheet to update."
          }
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/UpdateDataRequest"
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "Spreadsheet data successfully updated."
          },
          "404": {
            "description": "Spreadsheet not found."
          }
        }
      }
    }
  },
  "components": {
    "schemas": {
      "SpreadsheetData": {
        "type": "object",
        "properties": {
          "spreadsheetId": {
            "type": "string"
          },
          "properties": {
            "type": "object",
            "properties": {
              "title": {
                "type": "string"
              }
            }
          },
          "sheets": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/Sheet"
            }
          }
        }
      },
      "Sheet": {
        "type": "object",
        "properties": {
          "properties": {
            "type": "object",
            "properties": {
              "sheetId": {
                "type": "integer"
              },
              "title": {
                "type": "string"
              },
              "index": {
                "type": "integer"
              }
            }
          },
          "data": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/GridData"
            }
          }
        }
      },
      "GridData": {
        "type": "object",
        "properties": {
          "rowData": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/RowData"
            }
          }
        }
      },
      "RowData": {
        "type": "object",
        "properties": {
          "values": {
            "type": "array",
            "items": {
              "type": "object",
              "properties": {
                "userEnteredValue": {
                  "type": "object",
                  "properties": {
                    "stringValue": {
                      "type": "string"
                    }
                  }
                }
              }
            }
          }
        }
      },
      "UpdateDataRequest": {
        "type": "object",
        "properties": {
          "values": {
            "type": "array",
            "items": {
              "type": "array",
              "items": {
                "type": "string"
              }
            }
          }
        }
      }
    },
    "securitySchemes": {
      "GoogleOAuth2": {
        "type": "oauth2",
        "flows": {
          "authorizationCode": {
            "authorizationUrl": "https://accounts.google.com/o/oauth2/auth/215285805992-mvdlfos37bagfr2e9459qi8kc1mjndma.apps.googleusercontent.com",
            "tokenUrl": "https://oauth2.googleapis.com/token",
            "scopes": {
              "https://www.googleapis.com/auth/spreadsheets": "Manage your spreadsheets"
            }
          }
        }
      }
    }
  },
  "security": [
    {
      "GoogleOAuth2": []
    }
  ]
}