ComingUp ComingUp
CommentPulse

CommentPulse

Posted on behalf of the maker

Is this your project? Ask us to take it down

Gallery

CommentPulse

About

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.

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.

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.

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

Comments (8)

Carlie D'Amore Carlie D'Amore 2 months ago

comment threads in spreadsheets? sounds like a nightmare. what's the backend stack?

Jerel Kuphal Jerel Kuphal 2 months ago

comment threads in sheets could save so much scrolling and confusion, especially with a crowd of 50 people.

Guido Gleason Guido Gleason 2 months ago

sounds like a nightmare with 50 people, what’s the stack? pricing seems off for that scale.

Idella Olson Idella Olson 2 months ago

comment threads in Google sheets are a lifesaver when juggling 50 opinions at once, but it can get messy.

Edwin Schmitt Edwin Schmitt 1 month ago

too many comments to sift through, how is this any different?

Maureen Paucek Maureen Paucek 1 month ago

comment threads in sheets sound like a mess with 50 people. how’s the performance with that many users?

Katelynn Kihn Katelynn Kihn 1 month ago

the comment threading feature is useful but the UI feels cluttered and could use better spacing and typography.

Isom Rodriguez Isom Rodriguez 1 month ago

comment threads in Google Sheets can get messy, but CommentPulse helps keep everything organized and easy to follow.