[Gauging Interest] Support for Google Sheets

[megan07]

Support Google Sheets

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values

[paultyng]

@megan07 you are the best!

[paultyng]

This is my existing data source, but please feel free to completely disregard and do you own thing 😄 https://registry.terraform.io/providers/paultyng/gsuite/latest/docs/data-sources/sheets_spreadsheet_values

The use case was that I swapped in a Google Sheet in places where I was previously using csvdecode for data, etc.

[briananstett]

Being able to write to Google Sheets with Terraform would be really cool. My current use case is my organization would like to keep a living document of all sites we're currently hosting that is easilly accessible to other departments.

[briananstett]

@megan07 just wondering if there's been any movement on this? Thanks for your help.

[hanneshayashi]

I know it's not the same as "proper" support for Google Sheets, but my Terraform Provider for Google Drive supports importing a CSV file as a Google Sheet with the gdrive_file resource:

resource "gdrive_file" "import_csv" {
  name             = "my_sheet"
  mime_type        = "application/vnd.google-apps.spreadsheet"
  mime_type_source = "text/csv"
  content          = "./test.csv"
  parent           = gdrive_file.folder.id
}

Maybe that helps some of you guys with a relatively simple use case.

Edit: You could potentially also export a Sheet to a CSV file using the gdrive_file datasource.

[JavierLopezT]

@megan07 I would be very interested on this