{
  "documentation_url": "https://docs.multiwoven.com/destinations/productivity-tools/google-sheets-service-account",
  "stream_type": "dynamic",
  "connection_specification": {
    "$schema": "http://json-schema.org/draft-07/schema#",
    "title": "Google Sheets",
    "type": "object",
    "required": ["credentials_json"],
    "properties": {
      "spreadsheet_link": {
        "type": "string"
      },
      "credentials_json": {
        "type": "object",
        "description": "You can get the keys from the Google Cloud web console. First, go to the IAM page and select Service Accounts from the left menu. Next, locate your service account in the list, click on its Keys tab, and then click Add Key. Lastly, click Create new key and select JSON.",
        "title": "",
        "properties": {
          "type": {
            "type": "string",
            "enum": ["service_account"]
          },
          "project_id": {
            "type": "string"
          },
          "private_key_id": {
            "type": "string"
          },
          "private_key": {
            "type": "string",
            "multiwoven_secret": true
          },
          "client_email": {
            "type": "string",
            "format": "email"
          },
          "client_id": {
            "type": "string"
          },
          "auth_uri": {
            "type": "string",
            "format": "uri"
          },
          "token_uri": {
            "type": "string",
            "format": "uri"
          },
          "auth_provider_x509_cert_url": {
            "type": "string",
            "format": "uri"
          },
          "client_x509_cert_url": {
            "type": "string",
            "format": "uri"
          },
          "universe_domain": {
            "type": "string"
          }
        },
        "required": [
          "type",
          "project_id",
          "private_key_id",
          "private_key",
          "client_email",
          "client_id",
          "auth_uri",
          "token_uri",
          "auth_provider_x509_cert_url",
          "client_x509_cert_url",
          "universe_domain"
        ]
      }
    }
  }
}