Syncing the data automatically from the Sheet to the Content Manager would be dependent on the capabilities of the Google Sheets environment. You’ll need to check with Google to see if their API and environment supports events and scripting. If so, you can expose a site API using HTTP functions that would accept fetch requests from Google and update your collections in the Content Manager.