search

turbot / steampipe-plugin-googlesheets

Use SQL to instantly query spreadsheets, sheets, and cell data from Google Sheets. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/googlesheets
Apache License 2.0
31 stars 0 forks source link

Add table googlesheets_comment #5

Closed cbruno10 closed 1 year ago

cbruno10 commented 2 years ago

You can currently get comments through the https://developers.google.com/drive/api/v2/reference/comments/list?apix_params=%7B%22fileId%22%3A%221xwxQLmNdLBFvIcPf-8c5MJB3K8A9YTCu96OWoFwrKKE%22%2C%22includeDeleted%22%3Afalse%7D, but there's no way to tie it back to a specific cell in a sheet that I can find at the moment.

There is the anchor field that has data like:

"anchor": {
    "type": "workbook - range",
    "uid ": 0,
    "range ": "424925224"
}

But I'm not sure what range ties back to.

github-actions[bot] commented 1 year ago

'This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

github-actions[bot] commented 1 year ago

'This issue was closed because it has been stalled for 90 days with no activity.'