Although we do not have an out of the box connector specific to Google Sheets, we have found a way to connect to them using the CSV Connector.
If you publish your sheet to the web and select the CSV format, you can then use the URL generated with the CSV Connector in Data Sync.
A public URL from a Google Spreadsheet that you can try this with is here: https://docs.google.com/spreadsheets/d/e/2PACX-1vTkaHOPOH6RszCsXB-mamdr1J72ox7tHoWbCzWGIwRbkF3Ne3X2JrGTRaelt7GhdkMgzOQYdWR0pTo1/pub?output=csv
Add the URL to the FileName
textbox and click Connect
.
You can then preview the data and use it as you need to.