Google Apps Script Cheat Sheet : シート1
ABC
1
CategoryComponentDescription
2
CalendarThis service allows a script to access and modify the user's Google Calendar, including additional calendars that the user is subscribed to.
3
Class CalendarAppAllows a script to read and update the user's Google Calendar. This class provides direct access to the user's default calendar, as well as the ability to retrieve additional calendars that the user owns or is subscribed to.
4
Class CalendarRepresents a calendar that the user owns or is subscribed to.
5
Class CalendarEventRepresents a single calendar event.
6
Class CalendarEventSeriesRepresents a series of events (a recurring event).
7
Class EventGuestRepresents a guest of an event.
8
Class EventRecurrenceRepresents the recurrence settings for an event series.
9
Class RecurrenceRuleRepresents a recurrence rule for an event series.
Note that this class also behaves like the EventRecurrence that it belongs to, allowing you to chain rule creation together like so: recurrence.addDailyRule().times(3).interval(2).addWeeklyExclusion().times(2);
Modifiers like times(times) and interval(interval) are applied to the most recently added rule.
10
Enum ColorAn enum representing the named colors available in the Calendar service.
11
Enum GuestStatusAn enum representing the statuses a guest can have for an event.
12
Enum VisibilityAn enum representing the visibility of an event.
13
14
ContactsThis service allows scripts to access and modify Google Contacts, both for individual contacts and for groups.
15
Class ContactsAppThis class allows users to access their own Google Contacts and create, remove, and update contacts listed therein.
16
Class AddressFieldAddress field in a contact.
17
Class CompanyFieldCompany field in a Contact.
18
Class ContactA Contact contains the name, address, and various contact details of a contact.
19
Class ContactGroupA ContactGroup is is a group of contacts.
20
Class CustomFieldA custom field in a Contact.
21
Class DateFieldA date field in a Contact.
22
Class EmailFieldAn email field in a Contact.
23
Class IMFieldAn instant messaging field in a Contact.
24
Class PhoneFieldA phone number field in a Contact.
25
Class UrlFieldA URL field in a Contact.
26
Enum ExtendedFieldAn enum for extended contacts fields.
27
Enum FieldAn enum for contacts fields.
28
Enum GenderAn enum for contact gender.
29
Enum PriorityAn enum for contact priority.
30
Enum SensitivityAn enum for contact sensitivity.
31
32
DocumentThis service allows scripts to create, access, and modify Google Docs files.
33
Enum AttributeAn enumeration of the element attributes.
Use attributes to compose custom styles. For example:
34
Class BodyAn element representing a document body. The Body may contain ListItem, Paragraph, Table, and TableOfContents elements. For more information on document structure, see the guide to extending Google Docs.
The Body typically contains the full document contents except for the HeaderSection, FooterSection, and any FootnoteSection elements.
35
Class BookmarkAn object representing a bookmark.
36
Class ContainerElementA generic element that may contain other elements. All elements that may contain child elements, such as Paragraph, inherit fromContainerElement.
37
Class DocumentA document, containing rich text and elements such as tables and lists.
Documents may be opened or created using DocumentApp.
38
Class DocumentAppThe document service creates and opens Documents that can be edited.
39
Interface ElementA generic element. Document contents are represented as elements. For example, ListItem, Paragraph, and Table are elements and inherit all of the methods defined by Element, such as getType().
40
Enum ElementTypeAn enumeration of all the element types.
Use the ElementType enumeration to check the type of a given element, for instance:
41
Class EquationAn element representing a mathematical expression. An Equation may contain EquationFunction, EquationSymbol, and Textelements. For more information on document structure, see the guide to extending Google Docs.
42
Class EquationFunctionAn element representing a function in a mathematical Equation. An EquationFunction may contain EquationFunction,EquationFunctionArgumentSeparator, EquationSymbol, and Text elements. For more information on document structure, see theguide to extending Google Docs.
43
An element representing a function separator in a mathematical Equation. An EquationFunctionArgumentSeparator cannot contain any other element. For more information on document structure, see the guide to extending Google Docs.
44
Class EquationSymbolAn element representing a symbol in a mathematical Equation. An EquationSymbol cannot contain any other element. For more information on document structure, see the guide to extending Google Docs.
45
Enum FontFamilyAn enumeration of the supported fonts.
Use the FontFamily enumeration to set the font for a range of text, element or document.
46
Class FooterSectionAn element representing a footer section. A Document typically contains at most one FooterSection. The FooterSection may containListItem, Paragraph, and Table elements. For more information on document structure, see the guide to extending Google Docs.
47
Class FootnoteAn element representing a footnote. Each Footnote is contained within a ListItem or Paragraph and has a correspondingFootnoteSection element for the footnote's contents. The Footnote itself cannot contain any other element. For more information on document structure, see the guide to extending Google Docs.
48
Class FootnoteSectionAn element representing a footnote section. A FootnoteSection contains the text that corresponds to a Footnote. The FootnoteSection may contain ListItem or Paragraph elements. For more information on document structure, see the guide to extending Google Docs.
49
Enum GlyphTypeAn enumeration of the supported glyph types.
Use the GlyphType enumeration to set the bullet type for list items.
50
Class HeaderSectionAn element representing a header section. A Document typically contains at most one HeaderSection. The HeaderSection may contain ListItem, Paragraph, and Table elements. For more information on document structure, see the guide to extending Google Docs.
51
Enum HorizontalAlignmentAn enumeration of the supported horizontal alignment types.
52
Class HorizontalRuleAn element representing an horizontal rule. A HorizontalRule can be contained within a ListItem or Paragraph, but cannot itself contain any other element. For more information on document structure, see the guide to extending Google Docs.
53
Class InlineDrawingAn element representing an embedded drawing. An InlineDrawing can be contained within a ListItem or Paragraph, unless the ListItem or Paragraph is within a FootnoteSection. An InlineDrawing cannot itself contain any other element. For more information on document structure, see the guide to extending Google Docs.
54
Class InlineImageAn element representing an embedded image. An InlineImage can be contained within a ListItem or Paragraph, unless the ListItem or Paragraph is within a FootnoteSection. An InlineImage cannot itself contain any other element. For more information on document structure, see the guide to extending Google Docs.
55
Class ListItemAn element representing a list item. A ListItem is a Paragraph that is associated with a list ID. A ListItem may contain Equation, Footnote, HorizontalRule, InlineDrawing, InlineImage, PageBreak, and Text elements. For more information on document structure, see the guide to extending Google Docs.

