Getting images to show up in a google sheet instead of the URL

Answered

I have a zap set up to create a new row in my spreadsheet every time someone finishes an app. We have a lot of photo fields and they all come over as URLs. It would be a lot easier if we could see the real image instead of having to click on it. Is there a way to do this? Is it a problem with Google sheets? Or a setting I'm missing in zapier? 

1

Comments

6 comments
Date Votes

Post is closed for comments.

  • Official comment

    2024 Update:

    The Community is getting cleaned up! If you are stumbling across this post after September of 2024, this is the most recent solution or answer to the request in this post.

    The solution Sara provided below is two-fold. First, turn on Unsecured Access for the photo fields in the Builder. Second, in your Zap, add the formula =image(" BEFORE the token for the photo URL followed by "). You can also specify the size you want the image to be (learn more about that here).

    To learn more, visit the Help Center article, "What is the Unsecured Access setting in the Builder?"

  • Hi Amy,

    In most cases, yes, you can make some changes that will allow you to view the actual image instead of the URL. It's more of an excel/google sheets trick than anything else. Here's what you need to do: 

    1. In either Builder, Legacy is shown below, make sure that your photo fields are set to allow Unsecured Access (open up the more tab, and check the first box): 



    2. In your Zap, add the formula =image(" BEFORE the token for the photo URL followed by "). You can also specify the size you want the image to be (learn more about that here). 

    That should do it! 

    0
  • Is there any way to get this to work with Business Insights?

    0
  • Hi Estel,

    I think there's a way to do it using some excel macros (not my area of expertise, unfortunately). I'll ask around and see if someone has something working for them.

    0
  • Is there a way to do this for a signature field? The unsecured access option does not exist for this field type. We are trying get the signature picture as opposed to a link into a Google Docs via Zapier.

    0
  • Hey Grant,

    There is a way to set unsecured access, but it has to be done by someone on our team. Feel free to put in a ticket with our Support Team and they can do that on an App-by-App basis for you. Then it's the same instructions as above. 

    Thanks!

    (Edited )
    0

Didn't find what you were looking for?

New post