Warehouse
Sources
Data Management
Reporting
User management
Guides
Deprecated
Google Sheets
Syncing your Google Sheets can be useful for various cases
- Importing "offline" data to Whaly (Salaries, Offline Marketing Spent, ...)
- Importing static data to Whaly such as wages
- Importing data that are not available as a direct connector in Whaly
- Sheets: We sync all your sheets and we will create a dataset for each sheet
- Sheet Row Data: For each sheet, Whaly will sync all of the row data as it has been inserted in the spreadsheet.
The Google Sheet connector is only syncing native Google Sheet documents.
If your Spreadsheet is in the XLSX format (you see a green tooltip next to the spreadhseet name), you have to save it as a Google Sheet firstly. To do so, go yo File > Save as Google Sheet.
We consider that the first line is the header of your data. Meaning that if you input data such as
You'll get 3 columns respectively named id, test and toto.
Whaly connector use the values in the first data row to infer the type of the column.
If the first row of the data contains an empty cell for a column, Whaly will infer that the column is a STRING.
An example of a spreadsheet structure that work is here: https://docs.google.com/spreadsheets/d/10H-1y5JPq7nFNGKvV1cdOm8A9QJsuYwmk3-biPmzIrU/edit#gid=1639896517
Gotta catch'em all!
How to connect?
On the catalog page, click on the Google Sheet card.
In the next screen, enter your google sheet url:
Your Google Sheets url looks like : https://docs.google.com/spreadsheets/d/[Spreadsheet ID]/edit#gid=0
Last modified 2mo ago