ListItems may not contain new-line characters. New-line characters ("\n") are converted to line-break characters ("\r").

ListItems with the same list ID belong to the same list and are numbered accordingly. The ListItems for a given list are not required to be adjacent in the document or even have the same parent element. Two items belonging to the same list may exist anywhere in the document while maintaining consecutive numbering, as the following example illustrates:
56
Class NamedRangeA Range that has a name and ID to allow later retrieval. Names are not necessarily unique; several different ranges in the same document may share the same name, much like a class in HTML. By contrast, IDs are unique within the document, like an ID in HTML. Once a NamedRange has been added to a document, it cannot be modified, only removed.

A NamedRange can be accessed by any script that accesses the document. To avoid unintended conflicts between scripts, consider prefixing range names with a unique string.
57
Class PageBreakAn element representing a page break. A PageBreak can be contained within a ListItem or Paragraph, unless the ListItem or Paragraph is within a Table, HeaderSection, FooterSection, or FootnoteSection. A PageBreak cannot itself contain any other element. For more information on document structure, see the guide to extending Google Docs.
58
Class ParagraphAn element representing a paragraph. A Paragraph may contain Equation, Footnote, HorizontalRule, InlineDrawing, InlineImage, PageBreak, and Text elements. For more information on document structure, see the guide to extending Google Docs.

