How to access new ‘in-cell-image’ from google apps script?

by

Answer:

This is a new feature and unfortunately at current there isn’t a method to be able to get an image inserted into a Cell this way using Google Apps Script, nor using the Sheets API.

More Information:

Attempting to get the data in a cell using the spreadsheets.get method with the following parameters

  spreadsheetId: "ID of private spreadsheet created in Drive"
  includeGridData: True
  ranges: D7
  fields: sheets/data/rowData/values

Will return a 200 response, however the image data is not returned:

{
  "sheets": [
    {
      "data": [
        {
          "rowData": [
            {
              "values": [
                {
                  "userEnteredValue": {},
                  "effectiveValue": {},
                  "effectiveFormat": {
                    "backgroundColor": {
                      "red": 1,
                      "green": 1,
                      "blue": 1
                    },
                    "padding": {
                      "top": 2,
                      "right": 3,
                      "bottom": 2,
                      "left": 3
                    },
                    "horizontalAlignment": "LEFT",
                    "verticalAlignment": "BOTTOM",
                    "wrapStrategy": "OVERFLOW_CELL",
                    "textFormat": {
                      "foregroundColor": {},
                      "fontFamily": "Arial",
                      "fontSize": 10,
                      "bold": false,
                      "italic": false,
                      "strikethrough": false,
                      "underline": false
                    },
                    "hyperlinkDisplayType": "PLAIN_TEXT"
                  }
                }
              ]
            }
          ]
        }
      ]
    }
  ]
}

Feature Request:

There is however a Feature request for this on Google’s Issue Tracker which you can find here. If you head over to the feature request page and click the star in the top left, you can let Google know that you also would like this feature, and will automatically get updates about its progress.

More Related Contents:

  1. Determining the last row in a single column
  2. Moving google apps script to v8 file upload stopped working from sidebar
  3. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  4. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  5. Google Sheets OnEdit() – You do not have permission to call a service
  6. How to define global variable in Google Apps Script
  7. Periodically refresh IMPORTXML() spreadsheet function
  8. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  9. Format a Google Sheets cell in plaintext via Apps Script
  10. UiApp has been deprecated. Please use HtmlService instead
  11. Google app scripts: email a spreadsheet as excel
  12. Is there a way to keep two sheets synchronized?
  13. Selecting the last value of a column
  14. Moving Files In Google Drive Using Google Script
  15. onEdit simple trigger never seems to be triggered
  16. Protect ranges with google apps script
  17. GAS “On edit” trigger not running when edited from API
  18. Difference between getValue() and getDisplayValue() on google app script
  19. How to allow onEdit function to affect protected cell in a Google Sheet?
  20. Measurement of execution time of built-in functions for Spreadsheet
  21. Custom Functions with add-ons?
  22. How to prefill Google form checkboxes?
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment