how to upload spreadsheet to google sheets

If you need to save a draft of mapping then click Back to edit and confirm that you want to save changes.

If there will be any mapping errors then they will be shown and columns with errors will be highlighted. Google Sheets source columns mapping is similar to Excel or CSV file columns mapping and Import from REST API. Please review these documentation pages to learn more about columns mapping to eazyBI dimensions and measures.Īfter mapping all necessary columns you can click Start import.

Selected Google Sheets file should have the first row with column names and the next rows should be data rows that you would like to import. In the next step you will need to authorize the access to your Google Drive documents and afterward select from which Google Sheets file you would like to import the data. If you have created already another similar Google Sheets data source then you can export its definition and paste it in Import definition to create a new Google Sheets source application with the same parameters.

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

How to upload spreadsheet to google sheets