Get exif data from image and watermark exif data

[Frzn]

Hi guys!

I found a very interesting post in tutorials by @PabloMFalero

Extract EXIF information from your images in Glide

So the other day I raised a question in the community on how to extract the EXIF information from an image, I finally managed to do it with help of culinary and a little bit of code. We’ll need a webhook and then a few bits of code that I’ll paste below. Hope it all helps: https://www.loom.com/share/e5310c5799564de68a0c6953a1f5e0c4 You can find all the information here: Admin API Reference | Cloudinary Here’s the cUrl code that you have to paste in your HTTP module, in the URL section: http…

I would like to apply this to an uploaded photo and then watermark it with the date the photo was taken.

i found an other topic that mentioned it was possible to add water marks.

Watermarks on photos

Is it possible to add watermarks on photos ? We can even add a “glide” watermark or our own logo. Small in one corner for Advertising Big and centered to prevent copying: [Capture d’écran (146)]

@Robert_Petitto mentioned it was possible, but i just cant figure it out.

Could someone explain to me how i could set this up?

Thanks,

Joey

[ThinhDinh]

You can read this tutorial from Cloudinary. Basically it’s an overlay on your image and can be constructed using a template column.

Adding Watermarks, Credits, Badges, and Text Overlays to Images

[Frzn]

Thank you, This explains how to watermark my image perfectly.

However im still struggeling, i have no clue how to construct an url to fetch my image from my sheet and send to to cloudianry.

I would like to automate the process,

Upload img> send it to cloudinary > watermark image exifdata > return it to watermarked column.

Thanks!

Edit:
I made a template column with the following:

https://res.cloudinary.com/<User’s cloud ID>/image/fetch/[IMG]

Replacements [IMG] → “Uploaded foto column”

This creates the fetch url and it seems to work, now im just stuck on how to get the exif data to water amrk on the image

[ThinhDinh]

You don’t necessarily have to upload it to Cloudinary. Do you have a fixed watermark to apply on every image?

[Frzn]

I figured out how to make the watermarking work for the most part now:

https://res.cloudinary.com/<User’s cloud ID>/image/fetch/g_south_east,l_text:Arial_100:[TXT],x_30,y_30/[IMG]

[IMG] > uploaded IMG
[TXT] > Exif data

This is giving me the results i want.

Now i need a way to extract exif data from the fetched image and put it into the column [TXT] is referring too.

that way it will display the date and time the image is taken.

thanks for the quick response

[ThinhDinh]

Yes, that seems like the right Cloudinary structure.

What exact info do you want from the EXIF? I think you can pass it through an external service and retrieve that to your Google Sheets.

[Frzn]

Date and time the photo was taken.

It most likely requires some code, but that’s where i’m lost.

I’m still very new to Glide and i’m not fully understanding what type of fields / code i should be using.

My understanding was that the Cloudinary’s Admin API could do this for me.
But i do not understand what type columns i should be using for this…

Extract EXIF information from your images in Glide

So the other day I raised a question in the community on how to extract the EXIF information from an image, I finally managed to do it with help of culinary and a little bit of code. We’ll need a webhook and then a few bits of code that I’ll paste below. Hope it all helps: https://www.loom.com/share/e5310c5799564de68a0c6953a1f5e0c4 You can find all the information here: Admin API Reference | Cloudinary Here’s the cUrl code that you have to paste in your HTTP module, in the URL section: http…

Thanks for the fast response once again!

[ThinhDinh]

I had a quick look, seems like you can upload the image to Cloudinary and get the info you want.

API for Extracting Semantic Image Data - Colors, Faces, Exif Data, and More

So the steps in an automation service like Integromat would be:

• Add a webhook as an initiator node.
• Copy that webhook URL to a webhook action inside Glide. Let’s name that “image URL”.
• Initiate a webhook post request from Glide using the action above, in Integromat, click “re-determine data structure” to catch the webhook and construct the data structure.
• Add a second node in Integromat, using Cloudinary to upload the URL you have retrieved through the webhook.
• Add a third note in Integromat, this time using a Google Sheets search row node, search for the row that contains the original image URL you passed through the webhook.
• Add a final node in Integromat, update the row found with the date & time EXIF from Cloudinary.

[Frzn]

Okay, i think i understand what im supposed to do.

im gonna give it a shot!

Thanks again for the help!

[Robert_Petitto]

For watermarking, I find using quickchart much more user friendly:

https://quickchart.io/documentation/watermark-api/

Use a construct URL column to craft the watermarked image.

[Frzn]

Thanks for the information!

I’ve been looking at quickchart as well.

However it seems the watermark has to be an image, i want it to be text that i pulled from a column.
Also the orginal post that gave me the idea mentioned the Admin API by Cloudinary, so i figured i might as well use the same platform for everything.

I’ll be using quickchart for normal watermarking with images.

Thanks again!

[Frzn]

Got it working!

Thanks alot for your help.

Buddy of mine mentioned there is a camera app that could have done this…

But i dont think there is a way to add more app options to the file picker then camera, camera(video), file manager is there?

if there is i would love to know more.

Thanks alot so fa r for all the help!

[ThinhDinh]

@Frzn

But i dont think there is a way to add more app options to the file picker then camera, camera(video), file manager is there?

By camera app, do you mean the ability to add another file type?