Does Sync with Source work with Google Sheets?

I’m trying to fetch “categories” for my tool directory from google sheets but its not syncing and I’m not able to turn on “sync with source” either. So does this option work with Google sheets or not?

Please find image attached for reference.