Pull every comment out of a Google Sheet, in the browser

About Pull every comment out of a Google Sheet, in the browser

Google Sheets keeps comments where you can

In the maker’s words

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 wi…

Where people found it

• Hacker NewsShow HN: Ripple: See what an event changed downstream, with every link graded1 points0 comments5 days ago
• Hacker NewsShow HN: Pull every comment out of a Google Sheet, in the browser7 points1 comments26 days ago