Google Sheets

Google Spreadsheets is an online spreadsheet creation, editing and sharing tool created by Google as an alternative to the famous Excel.

It is common to see Google Sheets playing an important role in at least one of the parts of the companies' operation, being able to impersonate CRM, control of accounts payable and receivable, inventory management, among the most diverse purposes.

With the manual input of data being done in Google Sheets, it is still possible to take the data generated in it to a database crossable with all the other tools of your company, and perform complete analyzes of your business.

To do so, simply add the Google Sheets data source to Kondado's platform, following the steps below:

Adding the data source

1) Login to Kondado, go to add data sources and select the Google Sheets data source

2) Click AUTHORIZE

3) Select the account you will use

4) On the next screen, check ALL permissions that are required and click Continue

5) You will be redirected to Kondado and all you have to do is give your data source a name and click on SAVE

Pipelines

Relationship Chart

Gráfico de relacionamento entre tabelas

Spreadsheet

You can replicate any spreadsheet that the user who registered the data source at Kondado has access to. Just copy the spreadsheet URL and select the tab that will be integrated

Pay attention to the following:

The worksheet must be organized so that the data starts in cell “A1”
The first line must necessarily be the header
Pipelines will always be integral
After creating the pipeline, changing the name of the tab will result in an error
After creating the pipeline, the column order can be changed, but not the content/text of the first line/header
To ensure your pipeline is always successful, data will always be entered as text and you can use our Model functionality to perform conversions
The file must be a Google Sheet, if it is an xlsx (Excel) document for example, you must convert it to a Google Sheet with “File > Save as Google Sheet”

The structure of the created table will be similar to:

Field	Type
col_x	text
col_y	text
col_z	text