Sign in
Google Apps Script
Home
Products
Conferences
Showcase
Live
Groups
Google Apps Script
Feedback on this document
Overview
5-Minute Quickstart
Your First Script
Your First Custom Function
Intermediate Tutorials
Working with Spreadsheet Data
Sending Emails from a Spreadsheet
Simple Mail Merge
Gmail Inbox Statistics Report
Embedding DocsList in Google Sites
Other Tutorials
GUIDES
Types of Scripts
Standalone Scripts
Container-Bound Scripts
Spreadsheet Custom Functions
Web Apps
Google Sites Gadgets
Container Extensions
Development Environment
Access to Google Accounts
Apps Script Services
External APIs
Managing Projects
Managing Libraries
Managing Versions
Collaborating with Other Developers
Understanding Quotas
Publishing to the Chrome Web Store
Submitting to the Script Gallery
Events and Triggers
Understanding Events
Understanding Triggers
Managing Triggers Programmatically
Time-driven Triggers
Container-specific Triggers
Storing Data
Script and User Properties
ScriptDb
Spreadsheets
JDBC
Serving Content and User Interfaces
Html Service
Content Service
Ui Service
GUI Builder
Deprecated
REFERENCE
Google Apps Services
Calendar
CalendarApp
– CLASSES –
Calendar
CalendarEvent
CalendarEventSeries
EventGuest
EventRecurrence
RecurrenceRule
– ENUMS –
Color
GuestStatus
Visibility
Contacts
ContactsApp
– CLASSES –
AddressField
CompanyField
Contact
ContactGroup
CustomField
DateField
EmailField
IMField
PhoneField
UrlField
– ENUMS –
ExtendedField
Field
Gender
Priority
Sensitivity
DocsList
Experimental!
DocsList
– CLASSES –
File
FilesResult
Folder
FoldersResult
Token
– ENUMS –
FileType
Document
Experimental!
DocumentApp
– CLASSES –
AutogeneratedRegion
BaseTextContainerElement
Body
ContainerElement
Document
Element
Equation
EquationFunction
EquationFunctionArgumentSeparator
EquationSymbol
FooterSection
Footnote
FootnoteSection
HeaderSection
HorizontalRule
InlineDrawing
InlineImage
ListItem
PageBreak
Paragraph
SearchResult
Section
Table
TableCell
TableOfContents
TableRow
Text
UnsupportedElement
– ENUMS –
Attribute
ElementType
FontFamily
GlyphType
HorizontalAlignment
ParagraphHeading
VerticalAlignment
Domain
Experimental!
GroupsManager
NicknameManager
UserManager
– CLASSES –
DomainGroup
DomainNickname
DomainUser
– ENUMS –
PermissionLevel
Finance
FinanceApp
– CLASSES –
HistoricalStockInfo
StockInfo
StockInfoSnapshot
– ENUMS –
Interval
Gmail
GmailApp
– CLASSES –
GmailAttachment
GmailLabel
GmailMessage
GmailThread
Groups
GroupsApp
– CLASSES –
Group
– ENUMS –
Role
Language
LanguageApp
Maps
Maps
– CLASSES –
DirectionFinder
ElevationSampler
Geocoder
StaticMap
– ENUMS –
Avoid
Color
DirectionFinderEnums
Format
MarkerSize
Mode
StaticMapEnums
Type
Sites
SitesApp
– CLASSES –
Attachment
Column
Comment
ListItem
Page
Site
– ENUMS –
AttachmentType
PageType
Spreadsheet
SpreadsheetApp
– CLASSES –
ContainerInfo
DataValidation
EmbeddedAreaChartBuilder
EmbeddedBarChartBuilder
EmbeddedChart
EmbeddedChartBuilder
EmbeddedColumnChartBuilder
EmbeddedLineChartBuilder
EmbeddedPieChartBuilder
EmbeddedScatterChartBuilder
EmbeddedTableChartBuilder
PageProtection
Range
Sheet
Spreadsheet
– ENUMS –
DataValidationCriteria
Advanced Google Services
How to Enable Advanced Services
AdSense
Experimental!
AdClient
AdClients
AdclientsCollection
AdSense
AdsenseReportsGenerateResponse
AdsenseReportsGenerateResponseHeaders
AdUnit
AdUnits
AdunitsCollection
CustomChannel
CustomChannels
CustomchannelsCollection
ReportsCollection
UrlChannel
UrlChannels
UrlchannelsCollection
Analytics
Experimental!
Account
AccountChildLink
Accounts
AccountsCollection
Analytics
DataCollection
GaCollection
GaData
GaDataColumnHeaders
GaDataProfileInfo
GaDataQuery
Goal
GoalEventDetails
GoalEventDetailsEventConditions
GoalParentLink
Goals
GoalsCollection
GoalUrlDestinationDetails
GoalUrlDestinationDetailsSteps
GoalVisitNumPagesDetails
GoalVisitTimeOnSiteDetails
ManagementCollection
McfCollection
McfData
McfDataColumnHeaders
McfDataProfileInfo
McfDataQuery
McfDataRows
McfDataRowsConversionPathValue
Profile
ProfileChildLink
ProfileParentLink
Profiles
ProfilesCollection
Segment
Segments
SegmentsCollection
Webproperties
WebpropertiesCollection
Webproperty
WebpropertyChildLink
WebpropertyParentLink
BigQuery
Experimental!
BigQuery
Dataset
DatasetAccess
DatasetList
DatasetListDatasets
DatasetReference
DatasetsCollection
ErrorProto
GetQueryResultsResponse
Job
JobConfiguration
JobConfigurationExtract
JobConfigurationLink
JobConfigurationLoad
JobConfigurationQuery
JobConfigurationTableCopy
JobList
JobListJobs
JobReference
JobsCollection
JobStatistics
JobStatus
ProjectList
ProjectListProjects
ProjectReference
ProjectsCollection
QueryRequest
QueryResponse
Table
TabledataCollection
TableDataList
TableFieldSchema
TableList
TableListTables
TableReference
TableRow
TableRowF
TableSchema
TablesCollection
Prediction
Experimental!
Analyze
AnalyzeDataDescription
AnalyzeDataDescriptionFeatures
AnalyzeDataDescriptionFeaturesCategorical
AnalyzeDataDescriptionFeaturesCategoricalValues
AnalyzeDataDescriptionFeaturesNumeric
AnalyzeDataDescriptionFeaturesText
AnalyzeDataDescriptionOutputFeature
AnalyzeDataDescriptionOutputFeatureNumeric
AnalyzeDataDescriptionOutputFeatureText
AnalyzeModelDescription
HostedmodelsCollection
Input
InputInput
List
Output
OutputOutputMulti
PredictInput
PredictInput
Prediction
TrainedmodelsCollection
Training
TrainingModelInfo
Update
Tasks
Experimental!
Task
TaskLinks
TaskList
TaskLists
TasklistsCollection
Tasks
Tasks
TasksCollection
UrlShortener
Experimental!
AnalyticsSnapshot
AnalyticsSummary
StringCount
Url
UrlCollection
UrlHistory
UrlShortener
Script Services
Base
Browser
Logger
Session
– CLASSES –
Blob
CompositeBlob
User
– INTERFACES –
BlobSource
– ENUMS –
ButtonSet
Month
Weekday
Cache
CacheService
– CLASSES –
Cache
Charts
Charts
– CLASSES –
AreaChartBuilder
BarChartBuilder
CategoryFilterBuilder
Chart
ChartOptions
ColumnChartBuilder
Control
DashboardPanel
DashboardPanelBuilder
DataTable
DataTableBuilder
DataViewDefinition
DataViewDefinitionBuilder
LineChartBuilder
NumberRangeFilterBuilder
PieChartBuilder
ScatterChartBuilder
StringFilterBuilder
TableChartBuilder
TextStyle
TextStyleBuilder
– INTERFACES –
DataTableSource
– ENUMS –
ChartType
ColumnType
CurveStyle
MatchType
Orientation
PickerValuesLayout
PointStyle
Position
Content
ContentService
– CLASSES –
TextOutput
– ENUMS –
MimeType
Html
HtmlService
– CLASSES –
HtmlOutput
HtmlTemplate
Jdbc
Experimental!
Jdbc
– CLASSES –
JdbcArray
JdbcBlob
JdbcCallableStatement
JdbcClob
JdbcConnection
JdbcDatabaseMetaData
JdbcDate
JdbcParameterMetaData
JdbcPreparedStatement
JdbcRef
JdbcResultSet
JdbcResultSetMetaData
JdbcRowId
JdbcSQLXML
JdbcSavepoint
JdbcStatement
JdbcStruct
JdbcTime
JdbcTimestamp
Lock
LockService
– CLASSES –
Lock
Mail
MailApp
Properties
ScriptProperties
UserProperties
Script
ScriptApp
– CLASSES –
ClockTriggerBuilder
Service
SpreadsheetTriggerBuilder
Trigger
TriggerBuilder
– ENUMS –
EventType
Service.Restriction
TriggerSource
ScriptDb
Experimental!
ScriptDb
– CLASSES –
MutationResult
QueryOperator
ScriptDbInstance
ScriptDbMap
ScriptDbResult
– ENUMS –
SortDirection
SortStrategy
Soap
SoapService
– CLASSES –
SoapOperation
Wsdl
WsdlService
Ui
Experimental!
UiApp
– CLASSES –
AbsolutePanel
Anchor
Button
CaptionPanel
CheckBox
ClientHandler
DateBox
DatePicker
DeckPanel
Deprecated
DecoratedPopupPanel
Deprecated
DecoratedStackPanel
DecoratedTabBar
DecoratedTabPanel
DecoratorPanel
DialogBox
DockLayoutPanel
Deprecated
DockPanel
Deprecated
DocsListDialog
FileUpload
FlexTable
FlowPanel
FocusPanel
FormPanel
Grid
HTML
Hidden
HorizontalPanel
Hyperlink
Deprecated
Image
InlineHyperlink
Deprecated
InlineLabel
Label
LayoutPanel
Deprecated
ListBox
MenuBar
MenuItem
MenuItemSeparator
PasswordTextBox
PopupPanel
PushButton
RadioButton
ResetButton
RichTextArea
Deprecated
ScrollPanel
ServerHandler
SimpleCheckBox
SimplePanel
SimpleRadioButton
SplitLayoutPanel
StackLayoutPanel
Deprecated
StackPanel
SubmitButton
SuggestBox
Deprecated
TabBar
TabLayoutPanel
Deprecated
TabPanel
TextArea
TextBox
ToggleButton
Tree
TreeItem
UiInstance
VerticalPanel
– INTERFACES –
Component
Handler
Widget
– ENUMS –
DateTimeFormat
FileType
HorizontalAlignment
VerticalAlignment
UrlFetch
UrlFetchApp
– CLASSES –
HTTPResponse
OAuthConfig
Utilities
Utilities
– ENUMS –
Charset
DigestAlgorithm
MacAlgorithm
Xml
Xml
– CLASSES –
XmlAttribute
XmlDocument
XmlElement
XmlName
XmlNode
HELP
Support
How to Get Help
Dashboard and Quotas
Issue Tracker
Release Notes
Sunset Schedule
Troubleshooting
Other Resources
Best Practices
Case Studies
Glossary
Notable Script Libraries
Templates
Terms of Service
Stay Connected
Blog
Google Developers Live Schedule
Google Developers Live Archive
Other Videos
Twitter
Enum SortDirection
When ordering results, specifies which direction they should be ordered.
Properties
Property
Type
Description
DESCENDING
Enum
ASCENDING
Enum
Authentication required
You need to be signed in with
Google+
to do that.
Sign in
Cancel
Signing you in...
Google Developers needs your permission to do that.
Try again
Cancel
