Connecting to Google Sheets

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 field and click Connect.

You can then preview the data to check it is returning as expected and use it as you need to.