从 Google 表格中提取所有评论
1 分•作者: bsunter2•4 天前
我花很多时间在 Google 表格上工作。通常，我会在同一个工作簿中与多达 50 人协作。我曾供职的一个特定组织非常倾向于广泛使用表格中的评论串来提问、提供反馈和提出风险。
表格经常会在多个标签页上出现 70 多个评论串，涉及数十个参与团队。作为表格的所有者，我希望有一种方法来记录这些评论，以便保留所有各种对话的可追溯性。
令我惊讶的是，表格本身并没有内置任何功能来抓取、计数、排序或管理评论。我也找不到任何好的第三方插件来解决这个问题。于是我决定自己动手做一个。
我发现 Drive API 可以提供评论文本、作者和状态，但无法提供评论的位置，而这至关重要。幸运的是，.xlsx 导出文件在 xl/threadedComments 中包含了单元格引用、时间戳、作者、已解决标志和父 ID。
它的运行方式：在浏览器中通过 JSZip 运行，无需登录，没有任何内容上传到任何地方。我正在申请该应用在 Google Workspace Marketplace 上架的验证，但在此期间，该工具可在以下网址获取：https://github.com/bsunter93/commentpulse
它也已在 Google Marketplace 上线，链接如下：https://workspace.google.com/marketplace/app/comment_export_for_sheets/856300539801
欢迎随意取用和使用——非常期待您的反馈！
查看原文
I spend a lot of time working in Google sheets. Often, I will collaborate with up to 50 other people in the same workbook. One specific org I worked at had a strong preference for using comment threads in Sheets extensively to ask questions, give feedback, and raise risks.
Sheets would regularly get 70+ comment threads across multiple tabs with dozens of contributing teams. As the owner of the sheet, I wanted a way to document the comments to retain traceability on all of the various conversations.<p>To my surprise, there was no function built into sheets to scrape, count, sort or manage comments at all. I also couldnt find any good third party add-ons to solve the problem. So I built one myself.<p>I discovered that the Drive API gives you the comment text, author and state, but doesnt give the location of the comment which was crucial. Thankfully, the .xlsx export has xl/threadedComments with the cell reference, timestamp, author, resolved flag and parent ID.<p>How it runs: JSZip in the browser, no sign-in, nothing uploaded anywhere. I am in the process of having the app verified to be hosted on Google Workspace Marketplace, but in the mean time the tool is available at: https://github.com/bsunter93/commentpulse<p>It's also live in the Google Marketplace at this link: https://workspace.google.com/marketplace/app/comment_export_for_sheets/856300539801<p>Feel free to take and use it - would love any feedback!