Google Spreadsheets

Create new source application

Go to Source Data tab and Add new source application and select Google Spreadsheets application type.

If you have created already another similar Google Spreadsheets data source then you can export its definition and paste it in Import definition to create new Google Spreadsheets source application with the same parameters.

Source selection

In the next step you will need to authorize the access to your Google Drive documents and afterwards select from which Google Spreadsheets file you would like to import the data.

Selected Google Spreadsheets file should have the first row with column names and the next rows should be data rows that you would like to import.

Source columns mapping

To conduct the Source column mapping please visit Data mapping.

After mapping all necessary columns you can click Start import button. If there are any mapping errors then they will be shown and columns with errors will be highlighted. If you need to save draft of mapping then click Back to edit and confirm that you want to save changes.

Importing of source data

If source columns mapping was saved without any validation errors then Google Spreadsheets source application will be queued for background import. You will see the updated count of imported rows during the import.

You can later visit Source Data tab again and click Import button again to import the latest data from Google Spreadsheet source. During each import it will at first delete all data that were imported previously from this source and then import new data. In addition you can also click Delete data to delete imported data from this source (you need to delete imported data also if you want to change source columns mapping).

Export definition