Data Shuttle not pulling in new rows from source sheet
I have a Data Shuttle workflow that I set up that has been working for 4 months, but for the past few weeks, has not been picking up rows that should be added to the Target sheet. Any ideas why it suddenly stopped working?
The source file is saved in Box (I've verified/reconnected by Box account). There are 96 rows in my target sheet currently, but should be 99 based on the source sheet.
I've selected to merge data and add rows (we often make updates after the rows are added, so don't want to use the Update option)
No filters set:
Columns are all mapped. I refreshed just in case we had renamed a column recently and also forced the column type in most instances. The Row IDs are unique, I double checked in our Target sheet that the missing rows are not included anywhere.
The workflow is scheduled to run every hour, and each hour it does run, but does not update anything
Here are the workflow results:
The first three rows in the screenshot below are the ones missing, the 4th one worked when the row was added to the source sheet:
Any ideas on what I could adjust to make this work?