Original Summary

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&#x2F;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:&#x2F;&#x2F;github.com&#x2F;bsunter93&#x2F;commentpulse<p>It&#x27;s also live in the Google Marketplace at this link: https:&#x2F;&#x2F;workspace.google.com&#x2F;marketplace&#x2F;app&#x2F;comment_export_for_sheets&#x2F;856300539801<p>Feel free to take and use it - would love any feedback!

  • 情报分类：商业与市场研究
  • 分类依据：内容涉及商业、投资或市场动态
  • 信息来源：Hacker News 新项目
  • 发布时间：2026/9/19 12:51:01