You can do this without writing any code in Sheets at all using the IMPORTDATA spreadsheet function, and it will automatically pull fresh data in periodically.