I am trying to create a google sheet from the answers to a google form, via a google sheet. I have created the template and the data fields are working fine, however there are several image responses and when I try to get these inserted I get the image URL rather than the image itself.
I can’t figure out why and hope it’s something simple I’m missing and that someone here can help
+6
Hi there
Welcome to the Community! 🎉
Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please send a screenshot of the “Action” section of your action step that shows all of its fields:
Please don't include personal information in the screenshot, or be sure blur out any personal information.
Thanks!
Thankyou for the response, sorry it’s taken so long to get back to you.
Hope that’s sufficient info
David
The image-link you provide in the “Create Slide” Action is not actually an image-link. It’s a link to a image saved in Google Drive, but not the image itself. Like when you enter you see the Google Drive Overlay etc, but not only the image. You need to enter in the image-url field “https://drive.google.com/uc?export=view&id={fileId}”. The fileId then is only the ID of your Google Drive Image and should be dynamic inserted from an earlier action.
Great, that makes sense
However, I still can’t get it to populate with a picture, perhaps I am doing something wrong with my template?
I have tried adding a picture via url to the template in the expectation of being able to replace with my own image when I run the zap but I don’t get the option to replace the image as and action.
I’ve also tried an image placeholder but again zap doesn’t recognise the tag
Should it be a text box with an image tag {{image}} ?
+6
Hi there
I did some digging into this, and it seems like Google Slides can only use image URLs that end with an image file extension, like .jpg or .png. Could you please try a link that ends with a file extension of .jpg or .png?
Please keep me posted!
OK.
So, the image is uploaded to drive by contributors via a google form, which populates a column with a link to the stored image. I can obviously use that link, or extract the fileid and use that with “https://drive.google.com/uc?export=view&id=” as suggested above but getting a link with the file format ending seems impossible.
I’ll have to see if there's a tool that will allow me to pull the actual image from the fileid link and then post that as an output
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
