Useful functions:
- QUERY GSheets
- ARRAYFORMULA
- Indirect
- Xlookup
Accessing google sheets from a script: https://www.youtube.com/watch?v=zCEJurLGFRk
Related: Excel vs Google Sheets
Useful functions:
Accessing google sheets from a script: https://www.youtube.com/watch?v=zCEJurLGFRk
Related: Excel vs Google Sheets