Set Image To Google Sheet Cell from AI2

[TIMAI2]

This is now possible with new functions from Google

Set Image To Google Sheet Cell from AI2

[Peter]

I think Google should give you a job in their company

[MatthewHRP]

can i ask something about ur block code?

where i get the "fileId" and "sheetId"

[TIMAI2]

These are the IDs for the spreadsheet file and the image file stored on Google Drive.

To get the IDs, find these files on Google Drive, then copy the link:

Paste the link into a text editor (or a text block) and select the ID from the url

for an image file

for a google sheet

[MatthewHRP]

thanks, i tried it but this is the result

this is my block code

the app script code is the same from your code in METRIC RAT AI2 - Set Image To Google Sheet Cell

[TIMAI2]

Your request to the script is returning a google sign in url.

Have you correctly setup your google apps script and deployed it correctly ?

Create Bound Script

Deploy Script

Creations new versions of script

[MatthewHRP]

i see, my mistake is i forget to set the access for everyone, thanks for the help sir