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
  • Create mode only works with the Google Sheet name. The connection cannot have a Google Sheet ID configured.
  • If there are several Google Sheets with the same name, a warning appears and the first spreadsheet found will be used.
  • If the spreadsheet already exists, it is removed and a new spreadsheet is created.
  • If the spreadsheet doesn't exist, a new spreadsheet is created.
Update
  • The spreadsheet is created if it doesn't exist.
  • If the spreadsheet exists, and the sheet doesn't exist, a new sheet is created with the sheet name specified.
  • If the spreadsheet and sheet exist, then the sheet is cleared and updated with the new data.
Add
  • The spreadsheet is created if it doesn't exist.
  • If the spreadsheet exists, and the sheet doesn't exist, a new sheet is created with the sheet name specified.
  • If sheet already exist, and there is no start cell defined, the data will be appended to the end of the current data
  • If a start cell is defined, the data will be added to the sheet starting on the start cell, overwriting any data that might have been there before.
  • If start cell is not defined, the data will be appended to the end of existing data.
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.

Running a load

To run the load, select Run from the toolbar, indicated in the screenshot below. The load executes using the variable values currently saved in the component.

screenshot indicated the Run button for integrator loads and jobs

screenshot indicated the Run button for loads and jobs

To run the load with different values without changing what's saved in the component, select Run with options from the dropdown next to Run. This opens a dialog listing the component's variables. Update any variable value as needed, then use the reset icon next to a field, or select Reset all, to restore its saved value. Select Run in the dialog to execute the load using those values; they apply only to that run. If the load has no variables, the dialog states that no variables are used; select Close and run the component normally instead.

To run the load with different values without changing what's saved in the component, select the arrow next to Run and choose Run with options. This opens a dialog listing the component's variables, where you can change values for this run only; the saved values are not affected.

Updated September 29, 2026