Welcome to the community, @Maurine_Genillier!
But the easiest, quickest, no-code way of doing this would be to use an external automation tool like Integromat to take care of this for you. Integromat has full Google Drive functionality:
However, even though Integromat is a no-code platform, there is quite a steep learning curve If you’ve never used it before. So it could take you many hours of setting up & configuring everything correctly in Integromat. Once it’s setup correctly, though, it should work flawlessly forever — even for any new photos in the future.
If you have a budget for this project and would like to hire a professional Airtable consultant and a Registered Integromat Partner to help you with this, feel free to contact me at my website scottworld.com. (The Integromat link above contains my personal referral code.)
You could probably pull this off with Zapier as well, but they have limited Airtable support so I wouldn’t want to send you down that path unless there was some compelling reason that you really needed to use Zapier. Zapier is also more expensive than Integromat.