Help

Re: Need Help with Image Embedding in Google Slides via Make from Airtable URLs

2547 0
cancel
Showing results for 
Search instead for 
Did you mean: 
cshenoy86
7 - App Architect
7 - App Architect

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.

cshenoy86_0-1705312623073.png

This is the template

cshenoy86_1-1705312662539.png

And here is the settings of Upload Image module

cshenoy86_2-1705312687626.png

 

The url that I obtain from the previous module looks like this

cshenoy86_3-1705312715776.png

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.

 

cshenoy
10 Replies 10
ScottWorld
18 - Pluto
18 - Pluto

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

airtable #on2air #builtonair 11/7/2023 - BuiltOnAir Live Podcast Full Show - S16-E06 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel
cshenoy86
7 - App Architect
7 - App Architect

I need that repeater because in every single ppt presentation, I want no more than 6 logo images.

cshenoy86_0-1705321122753.png

Also sharing a screenshot of how the URL is being pulled.

cshenoy86_1-1705321453834.png

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. 

cshenoy

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!

ScottWorld
18 - Pluto
18 - Pluto

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?

Note: The images must be less than 50MB in size, cannot exceed 25 megapixels, and must be in one of PNG, JPEG or GIF format.

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?

cshenoy

That is very likely the reason!

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.

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. 

cshenoy

Wow, that’s a great discovery! Can you please report that to the Make team for them to investigate?