Skip to main content
Google Workspace
  • Google Workspace
Home Apps Script All products
  • Google Workspace apps
  • Admin console
  • Cloud Search
  • Gmail
  • Google Calendar
  • Google Chat
  • Google Classroom
  • Google Docs
  • Google Drive
  •  
  • Google Forms
  • Google Keep
  • Google Meet
  • Google Sheets
  • Google Sites
  • Google Slides
  • Google Tasks
  • Google Vault
  • Extend, automate & share
  • Add-ons
  • Apps Script
  • Chat apps
  • Drive apps
  • Marketplace
Resources
  • Tools
  • Admin console
  • Apps Script dashboard
  • Google Cloud console
  • APIs Explorer
  • Card Builder
  • Training & support
  • How to get started
  • Codelabs
  • Developer support
  • Updates
  • Release notes
  • Developer Previews
  • YouTube
  • Newsletter
  • X (Twitter)
  • Blog
/
  • English
  • Deutsch
  • Español
  • Español – América Latina
  • Français
  • Indonesia
  • Italiano
  • Polski
  • Português – Brasil
  • Tiếng Việt
  • Türkçe
  • Русский
  • עברית
  • العربيّة
  • فارسی
  • हिंदी
  • বাংলা
  • ภาษาไทย
  • 中文 – 简体
  • 中文 – 繁體
  • 日本語
  • 한국어
Sign in
  • Apps Script
