Best Of

Data Shuttle looks for a file by name in OneDrive. What I would do is use Power Automate to stage the file for Smartsheet to pick up, and then either delete it or overwrite it with the new file the next week. As long as Data Shuttle runs once a week, and the file is there and has the same name each time, Data Shuttle will pick it up.

Try this for the Row ID in the Get Row module:

{{runtime.event.rowId}}

Notice the end is "Id" with a lowercase "d". It is case sensitive but understandably frustrating when the "sheetID" is a capital "D". I always suggest going into the run-log and copying the reference from there to help avoid this.

@nadimsobhani , a solution we use is to:

1. Download the sheet on a schedule to a SharePoint location
2. Run a python script using task scheduler to rename the file.

We use a server synced to SharePoint using OneDrive and to run a BAT file that triggers the python script. The code below will need some tweaking.

BAT file

This file is triggered by Windows task schedule

@echo off

python path\to\your\script.py

Python file

This file contains the python code to rename the file.

import os

from datetime import datetime




# Specify the file you want to rename

original_file = 'example.txt'



# Get today's date in the desired format

today_date = datetime.now().strftime('%b %d %Y')



# Create the new file name

new_file = f"{os.path.splitext(original_file)[0]}_{today_date}{os.path.splitext(original_file)[1]}"



# Rename the file

os.rename(original_file, new_file)


print(f"File renamed to: {new_file}")

Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology