Refresh all requests on a sheet
You can run all the requests saved for a specific sheet with Awesome Table Connectors.
Open the Google spreadsheet containing the exported data and go to the sheet you want to refresh.
Select Extensions > Awesome Table > Refresh current sheet.
Each request saved in your sheet is refreshed with the same parameters as the last time it was run, and the content of your sheet is updated according to the current refresh mode.