CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetscommentsgoogle-sheets-api
IMTheNachoMan
IMTheNachoMan

Reputation: 5821

programatically create a comment and assign it to someone in a Google Sheet

It's been a while since similar questions were asked so I thought I would try again. And, none of the existing questions speak to assigning the comment/task -- just to creating a comment.

Is it possible to programatically create a comment in a Google Sheet and assign it to someone. You can do this through the UI when you manually create a comment. If you enter an email address you can assign the comment (as a task) to them.

I know it is possible to use https://developers.google.com/drive/api/v2/reference/comments/insert to create a comment but the comment is created on the whole file, not a specific cell. And, even still, I can't find how to assign the comment.

Upvotes: 0

Views: 850

Answers (1)

Alessandro
Alessandro

Reputation: 2998

Assigning a comment it's not possible through the API. You can only create a comment with the Drive API to a specific file.

You should submit a feature request here if you need it.

Upvotes: 2

Related Questions