How to get data in Google spreadsheets from a site with a drop down list?

Question

HTML

Good afternoon! I want to create for myself in a convenient form a table of competitive places for universities. Decided to tinker with this a little. But I can’t get data from the site, because before showing the final table, it offers to select faculties from the list, and then, as I understand it, I send an XHR request with the faculty I need and the site gives me this list. I can't figure out how to implement this in Google Sheets. Here is the site itself: https://mospolytech.ru/index.php?id=2339 And several XHR requests are sent. Which one of them is responsible for the table - has not been determined. Please help! Climbed the entire Internet - either too incomprehensible (since I just started to be interested in this), or just simple parsing without lists

Answer 1

Most likely Google Sheets will not help you here. Try picking a simpler project to start with.