Ive got a spreadsheet with a load of "cell comments" using the comment tool.

I need to filter on these comments, which i understand i can not do.

My plan is to copy each of the comments out of the comment tool, and paste the contents of the comment into a blank cell in column P.

Is there an automated way i can do this ?

  • 1
    Ive also found this thread which touches on the same topic : webapps.stackexchange.com/questions/92664/… – sam Oct 21 '19 at 14:06
  • Further helpful questions: stackoverflow.com/questions/17609953/get-cell-note-value – Cornelius Roemer Oct 21 '19 at 15:23
  • 1
    Are these notes or comments in your document? Comments are still not supported by Google Apps Script. There are open issues relating to them, see question linked. Only notes can be programmatically copied with Apps Script. – Cornelius Roemer Oct 21 '19 at 15:31
  • 1
    @CorneliusRoemer These are comments not notes, it seems what i want to achieve can be done with notes, but not with comments – sam Oct 21 '19 at 15:55
  • 1
    Yes, indeed! It seems to be impossible with Apps Script (at the moment) until Google solves the issues. Not impossible in general. You could make a bot with Selenium :D – Cornelius Roemer Oct 21 '19 at 16:10

At this time it's not possible by using Google Apps Script or the Google Drive API.


Related questions in Stack Overflow

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.