PipedreamHQ/pipedream

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

Open

#18185 opened on Aug 26, 2025

View on GitHub
 (4 comments) (0 reactions) (1 assignee)JavaScript (7,438 stars) (5,305 forks)batch import
actionenhancementgood first issuehelp wantedtriaged

Description

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

Contributor guide

Tech stack
javascriptnodejs
Domain
api
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
blocked
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
JavaScriptNode.jsGoogle Drive API
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
30
Research direction
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').