Data Shuttle


Can anyone help me in this? My requirement is datashuttle should run a scheduled time (say 7 PM CST). At 6 PM CST, I have a python script that runs an SQL query and populates an Excel and saves in the OneDrive.

I have a data shuttle that picks data from an .xlsx file in my OneDrive. Now, the data shuttle is not able to pick and copy over the .xlsx file unless I go to .xlsx manually, open and save.

Can anyone help me to address this issue so that datashuttle works without me going and saving the excel manually?