This is a great use-case for GPT in Google Sheets. However, if you want a little more straight forward process, you can always use SheetGPT to accomplish the same thing with a free Google Sheets plugin.
I understand that’s not the point of this article, but wanted to throw it out there anyway!