paultyng / terraform-provider-gsuite

Terraform Provider for GSuite (currently Calendar and Sheets)

Terraform Google Sheets Provider (G Suite)

This is a Terraform provider for accessing Google Sheets data in G Suite.

terraform-provider-gsuite's Issues

add support for retrieving computed values

Hello maintainer(s) 👋🏼!

I'd like to make a feature request for adding support for retrieving computed / Google Sheets interpolated values.

This would allow the use of formulas in Google Sheets such as =COUNTA(Data!A:A)-1 to calculate values that can then be used in Terraform.

Right now, when retrieving a field like this, the provider interprets the field value like so:

{
  "date_time_render" = "SERIAL_NUMBER"
  "id" = "36kA4g8r2F64i67g7_13HB4d665IP4o3540opYOex3wS:Configuration!B14"
  "range" = "Configuration!B14"
  "spreadsheet_id" = "36kA4g8r2F64i67g7_13HB4d665IP4o3540opYOex3wS"
  "timeouts" = null /* object */
  "value_render" = "UNFORMATTED_VALUE"
  "values" = tolist(null) /* of list of string */
}

The expected value for values in this case would be more along the lines of this:

  "values" = tolist([
    tolist([
      "3",
    ]),
  ])

I'm happy to provide more insights if this is helpful!

Add in directory functionality from similar provider

https://github.com/DeviaVir/terraform-provider-gsuite has functionality for the directory, should merge the providers.