← ChatGPT & OpenAI Add-On Übersicht
This Step uses the ChatGPT API with its latest and most advanced gpt-3.5-turbo and gpt-4 models. It processes spreadsheets.
Das sind die Optionen, mit denen man den Step konfigurieren kann.
| Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
| account | ACCOUNT | Your OpenAI Account | Nein | |
| input | SPREADSHEET | Limits the spreadsheet rows to be processed. | Nein | |
| mappingdefinition | STRING | The mapping definition JSON String | Nein | |
| Folgende Felder sind zu konfigurieren:
| Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | | id | SINGLE | An identifier (e.g. ProductID, SKU) to identify the record after the OpenAI result was returned. | Nein | | | message | SINGLE | The message is basically the text you are sending to the ChatGPT chat API. | Ja | | |
| model | STRING | The model which will generate the completion. Only the chat models can be used. | Nein | - gpt-5
- gpt-5-nano
- gpt-5-mini
- gpt-4.1
- gpt-4.1-nano
- gpt-4.1-mini
- gpt-4
- gpt-4-turbo-preview
- gpt-4o
- gpt-4o-mini
- gpt-4o-search-preview
- gpt-4o-mini-search-preview
- gpt-3.5-turbo
- o1
- o3-mini
|
| limit | STRING | limits the spreadsheet rows to be processed | Nein | |
| max_tokens | STRING | Max. number of tokens to return per row. | Nein | |
| variance | STRING | The variance determines the randomness of the generated output. None outputs a pure deterministic result. Which means the same command or question always arises the same result. Low results in a more deterministic ouput with little variance. High increases the result variance. | Nein | - none
- low
- medium
- high
- very high
- maximum
|
Outputs
Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach
der Ausführung verwendet werden können.
| Name | Datentyp | Beschreibung | Werte |
| result | SPREADSHEET | The Result Spreadsheet | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | source_id | SINGLE | | | | source_message | SINGLE | | | | result | SINGLE | | | | usage | SINGLE | | | |
| invalid | SPREADSHEET | Invalid rows | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | id | SINGLE | | | | message | SINGLE | | | |
| error | SPREADSHEET | | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | source_id | SINGLE | | | | source_message | SINGLE | | | | error_message | SINGLE | | | |
