Good opportunity to highlight Google "Apps Script" which is one of the most powerful but unknown tools in the web:
https://developers.google.com/apps-script/guides/sheets
Includes easy fetching: https://developers.google.com/apps-script/reference/url-fetc...
I suppose python could be better for this use case but javascript seems to work fine. And it's all built righ in to Google Sheets.