PipedreamHQ/pipedream

[ACTION] add anchor prop into existing`google_sheets-insert-comment`

Open

#18,185 建立於 2025年8月26日

在 GitHub 查看
 (4 留言) (0 反應) (1 負責人)JavaScript (7,438 star) (5,305 fork)batch import
actionenhancementgood first issuehelp wantedtriaged

描述

Is there a specific app this action is for? google_sheets-insert-comment

Want to leave a comment on a specific cell (e.g., AW437) and tag a teammate (e.g., shuwn@runbear.io) so they receive a notification.

When we check this using the google_sheets-insert-comment, the comment is created at the file level (not cell-anchored). The mention notifies the user correctly, but the comment is not attached to the requested cell. https://github.com/PipedreamHQ/pipedream/blob/master/components/google_sheets/actions/insert-comment/insert-comment.mjs

Please provide a link to the relevant API docs for the specific service / operation. https://developers.google.com/workspace/drive/api/reference/rest/v3/comments#create

貢獻者指南

技術棧
javascriptnodejs
領域
api
議題類型
feature
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
1-3 hours
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
blocked
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
JavaScriptNode.jsGoogle Drive API
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
30
研究方向
Review the current insert comment action at the linked file (https://github.com/PipedreamHQ/pipedream/blob/master/components/google sheets/actions/insert comment/insert comment.mjs). Understand how it uses the Google Drive API to create comments. Look at the API documentation for comments.create to see how to add an anchor property. Modify the action to accept an optional anchor parameter and pass it in the request body. Ensure the anchor format matches the expected cell notation (e.g., 'A1').