Topics

• Getting started with google-apps-script
• Getting started with google-spreadsheet
• Query Function
• Using arrays in Google Sheets
• Create a custom function for Google Sheets

Examples

• Installation or Setup
• Installation or Setup
• Introduction into queries
• Array of literals
• Standard gravity custom constant
• Filter a query by an aggregation result
• Returning a range as an array
• Append column with row numbering