Try our plataform
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

Add Google Sheets as a data source on Kondado

Connect your Google Sheets spreadsheets to Kondado to integrate them with your data warehouse and other tools for complete business analysis.

1
Access Kondado and select the Google Sheets source

Log in to Kondado, navigate to add data sources, and select the Google Sheets connector to begin the integration process.

2
Authorize Google account access

Click AUTHORIZE and select the Google account that has access to the spreadsheets you want to replicate. On the permissions screen, check ALL required permissions and click Continue to proceed.

3
Name and save your data source

After being redirected back to Kondado, give your data source a descriptive name and click SAVE to complete the connection setup.

4
Configure your pipeline with proper spreadsheet structure

Copy the spreadsheet URL, select the tab to integrate, and ensure data starts at cell A1 with headers in the first row. Remember that pipelines are always full loads and the file must be a native Google Sheet—convert xlsx files via File > Save as Google Sheet.

5
Use data transformation for type conversions

Since all data is ingested as text to ensure pipeline success, leverage Kondado's Model functionality within our data transformation capabilities to perform any necessary type conversions and prepare your data for analysis.

Frequently asked questions

What types of business operations can Google Sheets support before connecting to Kondado?▼
Google Sheets commonly serves as CRM, accounts payable/receivable control, inventory management, and various other operational needs. Once connected to Kondado, this data can be crossed with all your company's other tools for complete business analysis through data integration.
Why does my data import as text and how can I convert it?▼
Kondado imports all Google Sheets data as text to ensure pipelines always run successfully without type errors. You can then use Kondado's Model functionality to perform conversions and transform your data into the appropriate types for analysis.
What happens if I change the tab name or header content after creating a pipeline?▼
Changing the tab name after pipeline creation will result in an error. You can change the column order, but modifying the content/text of the first row/header will also cause issues. These constraints ensure pipeline stability and data consistency.
Can I integrate Excel (.xlsx) files directly with Kondado?▼
No, the file must be a native Google Sheet. If you have an xlsx document, you must first convert it by going to File > Save as Google Sheet in Google Drive before it can be connected as a data source.
What permissions are required when authorizing Google Sheets?▼
You must check ALL permissions that are requested during the authorization flow. These permissions allow Kondado to access and replicate the spreadsheets that the authorized user has access to. Skipping permissions will prevent successful connection.
Where can I find pre-built reports and dashboards for Google Sheets data?▼
After integrating your Google Sheets data, explore pre-built Google Sheets reports to accelerate your analytics and visualize your spreadsheet data more effectively.
Written by·Published 2023-07-21·Updated 2026-04-25