Skip to main content
Best answer

Inserting a file image in a Google Sheets cell


jessie8o8

I am success in finding the the file from google using “Find a File in Google Drive” Zap. I am trying to use “Create Spreadsheet row in Google Sheets” Zap and inserting [File: (Exists but not shown)] in one of the field. 

When tested it uploads a zapier link to the image, not the image itself. 

Please advise

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @jessie8o8 

You’ll want to use the Web Content Link from GDrive for the file.

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7457 replies
  • June 12, 2023

Hey there @jessie8o8, welcome to the Community! 🙂

I did some checking and it looks like you’d need to use Google Sheet’s IMAGE formula in order to embed the image into the cell. The formula looks like this =IMAGE(“IMAGEURL”)

Using it in the Zap would look something like this:
1798321e9ee5f5265d936b91408c6f23.png

By default the formula will set the image to fit the cell but there are ways to change it’s sizing and how it fits within the cell. You can find out more about how to do that here: https://support.google.com/docs/answer/3093333?hl=en-GB

 

Hope that helps. If you run into any issues in setting that up just let us know! 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30919 replies
  • Answer
  • June 12, 2023

Hi @jessie8o8 

You’ll want to use the Web Content Link from GDrive for the file.