google sheets - Deploy google_sheet fivetran connector with terraform without manual action - Stack Overflow

I am trying to deploy a Fivetran google_sheet connector using Terraform.

I have the following resource :

data "fivetran_destination" "s3_destination" {
  id = "my_id"
}

resource "fivetran_connector" "google_sheets" {
  group_id = data.fivetran_destination.s3_destination.group_id
  service  = "google_sheets"

  destination_schema {
    name  = "my_data"
    table = "my_table"
  }

  config {
    sheet_id  = "my_id"
  }
}

resource "fivetran_connector_schedule" "google_sheets_schedule" {
  connector_id   = fivetran_connector.google_sheets.id
  sync_frequency = "1440" # Once every 24 hours
  paused         = false
}

However the created connection is created in state incomplete, and I need to manually grant access to the connection :

Is it possible to have it working without any manual interaction ? If so, how ?