← Google Calendar Add-On Übersicht
Erstellt Termine / Events in Ihrem Google Kalender.
Das sind die Optionen, mit denen man den Step konfigurieren kann.
| Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
| account | ACCOUNT | Ihr Konto | Ja | |
| calendarId | STRING | Die Google Kalender Id. | Ja | |
| sourceSpreadsheet | SPREADSHEET | Ein SPREADSHEET mit den Kalender-Ereignisdaten. | Ja | |
| mappingdefinition | STRING | The mapping definition JSON String | Nein | |
| Folgende Felder sind zu konfigurieren:
| Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | | summary | SINGLE | Title of the event. | Nein | | | description | SINGLE | Description of the event. Can contain HTML. | Nein | | | location | SINGLE | Geographic location of the event as free-form text. | Nein | | | startDateTime | SINGLE | The time, as a combined date-time value. (formatted "yyyy-MM-dd HH:mm" or "yyyy-MM-dd HH:mm:ss"). For an all-day event use the format "yyyy-mm-dd" without time specified. | Nein | | | endDateTime | SINGLE | The time, as a combined date-time value (formatted "yyyy-MM-dd HH:mm" or "yyyy-MM-dd HH:mm:ss"). For an all-day event use the format "yyyy-mm-dd" without time specified. | Nein | | | isAllDayEvent | SINGLE | Treat Start and End date as all day event. Dafault is false (date-time or date format sets event type). | Nein | | | timezone | SINGLE | The time zone in which the time is specified. (Formatted as an IANA Time Zone Database name, e.g. "Europe/Zurich".) This value is used by startDateTime and endDateTime. For recurring events this field is required and specifies the time zone in which the recurrence is expanded. Dfault fallback is the current timezone | Nein | | | sendUpdates | SINGLE | Whether to send notifications about the creation of the new event. | Nein | | | attendees | SINGLE | Semicolon separated list of the attendees email adresses. | Nein | | | attendeesOptional | SINGLE | Semicolon separated list of the optional attendees previously set in attendies column. | Nein | | | guestsCanInviteOthers | SINGLE | Whether attendees other than the organizer can invite others to the event. The default is True. | Nein | | | guestsCanModify | SINGLE | Whether attendees other than the organizer can modify the event. The default is False. | Nein | | | guestsCanSeeOtherGuests | SINGLE | Whether attendees other than the organizer can see who the event's attendees are. The default is True. | Nein | | | reminderType | SINGLE | The method used by this reminder. | Nein | | | reminderMinutes | SINGLE | Number of minutes before the start of the event when the reminder should trigger. Valid values are between 0 and 40320 (4 weeks in minutes). | Nein | | | colorId | SINGLE | The color of the event. | Nein | | | sourceTitle | SINGLE | Title of the source; for example a title of a web page or an email subject. | Nein | | | sourceUrl | SINGLE | URL of the source pointing to a resource. The URL scheme must be HTTP or HTTPS. | Nein | | | status | SINGLE | Status of the event. | Nein | | | visibility | SINGLE | Visibility of the event. | Nein | | |
| limit | STRING | Nur diese Anzahl von Zeilen hinzufügen. | Nein | |
Outputs
Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach
der Ausführung verwendet werden können.
| Name | Datentyp | Beschreibung | Werte |
| successSpreadsheet | SPREADSHEET | Ein SPREADSHEET, das die erfolgreich angelegten Termine enthält | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | identifier | SINGLE | | | | eventId | SINGLE | The eventId of the event. | | | summary | SINGLE | Title of the event. | | | description | SINGLE | Description of the event. Can contain HTML. | | | location | SINGLE | Geographic location of the event as free-form text. | | | startDateTime | SINGLE | The time, as a combined date-time value. (formatted "yyyy-MM-dd HH:mm" or "yyyy-MM-dd HH:mm:ss"). For an all-day event use the format "yyyy-mm-dd" without time specified. | | | endDateTime | SINGLE | The time, as a combined date-time value (formatted "yyyy-MM-dd HH:mm" or "yyyy-MM-dd HH:mm:ss"). For an all-day event use the format "yyyy-mm-dd" without time specified. | | | isAllDayEvent | SINGLE | Treat Start and End date as all day event. Dafault is false (date-time or date format sets event type). | | | timezone | SINGLE | The time zone in which the time is specified. (Formatted as an IANA Time Zone Database name, e.g. "Europe/Zurich".) This value is used by startDateTime and endDateTime. For recurring events this field is required and specifies the time zone in which the recurrence is expanded. Dfault fallback is the current timezone | | | sendUpdates | SINGLE | Whether to send notifications about the creation of the new event. | | | attendees | SINGLE | Semicolon separated list of the attendees email adresses. | | | attendeesOptional | SINGLE | Semicolon separated list of the optional attendees previously set in attendies column. | | | guestsCanInviteOthers | SINGLE | Whether attendees other than the organizer can invite others to the event. The default is True. | | | guestsCanModify | SINGLE | Whether attendees other than the organizer can modify the event. The default is False. | | | guestsCanSeeOtherGuests | SINGLE | Whether attendees other than the organizer can see who the event's attendees are. The default is True. | | | reminderType | SINGLE | The method used by this reminder. | | | reminderMinutes | SINGLE | Number of minutes before the start of the event when the reminder should trigger. Valid values are between 0 and 40320 (4 weeks in minutes). | | | colorId | SINGLE | The color of the event. | | | sourceTitle | SINGLE | Title of the source; for example a title of a web page or an email subject. | | | sourceUrl | SINGLE | URL of the source pointing to a resource. The URL scheme must be HTTP or HTTPS. | | | status | SINGLE | Status of the event. | | | visibility | SINGLE | Visibility of the event. | | |
| failedSpreadsheet | SPREADSHEET | Ein SPREADSHEET, das die fehlgeschlagenen/nicht angelegten Ereignisse enthält. | |
| Folgende Felder sind im Output enthalten:
| Feld | Datentyp | Beschreibung | Standardwert | | identifier | SINGLE | | | | eventId | SINGLE | The eventId of the event. | | | summary | SINGLE | Title of the event. | | | description | SINGLE | Description of the event. Can contain HTML. | | | location | SINGLE | Geographic location of the event as free-form text. | | | startDateTime | SINGLE | The time, as a combined date-time value. (formatted "yyyy-MM-dd HH:mm" or "yyyy-MM-dd HH:mm:ss"). For an all-day event use the format "yyyy-mm-dd" without time specified. | | | endDateTime | SINGLE | The time, as a combined date-time value (formatted "yyyy-MM-dd HH:mm" or "yyyy-MM-dd HH:mm:ss"). For an all-day event use the format "yyyy-mm-dd" without time specified. | | | isAllDayEvent | SINGLE | Treat Start and End date as all day event. Dafault is false (date-time or date format sets event type). | | | timezone | SINGLE | The time zone in which the time is specified. (Formatted as an IANA Time Zone Database name, e.g. "Europe/Zurich".) This value is used by startDateTime and endDateTime. For recurring events this field is required and specifies the time zone in which the recurrence is expanded. Dfault fallback is the current timezone | | | sendUpdates | SINGLE | Whether to send notifications about the creation of the new event. | | | attendees | SINGLE | Semicolon separated list of the attendees email adresses. | | | attendeesOptional | SINGLE | Semicolon separated list of the optional attendees previously set in attendies column. | | | guestsCanInviteOthers | SINGLE | Whether attendees other than the organizer can invite others to the event. The default is True. | | | guestsCanModify | SINGLE | Whether attendees other than the organizer can modify the event. The default is False. | | | guestsCanSeeOtherGuests | SINGLE | Whether attendees other than the organizer can see who the event's attendees are. The default is True. | | | reminderType | SINGLE | The method used by this reminder. | | | reminderMinutes | SINGLE | Number of minutes before the start of the event when the reminder should trigger. Valid values are between 0 and 40320 (4 weeks in minutes). | | | colorId | SINGLE | The color of the event. | | | sourceTitle | SINGLE | Title of the source; for example a title of a web page or an email subject. | | | sourceUrl | SINGLE | URL of the source pointing to a resource. The URL scheme must be HTTP or HTTPS. | | | status | SINGLE | Status of the event. | | | visibility | SINGLE | Visibility of the event. | | |
