Create new Google Sheets connection
POST
/destinations/google-sheets/connections
Synci to manage spreadsheets on your behalf. Once authorized, you can
register destination spreadsheets and link them to financial accounts.
Request
Body Params application/json
Responses
Request Request Example
Shell
JavaScript
Java
Swift
curl --location 'https://api.synci.io/api/v1/destinations/google-sheets/connections' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"name": "string"
}'Response Response Example
201 - Example 1
{
"message": "Connection created. Follow the URL to start the authentication process with Google.",
"data": {
"auth_url": "string",
"google_sheets_connection": {
"id": 0,
"name": "string",
"health": {
"status": "HEALTHY",
"integrator_message": "string",
"failure_count": 0,
"last_attempt_at": "2019-08-24T14:15:22.123Z"
},
"enabled": true,
"auth_url": "string",
"google_email": "string",
"sheets": [
{
"id": 0,
"connection_id": 0,
"connection": {},
"health": {
"status": "HEALTHY",
"integrator_message": "string",
"failure_count": 0,
"last_attempt_at": "2019-08-24T14:15:22.123Z"
},
"name": "string",
"spreadsheet_id": "string",
"spreadsheet_name": "string",
"spreadsheet_url": "string",
"is_synci_managed": true,
"transactions_sheet_gid": 0,
"transactions_sheet_name": "string",
"live_balance_sheet_gid": 0,
"live_balance_sheet_name": "string",
"balance_history_sheet_gid": 0,
"balance_history_sheet_name": "string",
"transfer_links": [
{
"id": 0,
"financial_account_id": 0,
"financial_account": {
"id": 0,
"financial_connection_id": 0,
"financial_connection": {
"id": 0,
"institution_id": 0,
"institution": {
"id": 0,
"integrator": "UNKNOWN",
"country": "string",
"name": "string",
"bic": "string",
"external_id": "string",
"logo": "string",
"supported": true,
"supports_pending_transactions": true,
"supports_card_accounts": true,
"max_historical_days": 0,
"max_access_valid_for_days": 0,
"category": "string",
"updated_at": "2019-08-24T14:15:22.123Z"
},
"enabled": true,
"health": {
"status": "HEALTHY",
"integrator_message": "string",
"failure_count": 0,
"last_attempt_at": "2019-08-24T14:15:22.123Z"
},
"status": "string",
"status_message": "string",
"sync_balances": true,
"supports_reauthorization": "string",
"supports_manage": "string",
"max_historical_days": "string",
"access_valid_for_days": "string",
"consent_expires_at": "string",
"accounts_last_synced_at": "2019-08-24T14:15:22.123Z",
"financial_accounts": [
{}
],
"financial_accounts_count": "string",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
},
"config": {
"map_fields": {
"payee": "AUTO",
"description": "AUTO",
"date": "AUTO"
},
"enrichment": {
"enabled": "string",
"provider": "string",
"country": "string"
},
"sync_start_date": "2025-01-01",
"sync_auto": true,
"sync_pending_transactions": true,
"sync_balances": true,
"sync_frequency_in_minutes": 0,
"fields_for_duplicate_filtering": [
"string"
]
},
"health": {
"status": "HEALTHY",
"integrator_message": "string",
"failure_count": 0,
"last_attempt_at": "2019-08-24T14:15:22.123Z"
},
"enabled": true,
"integrator": "UNKNOWN",
"account_category": "string",
"raw_type": "string",
"cash_balance": {
"amount": "string",
"currency": "string"
},
"meta": [
null
],
"account_number_masked": "string",
"name": "string",
"custom_name": "string",
"display_name": "string",
"bban": "string",
"iban": "string",
"owner_name": "string",
"currency": "string",
"product_name": "string",
"details": "string",
"msisdn": "string",
"integrator_id": "string",
"institution_id": "string",
"details_last_synced_at": "2019-08-24T14:15:22.123Z",
"transactions_last_synced_at": "2019-08-24T14:15:22.123Z",
"balances_last_synced_at": "2019-08-24T14:15:22.123Z",
"balance": {
"available": null,
"cleared": null
},
"rules": "string",
"transfer_links": [
{}
],
"transfer_links_count": "string",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
},
"destination_type": "YNAB",
"destination_id": 0,
"destination": {
"id": 0,
"budget_id": 0,
"budget": {
"id": 0,
"connection_id": 0,
"connection": {
"id": 0,
"name": "string",
"health": {
"status": "HEALTHY",
"integrator_message": "string",
"failure_count": 0,
"last_attempt_at": "2019-08-24T14:15:22.123Z"
},
"enabled": true,
"auth_url": "string",
"sync_balances": true,
"ynab_user_id": "string",
"budgets": [
{}
],
"last_synced_at": "2019-08-24T14:15:22.123Z",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
},
"ynab_id": "string",
"enabled": true,
"name": "string",
"currency": "string",
"first_month": "string",
"last_month": "string",
"accounts": [
{}
],
"last_synced_at": "2019-08-24T14:15:22.123Z",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
},
"ynab_id": "string",
"health": {
"status": "HEALTHY",
"integrator_message": "string",
"failure_count": 0,
"last_attempt_at": "2019-08-24T14:15:22.123Z"
},
"name": "string",
"type": "checking",
"on_budget": true,
"closed": true,
"note": "string",
"balance": "string",
"cleared_balance": "string",
"uncleared_balance": "string",
"transfer_payee_id": "string",
"direct_import_linked": true,
"last_reconciled_at": "string",
"rules": "string",
"transfer_links": [
{}
],
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
},
"transfer_start_date": "2025-01-01",
"active": true,
"sync_mode": "TRANSACTIONS",
"on_booked_change": {
"update_status": true,
"update_payee": true,
"update_description": true,
"update_amount": true
},
"rules": "string",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
}
],
"last_synced_at": "2019-08-24T14:15:22.123Z",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
}
],
"last_synced_at": "2019-08-24T14:15:22.123Z",
"created_at": "2019-08-24T14:15:22.123Z",
"updated_at": "2019-08-24T14:15:22.123Z"
}
}
}Modified at 2026-07-14 16:18:50