Comment export and audit tool for teams collaborating in Google Sheets
A developer who manages heavily commented Google Sheets (70+ threads across many tabs and up to 50 collaborators) found no built-in or third-party way to export, count, sort, or track comment threads with cell locations. He built a browser-based tool using the xlsx export plus JSZip. This is a narrow but real gap for teams that rely on Sheets comments for review and risk tracking.
他们的问题
Sheet owners and reviewers at organizations that use Sheets comment threads heavily have no native way to extract all threads with cell references, authors, timestamps, and resolved state. They manually copy-paste or lose traceability, spending hours per workbook and losing audit trails on decisions and risks.
可以怎么做
A lightweight web app or Sheets add-on that extracts all comments and threaded comments from a workbook, maps each to its cell/tab, and exports a sortable CSV/HTML report with author, timestamp, resolved status, and thread hierarchy. Could add digest summaries and unresolved-thread alerts.
适合谁做
谁在说(1)
相关话题
机会描述由 AI 整理,原话在上面「谁在说」的链接里。