Topics

• Spreadsheet Service
• Text to Speech(TTS)
• DriveApp Service - Files by type and search string
• Spreadsheet Add Menu
• Google sheets MailApp
• DriveApp
• GmailApp

Examples

• Create a new folder in a Google Drive root
• Sheet
• Text to Speech Base
• Create new file in Google Drive of a certain Mime type
• Create a new text file in Google Drive root folder
• Create a new file in Google drive from a blob
• Get all folders - put folders into a continuation token - then retrieve from token
• Get all files - put them into a continuation token - then retrieve them
• Add a folder to the root drive
• Create a new text file and add it to the root folder
• Get files by file type with matching string in file name
• Create a new menu
• Copy a value from one sheet to current sheet
• Get all Files in a Drive Folder
• A basic MailApp Example
• Access data from sheet
• Use Sheet data to send email
• Sending HTML content in mail
• Get CSV file attached to a mail
• Get the last row in a single column