Add image into Gsheet

Yep, i use the single quote, but why the image don't show?
If you open che Sheet in R44 there is only fomula not image.

Can you see/view the image on google drive ?

Yes, i see the image.

and your responseContent in label3 was:

Image Uploaded: 1_jU2wiVP4Fo89zsSg_aaLjsyFH_CSAep

??

(I checked in case it was the merged cells, but that also works)

Yes, in the label3 i have the same ID into R44 cell.

I see the cell goes grey when you tried again. Is the image grey?

Can you make your images readable in google drive so I can check?

Can you try manually adding an image to a cell with the same formula (don't just copy)?

mmm i try...
There is a problem, the file created is two.
Why? I want to save canvas in drive and and the saved image must go to cell r44.


Yes, you probably need to tidy up your blocks so that you are only uploading one file.

You still need to give access to you images so that I can see them (anyone with the link can view)

this is the link: UPloadDrive - Google Drive

I save the image here when created.

Now it works, but I don't know why.

Seems the image function cannot access private files - I get the same here - not sure why this is, but probably due to some crossover issues between Drive and Sheets.

From the image function documentation:

IMAGE

Inserts an image into a cell.

Important: You can only use URLs that aren't hosted at drive.google.com.

which is odd, given that it does work with images that are anyone with the link

I have emailed a Google Sheets guru about this....

I ran tests.
The image is displayed only if the folder that contains it is shared.
Therefore now the image is seen in the sheet.
As for the creation of the "double file", your script already creates a file inside the folder for this I had two.

This makes the images shared as well - which is what is needed.

Hola @TIMAI2 buen día
Con esta ayuda logré guardar el lienzo a drive, ahora necesito tu apoyo para poder pasar la imagen, id, y filename a sheets, estoy tratando de guiarme pero ya me perdí por completo.

Me podrás ayudar please.

Your problem could be:

  1. In your blocks the creation of a valid base64 string
  2. In your blocks the correct blocks in the correct places
  3. In your google apps script
  4. In your google drive / folders and their permissions
  5. In your google sheet

Hola @Alex_Benetti Puedes apoyarme, no logro pasar la imagen a sheets por favor

Did you not see my previous post ?

Your problem is somewhere, but we do not know where. You have only shown some blocks, there is much more to show, and for you to test, in order to get this working.

Muchas gracias @TIMAI2 simplemente el error estaba en que el Script era desde Google, yo vinculaba un Script creado desde la hoja sheets :sweat_smile:

Muy agradecido mi estimado!!