Scheduling scripts- the scripts have to be submitted with sheet name “sheet1” otherwise after scheduling of script you will receive message with error.
This functionality is working as designed.
That is when initially the script was submitted the sheet name was selected as Sheet1.
After you have saved the file locally those changes wouldn't be intact.
To overcome this steps you would need to follow is as below.
1) When you submit the script to Foundation make sure the name of the sheet is as desired that is Price upload and then use the same name while uploading the file; this way it will consider name of sheet.
Please note that Foundation scripts works on the settings that were set when originally submitting the script.