Google Sheets Load
This load type enables loading of data to a Google Sheets using a Google Sheets connection.
Settings
Data Source | Source for the load |
Target connection | An existing Google Sheets connection. |
Header | If set, the load will include the first line of the source. |
Mode | Create
|
Update
|
|
Add
|
|
Start cell | If set, the data is written in the workbook to a range with this starting cell. Default value: A1 |
Notes
- When dealing with large data sets, data is loaded in batches of 50,000 rows at a time.
- Google Sheets has a limit of 10 million cells in a spreadsheet. This is a limitation of Google Sheets, not Jedox.
Updated July 8, 2024