Google Sheet not displaying images stored in Google Drive

Hey everyone, I’m having trouble with my Google Sheet. I’ve got some pictures saved in my Google Drive, but they’re not showing up in the sheet. Instead, I just see the folder name and image name.

These images were uploaded through APPSHEET, and I really need them to be visible in the Google Sheet. I can see the files in my Drive, but for some reason, they won’t display in the sheet.

Has anyone else run into this issue? Any ideas on how to get the images to show up properly? I’ve tried refreshing the sheet and double-checking the file permissions, but no luck so far.

Any help would be much appreciated. Thanks in advance!

I’ve encountered this problem before when working with AppSheet and Google Sheets. One solution that worked for me was to use the IMPORTIMAGE function instead of relying on direct linking. Here’s what you can try:

In the cell where you want the image to appear, use the formula:

=IMPORTIMAGE(“https://drive.google.com/uc?export=view&id=YOUR_FILE_ID”)

Replace YOUR_FILE_ID with the actual ID of your image file in Google Drive. You can find this in the URL when you open the image in Drive.

This method bypasses some of the permission issues that can occur with direct linking. Just make sure your images are set to ‘Anyone with the link can view’ in Drive settings.

If this doesn’t solve it, you might need to check your AppSheet configuration to ensure it’s correctly setting up the image links when saving to the sheet. Hope this helps!

I’ve dealt with this issue in my projects before. One thing to check is the image file format. Google Sheets sometimes has trouble displaying certain formats. Try converting your images to PNG or JPEG if they aren’t already.

Also, make sure you’re using the correct URL format for the images. It should look like this:

https://drive.google.com/uc?export=view&id=YOUR_FILE_ID

Replace YOUR_FILE_ID with the actual ID from your Drive link.

If that doesn’t work, you might need to adjust your AppSheet setup. There could be an issue with how it’s saving the image links to your sheet. Double-check your app’s configuration and make sure it’s outputting the correct URL format.

Lastly, verify that your Google account has enough storage space. Sometimes, image display issues can occur if you’re close to or over your storage limit.

hey sophialee, had similar issues b4. try inserting the images using =IMAGE() function. paste the file URL from Drive into the formula. make sure cell size is big enuff. if that doesn’t work, check if ur Drive sharing settings allow access to the sheet. Good luck!