Overview Guides Reference Samples Support
Google Workspace
  • Google Workspace
  • Home
  • Apps Script
    • Overview
    • Guides
    • Reference
    • Samples
    • Support
  • All products
    • More
  • Resources
    • More
  • Overview
  • Google Workspace services
  • Admin Console
    • Advanced services
    • Directory API
    • Enterprise License Manager API
    • Groups Migration API
    • Groups Settings API
    • Reseller API
    • Reports API
  • Calendar
    • Overview
    • CalendarApp
    • Classes
    • Calendar
    • CalendarEvent
    • CalendarEventSeries
    • EventGuest
    • EventRecurrence
    • RecurrenceRule
    • Enums
    • Color
    • EventColor
    • EventTransparency
    • EventType
    • GuestStatus
    • Visibility
    • Advanced services
    • Calendar API
  • Chat
    • Advanced services
    • Chat API
  • Docs
    • Overview
    • DocumentApp
    • Classes
    • Body
    • Bookmark
    • ContainerElement
    • Date
    • Document
    • DocumentTab
    • Equation
    • EquationFunction
    • EquationFunctionArgumentSeparator
    • EquationSymbol
    • FooterSection
    • Footnote
    • FootnoteSection
    • HeaderSection
    • HorizontalRule
    • InlineDrawing
    • InlineImage
    • ListItem
    • NamedRange
    • PageBreak
    • Paragraph
    • Person
    • Position
    • PositionedImage
    • Range
    • RangeBuilder
    • RangeElement
    • RichLink
    • Tab
    • Table
    • TableCell
    • TableOfContents
    • TableRow
    • Text
    • UnsupportedElement
    • Interfaces
    • Element
    • Enums
    • Attribute
    • ElementType
    • FontFamily
    • GlyphType
    • HorizontalAlignment
    • ParagraphHeading
    • PositionedLayout
    • TabType
    • TextAlignment
    • VerticalAlignment
    • Advanced services
    • Docs API
  • Drive
    • Overview
    • DriveApp
    • Classes
    • File
    • FileIterator
    • Folder
    • FolderIterator
    • User
    • Enums
    • Access
    • Permission
    • Advanced services
    • Drive API
    • Drive Activity API
    • Drive Labels API
  • Forms
    • Overview
    • FormApp
    • Classes
    • CheckboxGridItem
    • CheckboxGridValidation
    • CheckboxGridValidationBuilder
    • CheckboxItem
    • CheckboxValidation
    • CheckboxValidationBuilder
    • Choice
    • DateItem
    • DateTimeItem
    • DurationItem
    • Form
    • FormResponse
    • GridItem
    • GridValidation
    • GridValidationBuilder
    • ImageItem
    • ItemResponse
    • ListItem
    • MultipleChoiceItem
    • PageBreakItem
    • ParagraphTextItem
    • ParagraphTextValidation
    • ParagraphTextValidationBuilder
    • QuizFeedback
    • QuizFeedbackBuilder
    • RatingItem
    • ScaleItem
    • SectionHeaderItem
    • TextItem
    • TextValidation
    • TextValidationBuilder
    • TimeItem
    • VideoItem
    • Interfaces
    • Item
    • Enums
    • Alignment
    • DestinationType
    • FeedbackType
    • ItemType
    • PageNavigationType
    • RatingIconType
  • Gmail
    • Overview
    • GmailApp
    • Classes
    • GmailAttachment
    • GmailDraft
    • GmailLabel
    • GmailMessage
    • GmailThread
    • Advanced services
    • Gmail API
  • Sheets
    • Overview
    • SpreadsheetApp
    • Classes
    • Banding
    • BooleanCondition
    • CellImage
    • CellImageBuilder
    • Color
    • ColorBuilder
    • ConditionalFormatRule
    • ConditionalFormatRuleBuilder
    • ContainerInfo
    • DataSource for Connected Sheets
      • BigQueryDataSourceSpec
      • BigQueryDataSourceSpecBuilder
      • DataExecutionStatus
      • LookerDataSourceSpec
      • LookerDataSourceSpecBuilder
      • DataSource
      • DataSourceChart
      • DataSourceColumn
      • DataSourceFormula
      • DataSourceParameter
      • DataSourcePivotTable
      • DataSourceRefreshSchedule
      • DataSourceRefreshScheduleFrequency
      • DataSourceSheet
      • DataSourceSheetFilter
      • DataSourceSpec
      • DataSourceSpecBuilder
      • DataSourceTable
      • DataSourceTableColumn
      • DataSourceTableFilter
    • DataValidation
    • DataValidationBuilder
    • DateTimeGroupingRule
    • DeveloperMetadata
    • DeveloperMetadataFinder
    • DeveloperMetadataLocation
    • Drawing
    • EmbeddedAreaChartBuilder
    • EmbeddedBarChartBuilder
    • EmbeddedChart
    • EmbeddedChartBuilder
    • EmbeddedColumnChartBuilder
    • EmbeddedComboChartBuilder
    • EmbeddedHistogramChartBuilder
    • EmbeddedLineChartBuilder
    • EmbeddedPieChartBuilder
    • EmbeddedScatterChartBuilder
    • EmbeddedTableChartBuilder
    • Filter
    • FilterCriteria
    • FilterCriteriaBuilder
    • GradientCondition
    • Group
    • NamedRange
    • OverGridImage
    • PageProtection
    • PivotFilter
    • PivotGroup
    • PivotGroupLimit
    • PivotTable
    • PivotValue
    • Protection
    • Range
    • RangeList
    • RichTextValue
    • RichTextValueBuilder
    • Selection
    • Sheet
    • Slicer
    • SortSpec
    • Spreadsheet
    • SpreadsheetTheme
    • TextFinder
    • TextRotation
    • TextStyle
    • TextStyleBuilder
    • ThemeColor
    • Enums
    • AutoFillSeries
    • BandingTheme
    • BooleanCriteria
    • BorderStyle
    • CopyPasteType
    • DataSource for Connected Sheets
      • DataExecutionErrorCode
      • DataExecutionState
      • DataSourceParameterType
      • DataSourceRefreshScope
      • DataSourceType
    • DataValidationCriteria
    • DateTimeGroupingRuleType
    • DeveloperMetadataLocationType
    • DeveloperMetadataVisibility
    • Dimension
    • Direction
    • FrequencyType
    • GroupControlTogglePosition
    • InterpolationType
    • PivotTableSummarizeFunction
    • PivotValueDisplayType
    • ProtectionType
    • RecalculationInterval
    • RelativeDate
    • SheetType
    • SortOrder
    • TextDirection
    • TextToColumnsDelimiter
    • ThemeColorType
    • ValueType
    • WrapStrategy
    • Advanced services
    • Sheets API
  • Slides
    • Overview
    • SlidesApp
    • Classes
    • AffineTransform
    • AffineTransformBuilder
    • AutoText
    • Autofit
    • Border
    • Color
    • ColorScheme
    • ConnectionSite
    • Fill
    • Group
    • Image
    • Layout
    • Line
    • LineFill
    • Link
    • List
    • ListStyle
    • Master
    • NotesMaster
    • NotesPage
    • Page
    • PageBackground
    • PageElement
    • PageElementRange
    • PageRange
    • Paragraph
    • ParagraphStyle
    • PictureFill
    • Point
    • Presentation
    • Selection
    • Shape
    • SheetsChart
    • Slide
    • SolidFill
    • SpeakerSpotlight
    • Table
    • TableCell
    • TableCellRange
    • TableColumn
    • TableRow
    • TextRange
    • TextStyle
    • ThemeColor
    • Video
    • WordArt
    • Enums
    • AlignmentPosition
    • ArrowStyle
    • AutoTextType
    • AutofitType
    • CellMergeState
    • ContentAlignment
    • DashStyle
    • FillType
    • LineCategory
    • LineFillType
    • LineType
    • LinkType
    • ListPreset
    • PageBackgroundType
    • PageElementType
    • PageType
    • ParagraphAlignment
    • PlaceholderType
    • PredefinedLayout
    • SelectionType
    • ShapeType
    • SheetsChartEmbedType
    • SlideLinkingMode
    • SlidePosition
    • SpacingMode
    • TextBaselineOffset
    • TextDirection
    • ThemeColorType
    • VideoSourceType
    • Advanced services
    • Slides API
  • Workspace
    • Advanced services
    • Events API
  • More...
    • Classroom
      • Advanced services
      • Classroom API
    • Groups
      • Overview
      • GroupsApp
      • Classes
      • Group
      • Enums
      • Role
      • Advanced services
      • Cloud Identity Groups API
      • Migrate from Groups Service
    • People
      • Advanced services
      • People API
      • Migrate from Contacts service
      • Contacts
      • Overview
      • ContactsApp
      • Classes
      • AddressField
      • CompanyField
      • Contact