How to compute an MD5 hash on text?

I have a database containing numerous long texts, each with a corresponding MD5 hash. I also have these texts in a Google Sheet. My goal is to process the content in the Google Sheet when its MD5 hash differs from the one in the database.

What would be the best approach to read the text in the Google Sheet and compute an MD5 hash for it?

Hi @Nicolas_Berney ,

You can use md5 function to generate md5 hash for your string.