Make Common Spreadsheet Properties
Generates a JSON representation of some of the more commonly-used properties of a spreadsheet.
Leave values empty to keep the default values or auto-generate them on Google's end.
These fields can be used to create a new spreadsheet or update an existing spreadsheet's properties.
Inputs
|
In Desired Title
String
|
The desired name or title of the spreadsheet. |
|
In Desired Locale
String
|
The locale of the spreadsheet in one of the following formats: an ISO 639-1 language code such as en; an ISO 639-2 language code such as fil, if no 639-1 code exists; a combination of the ISO language code and country code, such as en_US. Note: when updating this field, not all locales/languages are supported. |
|
In Desired Recalculation Interval
String
|
The amount of time to wait before volatile functions are recalculated. "ON_CHANGE": Volatile functions are updated on every change; "MINUTE": Volatile functions are updated on every change and every minute; "HOUR": Volatile functions are updated on every change and hourly. |
|
In Desired Time Zone
String
|
The time zone of the spreadsheet, in CLDR format such as "America/New_York". If the time zone isn't recognized, this may be a custom time zone such as "GMT-07:00". |
Outputs
|
Return Value
Google Sheets Properties Container Structure
|