Google Sheets

Create new Google Sheets connection

Synci generates an authorization URL (auth_url). Follow it to authorize Synci to manage spreadsheets on your behalf. Once authorized, you can register destination spreadsheets and link them to financial accounts.

POST

/destinations/google-sheets/connections

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

{
  "data": {
    "auth_url": "<string>",
    "google_sheets_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": [
        {
          "balance_history_sheet_gid": "<string>",
          "balance_history_sheet_name": "<string>",
          "connection": {},
          "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": {},
                  "connection_id": "<string>",
                  "created_at": "<string>",
                  "currency": "<string>",
                  "enabled": "<string>",
                  "first_month": "<string>",
                  "id": "<string>",
                  "last_month": "<string>",
                  "last_synced_at": "<string>",
                  "name": "<string>",
                  "updated_at": "<string>",
                  "ynab_id": "<string>"
                },
                "budget_id": "<string>",
                "cleared_balance": "<string>",
                "closed": "<string>",
                "created_at": "<string>",
                "direct_import_linked": "<string>",
                "health": {
                  "failure_count": "<string>",
                  "integrator_message": "<string>",
                  "last_attempt_at": "<string>",
                  "status": "<string>",
                  "transient_failure_count": "<string>",
                  "transient_message": "<string>"
                },
                "id": "<string>",

Authorizations

Authorizationstringheaderrequired

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

Body

namestring | null

Optional display name for the connection.

Maximum string length: 255

Response

dataobjectrequired

Show child attributes

messagestringrequired

Still need help? Ask the team