Google Sheets

Get a destination spreadsheet

Returns a single destination spreadsheet, including its tab assignments, transfer links, and health status.

GET

/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId}

curl --request GET \
  --url https://api.synci.io/api/v1/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId} \
  --header 'Authorization: Bearer <token>'

{
  "data": {
    "balance_history_sheet_gid": "<string>",
    "balance_history_sheet_name": "<string>",
    "connection": {
      "auth_url": "<string>",
      "created_at": "<string>",
      "enabled": "<string>",
      "google_email": "<string>",
      "health": {
        "failure_count": "<string>",
        "integrator_message": "<string>",
        "last_attempt_at": "<string>",
        "status": "<string>",
        "transient_failure_count": "<string>",
        "transient_message": "<string>"
      },
      "id": "<string>",
      "last_synced_at": "<string>",
      "name": "<string>",
      "sheets": [
        {}
      ],
      "updated_at": "<string>"
    },
    "connection_id": "<string>",
    "created_at": "<string>",
    "health": {
      "failure_count": "<string>",
      "integrator_message": "<string>",
      "last_attempt_at": "<string>",
      "status": "<string>",
      "transient_failure_count": "<string>",
      "transient_message": "<string>"
    },
    "id": "<string>",
    "is_synci_managed": "<string>",
    "last_synced_at": "<string>",
    "live_balance_sheet_gid": "<string>",
    "live_balance_sheet_name": "<string>",
    "name": "<string>",
    "spreadsheet_id": "<string>",
    "spreadsheet_name": "<string>",
    "spreadsheet_url": "<string>",
    "transactions_sheet_gid": "<string>",
    "transactions_sheet_name": "<string>",
    "transfer_links": [
      {
        "active": "<string>",
        "created_at": "<string>",
        "destination": {
          "balance": "<string>",
          "budget": {
            "accounts": [
              {}
            ],
            "connection": {
              "auth_url": "<string>",
              "budgets": [
                {}
              ],
              "created_at": "<string>",
              "enabled": "<string>",
              "health": {
                "failure_count": "<string>",
                "integrator_message": "<string>",
                "last_attempt_at": "<string>",
                "status": "<string>",
                "transient_failure_count": "<string>",
                "transient_message": "<string>"
              },
              "id": "<string>",
              "last_synced_at": "<string>",
              "name": "<string>",
              "sync_balances": "<string>",
              "updated_at": "<string>",
              "ynab_user_id": "<string>"
            },
            "connection_id": "<string>",
            "created_at": "<string>",

Authorizations

Authorizationstringheaderrequired

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

connectionIdintegerrequired

The Google Sheets connection ID

sheetIdintegerrequired

The Google Sheet ID

Response

GoogleSheetResource

dataobjectrequired

Show child attributes

Still need help? Ask the team