0

I have a drawing on a sheet that I use to indicate its a draft copy. When appropriate, this drawing needs to be removed.

Is it possible to remove a drawing using Google Sheets API?

i.e. the equivalent of this in google apps script, but using Sheets API:

SpreadsheetApp.openById(SHEET_ID).getSheets()[0].getDrawings()[0].remove();

Many thanks in advance

Improve this question
3
  • AFAIK Google Sheets API does not provide a direct method for manipulating drawings or shapes within a spreadsheet. The Google Sheets API primarily focuses on reading and writing cell-based data. Have a look at Google Apps Script service if you want to programmatically manipulate drawings or shapes in a Google Sheets document. Commented Dec 23, 2023 at 14:25
  • Thanks for the reply - the code I've used as an example is google apps script. Ideally, I would like to achieve this in Sheets API, but perhaps it isn't possible Commented Dec 23, 2023 at 14:49
  • About Remove a drawing using Google Sheets API, in your situation, do you want to achieve this from outside of Google? If my understanding is correct, I think that the Web Apps created by Google Apps Script can be a workaround for achieving this. But, I cannot know your actual situation from your question. If my guess was not correct, I apologize. Commented Dec 24, 2023 at 0:27
Related questions
20
Insert image into Google Sheets cell using Google Sheets API
7
What is difference between Google Sheets script and Google Sheets API?
1
Duplicate whole spreadsheet using Google Sheets API
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.