Creating the data source
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 part of a company's operation, acting as a CRM, accounts payable and receivable control, inventory management, among many other purposes.
With data being entered manually into Google Sheets, it is still possible to bring the data generated there into a database that can be cross-referenced with all the other tools in your company, and run complete analyses of your business.
To do so, simply add the Google Sheets data source to the Kondado platform, following the steps below:
Adding the data source
1) Log in to the Kondado platform, 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 the 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 SAVE
Pipelines
Summary
Relationship chart
Click to expand
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 spreadsheet must be organized so that the data starts in cell "A1"
- The first line must necessarily be the header
- Pipelines will always be full
- 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 Models 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"
Replication type: Full
Parameters:
- Spreadsheet ID: Input the Spreadsheet URL and this field will auto-complete
- Tab name: Input the exact tab name to be replicated
- Spreadsheet URL: URL/link/address of the spreadsheet to be replicated
Notes
- Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information
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.
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.
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.
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.
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.
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.
