I have some image files in my google drive folders. I have gotten their links and have put them in cells of column G of my google sheets file. they were too long so i decide to make the lookalike “image11.jpg” but hyperlinked (blue color).
now i need to get their created date by a code. code are working very fine with google drive links but not vworking with hyperlinked file names.
so please help me with a code to get created date from hyperlinked file name automatically