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

URL into CSV Connector

You can then preview the data and use it as you need to.