Paragraphs may not contain new-line characters. New-line characters ("\n") are converted to line-break characters ("\r").
59
Enum ParagraphHeadingAn enumeration of the standard paragraph headings.
60
Class PositionA reference to a location in the document, relative to a specific element. The user's cursor is represented as a Position, among other uses. Scripts can only access the cursor of the user who is running the script, and only if the script is bound to the document.
61
Class RangeA range of elements in a document. The user's selection is represented as a Range, among other uses. Scripts can only access the selection of the user who is running the script, and only if the script is bound to the document.
62
Class RangeBuilderA builder used to construct RangeBuilder objects from document elements.
63
Class RangeElementA wrapper around an Element with a possible start and end offset. These offsets allow a range of characters within a Text element to be represented in search results, document selections, and named ranges.
64
Class TableAn element representing a table. A Table may only contain TableRow elements. For more information on document structure, see the guide to extending Google Docs.

When creating a Table that contains a large number of rows or cells, consider building it from a string array, as shown in the following example.
65
Class TableCellAn element representing a table cell. A TableCell is always contained within a TableRow and may contain ListItem, Paragraph, or Table elements. For more information on document structure, see the guide to extending Google Docs.
66
Class TableOfContentsAn element containing a table of contents. A TableOfContents may contain ListItem, Paragraph, and Table elements, although the contents of a TableOfContents are usually generated automatically by Google Docs. For more information on document structure, see the guide to extending Google Docs.
67
Class TableRowAn element representing a table row. A TableRow is always contained within a Table and may only contain TableCell elements. For more information on document structure, see the guide to extending Google Docs.
68
Class TextAn element representing a rich text region. All text in a Document is contained within Text elements. A Text element can be contained within an Equation, EquationFunction, ListItem, or Paragraph, but cannot itself contain any other element. For more information on document structure, see the guide to extending Google Docs.
69
Enum TextAlignmentAn enumeration of the type of text alignments.
70
Class UnsupportedElementAn element representing a region that is unknown or cannot be affected by a script, such as a page number.
71
Enum VerticalAlignmentAn enumeration of the supported vertical alignment types.
72
73
DriveThis service allows scripts to create, find, and modify files and folders in Google Drive.
74
Enum AccessAn enum representing classes of users who can access a file or folder, besides any individual users who have been explicitly given access. These properties can be accessed from DriveApp.Access.
75
Class DriveAppAllows scripts to create, find, and modify files and folders in Google Drive.
76
Class FileA file in Google Drive. Files can be accessed or created from DriveApp.
77
Class FileIteratorAn iterator that allows scripts to iterate over a potentially large collection of files. File iterators can be acccessed from DriveApp or aFolder.
78
Class FolderA folder in Google Drive. Folders can be accessed or created from DriveApp.
79
Class FolderIteratorAn object that allows scripts to iterate over a potentially large collection of folders. Folder iterators can be acccessed from DriveApp, a File, or a Folder.
80
Enum PermissionAn enum representing the permissions granted to users who can access a file or folder, besides any individual users who have been explicitly given access. These properties can be accessed from DriveApp.Permission.
81
Class UserA user associated with a file in Google Drive. Users can be accessed from File.getEditors(), Folder.getViewers(), and other methods.
82
83
FormsThis service allows scripts to create, access, and modify Google Forms.
84
Class AlignmentAn enum representing the supported types of image alignment. Alignment types can be accessed from FormApp.Alignment.
85
Class CheckboxItemA question item that allows the respondent to select one or more checkboxes, as well as an optional "other" field. Items can be accessed or created from a Form.
86
Class ChoiceA single choice associated with a type of Item that supports choices, like CheckboxItem, ListItem, orMultipleChoiceItem.
87
Class DateItemA question item that allows the respondent to indicate a date. Items can be accessed or created from a Form.
88
Class DateTimeItemA question item that allows the respondent to indicate a date and time. Items can be accessed or created from a Form.
89
Enum DestinationTypeAn enum representing the supported types of form-response destinations. All forms, including those that do not have a destination set explicitly, save a copy of responses in the form's response store. Destination types can be accessed fromFormApp.DestinationType.
90
Class DurationItemA question item that allows the respondent to indicate a length of time.
91
Class FormA form that contains overall properties (such as title, settings, and where responses are stored) and items (which includes question items like checkboxes and layout items like page breaks). Forms can be accessed or created from FormApp.
92
Class FormAppAllows a script to open existing Forms or create new ones.
93
Class FormResponseA response to the form as a whole. Form responses have three main uses: they contain the answers submitted by a respondent (see getItemResponses(), they can be used to programmatically respond to the form (see withItemResponse(response) and submit()), and they can be used as a template to create a URL for the form with pre-filled answers. Form responses can be created or accessed from a Form.
94
Class GridItemA question item, presented as a grid of columns and rows, that allows the respondent to select one choice per row from a sequence of radio buttons. Items can be accessed or created from a Form.
95
Class ImageItemA layout item that displays an image. Items can be accessed or created from a Form.
96
Class ItemA generic form item that contains properties common to all items, such as title and help text. Items can be accessed or created from a Form. To operate on type-specific properties, use getType() to check the item's ItemType, then cast the item to the appropriate class using a method like asCheckboxItem().
97
Class ItemResponseA response to one question item within a form. Item responses can be accessed from FormResponse and created from any Item that asks the respondent to answer a question.
98
Enum ItemTypeAn enum representing the supported types of form items. Item types can be accessed from FormApp.ItemType.
99
Class ListItemA question item that allows the respondent to select one choice from a drop-down list. Items can be accessed or created from aForm.
100
Class MultipleChoiceItemA question item that allows the respondent to select one choice from a list of radio buttons or an optional "other" field. Items can be accessed or created from a Form.
101
Class PageBreakItemA layout item that marks the start of a page. Items can be accessed or created from a Form.
102
Enum PageNavigationTypeAn enum representing the supported types of page navigation. Page navigation types can be accessed from FormApp.PageNavigationType.

The page navigation occurs after the respondent completes a page that contains the option, and only if the respondent chose that option. If the respondent chose multiple options with page-navigation instructions on the same page, only the last navigation option has any effect. Page navigation also has no effect on the last page of a form.

Choices that use page navigation cannot be combined in the same item with choices that do not use page navigation.
103
Class ParagraphTextItemA question item that allows the respondent to enter a block of text. Items can be accessed or created from a Form.
104
Class ScaleItemA question item that allows the respondent to choose one option from a numbered sequence of radio buttons. Items can be accessed or created from a Form.
105
Class SectionHeaderItemA layout item that visually indicates the start of a section. Items can be accessed or created from a Form.
106
Class TextItemA question item that allows the respondent to enter a single line of text. Items can be accessed or created from a Form.
107
Class TimeItemA question item that allows the respondent to indicate a time of day. Items can be accessed or created from a Form.
108
Class VideoItemA layout item that displays a video. Items can be accessed or created from a Form.
109
Enum AlignmentAn enum representing the supported types of image alignment. Alignment types can be accessed from FormApp.Alignment.
110
111
GmailThis service allows scripts to send email and access a user's Gmail account. See also Mail Service. Unlike Gmail Service, Mail Service's sole purpose is sending email; it cannot access a user's Gmail account.
112
Class GmailAppProvides access to Gmail threads, messages, and labels.
113
Class GmailAttachmentAn attachment from Gmail. This is a regular Blob except that it has an extra getSize() method that is faster than callinggetBytes().length and does not count against the Gmail read quota.
114
Class GmailLabelA user-created label in a user's Gmail account.
115
Class GmailMessageA message in a user's Gmail account.
116
Class GmailThreadA thread in a user's Gmail account.
117
118
GroupsThis service allows scripts to access Google Groups. It can be used to query information such as a group's email address, or the list of groups in which the user is a direct member. Here's an example that shows how many groups the current user is a member of:
119
Class GroupA group object whose members and those members' roles within the group can be queried. Here's an example which shows the members of a group. Before running it, replace the email address of the group with that of one on your domain.
120
Class GroupsAppThis class provides access to Google Groups information. It can be used to query information such as a group's email address, or the list of groups in which the user is a direct member. Here's an example that shows how many groups the current user is a member of
121
Enum RolePossible roles of a user within a group, such as owner or ordinary member. Users subscribed to a group have exactly one role within the context of that group.
122
123
LanguageThis service allows scripts to automatically translate text.
124
Class LanguageAppThe Language service provides scripts a way to compute automatic translations of text.
125
126
MapsThis service allows scripts to generate static maps, find directions, convert addresses into geocode coordinates, and sample elevations.
127
Enum AvoidAn enum representing the types of restrictions to avoid when finding directions.
128
Enum ColorAn enum representing the named colors available to use in map images.
129
Class DirectionFinderAllows for the retrieval of directions between locations.
The example below shows how you can use this class to get the directions from Times Square to Central Park, stopping first at Lincoln Center, plot the locations and path on a map, and send the map in an email.
130
Class DirectionFinderEnumsA collection of enums used by DirectionFinder.
131
Class ElevationSamplerAllows for the sampling of elevations at particular locations.
The example below shows how you can use this class to determine the highest point along the route from Denver to Grand Junction in Colorado, plot it on a map, and save the map to Google Drive.
132
Enum FormatAn enum representing the format of the map image.
133
Class GeocoderAllows for the conversion between an address and geographical coordinates.
The example below shows how you can use this class find the top nine matches for the location "Main St" in Colorado, add them to a map, and then embed it in a new Google Doc.
134
Class MapsAllows for direction finding, geocoding, elevation sampling and the creation of static map images.
135
Enum MarkerSizeAn enum representing the size of a marker added to a map.
136
Enum ModeAn enum representing the mode of travel to use when finding directions.
137
Class StaticMapAllows for the creation and decoration of static map images.
The example below shows how you can use this class to create a map of New York City's Theatre District, including nearby train stations, and display it in a simple web app.
138
Class StaticMapEnumsA collection of enums used by StaticMap.
139
Enum TypeAn enum representing the type of map to render.
140
141
SitesThis service provides access to Google Sites.
142
Class AttachmentA Sites Attachment such as a file attached to a page. Note that an Attachment is a Blob and can be used anywhere Blob input is expected.
143
Enum AttachmentTypeA typesafe enum for sites attachment type.
144
Class ColumnA Sites Column - a column from a Sites List page.
145
Class CommentA Comment attached to any Sites page.
146
Class ListItemA Sites ListItem - a list element from a Sites List page.
147
Class PageA Page on a Google Site.
148
Enum PageTypeA typesafe enum for sites page type.
149
Class SiteAn object representing a Google Site.
150
Class SitesAppCreate and access Google Sites.
151
152
SpreadsheetThis service allows scripts to create, access, and modify Google Sheets files. See also the guide to storing data in spreadsheets.
153
Class ContainerInfoThe chart's position within a sheet. Can be updated using the EmbeddedChart.modify() function.
154
Class DataValidationThis class allows users to access existing data-validation rules. To create a new rule, see SpreadsheetApp.newDataValidation(), DataValidationBuilder, and Range.setDataValidation(rule).
155
Class DataValidationBuilderBuilder for data-validation rules.
156
Enum DataValidationCriteriaAn enumeration representing the data-validation criteria that can be set on a range.
157
Class EmbeddedAreaChartBuilderBuilder for area charts. For more details, see the Gviz documentation.
158
Class EmbeddedBarChartBuilderBuilder for bar charts. For more details, see the Gviz documentation.
159
Class EmbeddedChartRepresents a chart that has been embedded into a Spreadsheet.
160
Class EmbeddedChartBuilderThis builder allows you to edit an EmbeddedChart. Make sure to call sheet.updateChart(builder.build()) to save your changes.
161
Class EmbeddedColumnChartBuilderBuilder for column charts. For more details, see the Gviz documentation.
162
Class EmbeddedLineChartBuilderBuilder for line charts. For more details, see the Gviz documentation.
163
Class EmbeddedPieChartBuilderBuilder for pie charts. For more details, see the Gviz documentation.
164
Class EmbeddedScatterChartBuilderBuilder for scatter charts. For more details, see the Gviz documentation.
165
Class EmbeddedTableChartBuilderBuilder for table charts. For more details, see the Gviz documentation.
166
Class PageProtectionAccess and modify the state of protection permissions on a sheet. This class allows users to access and modify sheet protection permissions on a sheet.
167
Class RangeAccess and modify spreadsheet ranges. This class allows users to access and modify ranges in Google Sheets. A range can be a single cell in a sheet or a range of cells in a sheet.
168
Class SheetAccess and modify spreadsheet sheets. Common operations are renaming a sheet and accessing range objects from the sheet.
169
Class SpreadsheetThis class allows users to access and modify Google Sheets files. Common operations are adding new sheets and adding collaborators.
170
Class SpreadsheetAppThis class allows users to open Google Sheets files and to create new ones. This class is the parent class for the Spreadsheet service.
171
172
BaseThis service provides access to user information such as email addresses and user names. It also controls script logs and Google Apps-specific dialog boxes.
173
Class BlobA data interchange object for Apps Script services.
174
Interface BlobSourceInterface for objects that can export their data as a Blob.
175
Class BrowserThis class provides access to Google Apps specific dialog boxes. The methods in this class are only available for use in the context of a Google Spreadsheet.
176
Enum ButtonAn enum representing predetermined, localized dialog buttons returned by an alert or PromptResponse.getSelectedButton() to indicate which button in a dialog the user clicked. These values cannot be set; to add buttons to an alert or prompt, use ButtonSet instead.
177
Class ButtonSetAn enum representing predetermined, localized sets of one or more dialog buttons that can be added to an alert or a prompt. To determine which button the user clicked, use Button.
178
Class LoggerThis class allows the developer to write out text to the debugging logs.
179
Class MenuA custom menu in an instance of the user interface for a Google App. A script can only interact with the UI for the current instance of an open document or form, and only if the script is container-bound to the document or form. For more information, see the guide to menus.
180
Class MimeTypeAn enumeration that provides access to MIME-type declarations without typing the strings explicitly. Any method that expects a MIME type rendered as a string (for example, 'image/png') will also accept one of the values below, so long as the method supports the underlying MIME type.
181
Enum MonthAn enum representing the months of the year.
182
Class PromptResponseA response to a prompt dialog displayed in the user-interface environment for a Google App. The response contains any text the user entered in the dialog's input field and indicates which button the user clicked to dismiss the dialog.
183
Class SessionThe Session class provides access to session information, such as the user's email address (in some circumstances) and language setting.
184
Class UiAn instance of the user-interface environment for a Google App that allows the script to add features like menus, dialogs, and sidebars. A script can only interact with the UI for the current instance of an open editor, and only if the script is container-bound to the editor.
185
Class UserRepresentation of a user, suitable for scripting.
186
Enum WeekdayAn enum representing the days of the week.
187
188
CacheThis service allows a script to temporarily cache results that take time to fetch/compute. Public caches are for things that are not dependent on which user is accessing your script. Private caches are for things which are user-specific, like settings or recent activity.
189
Class CacheA reference to a particular cache. This class allows you to insert, retrieve, and remove items from a cache. This can be particularly useful when you want frequent access to an expensive or slow resource. For example, say you have an RSS feed at example.com that takes 20 seconds to fetch, but you want to speed up access on an average request.
190
Class CacheServiceCacheService allows you to access a cache for short term storage of data. This class lets you get a specific cache instance. Public caches are for things that are not dependent on which user is accessing your script. Private caches are for things which are user-specific, like settings or recent activity.
191
192
ChartsThis service allows users to create charts using Google Charts Tools, primarily within Ui Service interfaces.
193
Class AreaChartBuilderBuilder for area charts. For more details, see the Google Charts documentation.
194
Class BarChartBuilderBuilder for bar charts. For more details, see the Google Charts documentation.
195
Class CategoryFilterBuilderA builder for category filter controls.A category filter is a picker to choose one or more between a set of defined values. Given a column of type string, this control will filter out the rows that don't match any of the picked values.
196
Class ChartA Chart object, which can be embedded into documents, UI elements, or used as a static image. For charts embedded in spreadsheets, see EmbeddedChart.
197
Class ChartOptionsExposes options currently configured for a Chart, such as height, color, etc.Please see the visualization reference documentation for information on what options are available. Specific options for each chart can be found by clicking on the specific chart in the chart gallery.
198
Enum ChartTypeChart types supported by the Charts service.
199
Class ChartsEntry point for creating Charts in scripts.
200
Class ColumnChartBuilderBuilder for column charts. For more details, see the Google Charts documentation.
201
Enum ColumnTypeAn enumeration of the valid data types for columns in a DataTable.
202
Class ControlA user interface control object, that drives the data displayed by a DashboardPanel.A control can be embedded in a UI application. Controls are user interface widgets (category pickers, range sliders, autocompleters, etc.) users interact with in order to drive the data managed by a dashboard and the charts that are part of it. Controls collect user input and use the information to decide which of the data the dashboard is managing should be made available to the charts that are part of it. Given a data table, a control will filter out the data that doesn't comply with the conditions implied by its current state, and will expose the filtered data table as an output.
203
Enum CurveStyleAn enumeration of the styles for curves in a chart.
204
Class DashboardPanelA dashboard is a visual structure that enables the organization and management of multiple charts that share the same underlying data.
205
Class DashboardPanelBuilderA builder for a dashboard panel object. For an example of how to use DashboardPanelBuilder, refer to DashboardPanel.
206
Class DataTableA Data Table to be used in charts. A DataTable can come from sources such as Google Sheets or specified data-table URLs, or can be filled in by hand. This class intentionally has no methods: a DataTable can be passed around, but not manipulated directly.
207
Class DataTableBuilderBuilder of DataTable objects. Building a data table consists of first specifying its columns, and then adding its rows, one at a time.
208
Interface DataTableSourceInterface for objects that can represent their data as a DataTable.
209
Class DataViewDefinitionA data view definition for visualizing chart data.Data view definition can be set for charts to visualize a view derived from the given data table and not the data table itself. For example if the view definition of a chart states that the view columns are [0, 3], only the first and the third columns of the data table will be taken into consideration when drawing the chart. See DataViewDefinitionBuilder for an example on how to define and use aDataViewDefinition.
210
Class DataViewDefinitionBuilderBuilder for DataViewDefinition objects.
211
Class LineChartBuilderBuilder for line charts. For more details, see the Google Charts documentation.
212
Enum MatchTypeAn enumeration of how a string value should be matched.
213
Class NumberRangeFilterBuilderA builder for number range filter controls.A number range filter is a slider with two thumbs that lets the user select ranges of numeric values. Given a column of type number and matching options, this control will filter out the rows that don't match the range that was selected.
214
Enum OrientationAn enumeration of the orientation of an object.
215
Enum PickerValuesLayoutAn enumeration of how to display selected values in picker widget.
216
Class PieChartBuilderA builder for pie charts. For more details, see the Google Charts documentation.
217
Enum PointStyleAn enumeration of the styles of points in a line.
218
Enum PositionAn enumeration of legend positions within a chart.
219
Class ScatterChartBuilderBuilder for scatter charts. For more details, see the Google Charts documentation.
220
Class StringFilterBuilderA builder for string filter controls.A string filter is a simple text input field that lets the user filter data via string matching. Given a column of type string and matching options, this control will filter out the rows that don't match the term that's in the input field.
221
Class TableChartBuilderA builder for table charts. For more details, see the Google Charts documentation.
222
Class TextStyleA text style configuration object. Used in charts options to configure text style for elements that accepts it, such as title, horizontal axis, vertical axis, legend and tooltip.
223
Class TextStyleBuilderA builder used to create TextStyle objects. It allows configuration of the text's properties such as name, color, and size.
224
225
ContentThis service allows scripts to serve text in various forms, such as text, XML, or JSON. See also the guide to Content Service. If youdeploy the following script as a web app, you will see "Hello, world!" in the browser:
226
ContentServiceService for returning text content from a script.
227
MimeTypeAn enum for mime types that can be served from a script.
228
TextOutputA TextOutput object that can be served from a script.
229
230
HTMLThis service allows scripts to return HTML, usually as a user interface. See also the guide to Html Service, as well as the guide to Ui Service, which provides an alternate way to build user interfaces.
231
HtmlOutputAn HtmlOutput object that can be served from a script.
232
HtmlServiceService for returning HTML and other text content from a script.
233
HtmlTemplateA template object for dynamically constructing HTML.
234
SandboxModeAn enum representing the ECMAScript sandbox modes that can be used for client-side HtmlService scripts.
235
236
JDBCThis service allows scripts to connect to JDBC-compliant databases, including Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle. See also the guide to JDBC.
237
JdbcThe JDBC service allows scripts to connect to Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases.
238
JdbcArrayA JDBC Array.
239
JdbcBlobA JDBC Blob.
240
JdbcCallableStatementA JDBC CallableStatement.
241
JdbcClobA JDBC Clob.
242
JdbcConnectionA JDBC Connection.
243
JdbcDatabaseMetaDataA JDBC DatabaseMetaData.
244
JdbcDateA JDBC Date.
245
JdbcParameterMetaDataA JDBC ParameterMetaData.
246
JdbcPreparedStatementA JDBC PreparedStatement.
247
JdbcRefA JDBC Ref.
248
JdbcResultSetA JDBC ResultSet.
249
JdbcResultSetMetaDataA JDBC ResultSetMetaData.
250
JdbcRowIdA JDBC RowId.
251
JdbcSQLXMLA JDBC SQLXML.
252
JdbcSavepointA JDBC Savepoint.
253
JdbcStatementA JDBC Statement.
254
JdbcStructA JDBC Struct.
255
JdbcTimeA JDBC Time.
256
JdbcTimestampA JDBC Timestamp.
257
258
LockThis service allows scripts to prevents concurrent access to sections of code. This can be useful when you have multiple users or processes modifying a shared resource and want to prevent collisions.
259
LockA representation of a mutual-exclusion lock.
260
LockServicePrevents concurrent access to sections of code.
261
262
MailThis service allows scripts to send email on a user's behalf. See also Gmail Service. Unlike Gmail Service, Mail Service's sole purpose is sending email; it cannot access a user's Gmail account.
263
MailAppSends email.
264
265
OptimizationThe linear optimization service, used to model and solve linear and mixed-integer linear programs.
266
LinearOptimizationConstraintObject storing a linear constraint of the form lowerBound ≤ Sum(a(i) x(i)) ≤ upperBoundwhere lowerBound and upperBound are constants, a(i) are constant coefficients and x(i) are variables (unknowns).
267
LinearOptimizationEngineThe engine used to model and solve a linear program.
268
LinearOptimizationServiceThe linear optimization service, used to model and solve linear and mixed-integer linear programs.
269
LinearOptimizationSolutionThe solution of a linear program.
270
StatusStatus of the solution.
271
VariableTypeType of variables created by the engine.
272
273
PropertiesThis service allows scripts to store strings as key-value pairs scoped to one script, one user of a script, or one document in which anadd-on is used. For more information about when to use each type of property, see the guide to the Properties service.
274
PropertiesThe properties object acts as the interface to access user, document, or script properties.
275
PropertiesServiceAllows scripts to store simple data in key-value pairs scoped to one script, one user of a script, or one document in which an add-on is used.
276
ScriptPropertiesScript Properties are key-value pairs stored by a script in a persistent store.
277
UserPropertiesUser Properties are key-value pairs unique to a user.
278
279
ScriptThis service provides access to script triggers and script publishing.
280
AuthModeAn enumeration that identifies which categories of authorized services Apps Script is able to execute through a triggered function.
281
AuthorizationInfoAn object used to determine whether the user needs to authorize this script to use one or more services, and to provide the URL for an authorization dialog.
282
AuthorizationStatusAn enumeration denoting the authorization status of a script.
283
ClockTriggerBuilderA builder for clock triggers.
284
DocumentTriggerBuilderA builder for document triggers.
285
EventTypeAn enumeration denoting the type of triggered event.
286
FormTriggerBuilderA builder for form triggers.
287
ScriptAppAccess and manipulate script publishing and triggers.
288
ServiceAccess and manipulate script publishing.
289
Service.Restriction
290
SpreadsheetTriggerBuilderBuilder for spreadsheet triggers.
291
StateTokenBuilderAllows scripts to create state tokens that can be used in callback APIs (like OAuth flows).
292
TriggerA script trigger.
293
TriggerBuilderA generic builder for script triggers.
294
TriggerSourceAn enumeration denoting the source of the event that causes the trigger to fire.
295
296
URL Fetch
297
Utilities
298
XML