Hi,
The sheets content appears outside as a dataset to sync. (I don’t know if is 100% well configured, but at least it is how it shows to me):
What I did is I get the information that I need from the Sheets and Spreadsheets table (like ids and all that) and then I use code repo to download all the content that I need.
In my case is not scalable to create a data sync per sheet.
Hope it helps,
Rita