Our Google Sheets destination allows you to replicate your data into existing spreadsheet tabs, making accessing your data simple and inexpensive.

Below we will explain how our Google Sheets destination works and how to add it in Kondado.

1. Which spreadsheet will be used

In the “Spreadsheet” parameter, you can choose to use an existing sheet or let Kondado create a new sheet in your Google Drive (default):

If Kondado creates a new spreadsheet, the URL of the spreadsheet will appear on the destination page as soon as the spreadsheet is ready (just update it) and you will also receive this URL by email and in our notification area (bell at the top right).

If the worksheet that will be used is already created, it needs to be owned or shared (with editing permissions) with the user who will authenticate the destination. It must be a Google Sheets spreadsheet and not an Excel file from Google Drive – in this case the excel must be converted to Google Sheets. The spreadsheet URL to be inserted must be in the format “https://docs.google.com/spreadsheets/d/8jiaosd8h0in12eas” – note the beginning of this format, which identifies that it is a valid Google spreadsheet and not another Google Drive file type.

2. Creating the destination

1. On the Kondado platform go to Destinations > New Destination > Google Sheets

2. On the landing page, press the blue button “Sign in with Google”

3. On the authorization page, select ALL required permissions and then click “Continue” (Continue)

4. You will be redirected back to Kondado and will see that the authentication has already taken place. Follow the steps below to fill in the missing information

• At the top, name your destination – this is an internal description only, so name it something you'll remember
• At the bottom, if you choose to use an existing spreadsheet, fill in the URL of the spreadsheet. The URL of the worksheet is in your browser's address bar when you access the worksheet you will be using
• If you choose to keep the default and let Kondado create a new spreadsheet, the URL will be sent to your email, to your notification area in the bell located at the top right and will also be available on the destination page as soon as possible. are ready

Now just click SAVE and don't forget to test your connection before creating your pipelines

3. Limits of Google Sheets and how to use the spreadsheet

Once the destination has been added according to the steps above, you can use it. In this section we are going to talk about some known limitations of google sheets, how our integration works and some necessary precautions with the sheets that we will create. All this in the form of a list so that it is easy for us to refer to these same points in the future and in your interactions with our service.

1. The maximum number of cells (counting columns x rows) in a Google Sheets file is 10 million, adding up all tabs. If your spreadsheet exceeds this or during an integration it is identified that the data load will exceed this, your integration will not be completed and will be disabled
2. The maximum number of columns in the same tab is 18278 (column ZZZ)
3. The name of the tabs must have memos than 50 characters
4. The limit for the number of characters in a cell is 50 thousand – your data will be truncated if it exceeds this amount
5. The Kondado integration will always create the tab to be used after creating/advanced editing of the integration in the spreadsheet. If the tab already exists, it will be deleted to be recreated later – this is something that is warned to the user in our UI
6. The tab used by Kondado will always start in cell A1 and use line 1 as header
7. Data written by Kondado must not be altered – this also includes column order and header – this is because Kondado does not store data with it longer than necessary to complete a merge (read, write and forget). So, with each incremental integration, we only read new and updated data and send it to your spreadsheet, considering the data already there as the only kept copy of the result of the integration.
8. Tabs created by Kondado must not be deleted or renamed - if this happens the integration will fail
9. You can use the columns after the Kondado data to apply formulas and etc., but the lines below the data will be deleted if used.
10. During integration, the range used by Kondado may be empty for a while until we finish writing the data
11. Models do not apply to this destination.
12. Delta tables do not apply to this destination
13. Excel spreadsheets (xlsx) must be converted to google sheets before use
14. The spreadsheet should not be filtered