Jan 15, 2024 02:02 AM
Hello everyone,
I'm currently working on an automation project where I'm facing a challenge with embedding images into a Google Slides presentation. I am using Make to lift the images from airtable and replace the placeholders in Google Slides template. I am able to pull in all the text information but have hit a roadblock with the image embedding part.
Here is the issue:
* I have a Google Slides presentation with placeholders for images.
* My Integromat scenario successfully retrieves image URLs from an Airtable base.
* The URLs are accessible and lead to a download option for a `.png` image when opened in a browser.
* However, these images are not being uploaded or embedded into the Google Slides presentation.
Sharing a screenshot of my Make scenario.
This is the template
And here is the settings of Upload Image module
The url that I obtain from the previous module looks like this
It seems the URLs might not be in a format that Google Slides can embed directly, possibly because they initiate a download rather than displaying the image directly in the browser. Any advice on how to approach this? Alternatively if anyone has tips on URL manipulation within Make/Airtable , please do share your suggestions. Is there a formula to retrieve a image url with a filename at its end?
Thanks in advance.
Jan 15, 2024 04:06 AM - edited Jan 15, 2024 04:43 AM
It doesn’t look like your scenario is setup properly (and you probably don’t need that repeater module), but I can’t specifically tell you how to cleanup the scenario without playing with it myself.
In the meantime, I give a demonstration on working with arrays in Make in the context of Airtable attachments on this Airtable podcast episode:
https://youtu.be/sKPyG0HZCYY?list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1
Jan 15, 2024 04:19 AM - edited Jan 15, 2024 04:25 AM
I need that repeater because in every single ppt presentation, I want no more than 6 logo images.
Also sharing a screenshot of how the URL is being pulled.
I used the same script for a mailchimp campaign as well (minus Google slides of course) and the images are being pulled correctly. Even here all the other details like name, website, description etc is being pulled correctly. The issue is only with images.
Jan 15, 2024 04:22 AM
Hmm… the exact same scenario sent the images correctly to other modules, but not to Google Slides? If that’s the case, I would open a support ticket with Make and be sure to report back here with what they say!
Jan 15, 2024 04:37 AM - edited Jan 15, 2024 04:39 AM
p.s. I just noticed this note on the documentation page for Make’s Google Slide modules — does any of this apply to your situation?
Jan 15, 2024 04:38 AM
I have added the same query in Make community as well. Waiting for their response. Thanks for the suggestion!
I even checked the constraints. The image is max 20 kb , so well under the mandated 50 MB, is around 200 pixels (again under 25 megapixels) and in the png format. However when I check the url, I don't see it ending in the png format. Is that possibly the reason? Is there a formula that gives the url with a file name ending?
Jan 15, 2024 04:40 AM
That is very likely the reason!
Jan 15, 2024 04:42 AM
I think that Airtable automatically includes the extension if the original file had the extension, but I’m not sure. I’m not at my computer right now to verify this.
Jan 15, 2024 08:29 AM
I tried a workaround. I replaced all tags with placeholder images and then used a 'Get a Presentation' module to retrieve the object details. I finally used 'Upload an Image by replacing an image' in the Upload Image in Presentation module. And it worked. Looks like the tags aren't been recognised.
Jan 15, 2024 08:39 AM
Wow, that’s a great discovery! Can you please report that to the Make team for them to investigate?