One can use two differenta approaches when developing an app that interfaces with google applicattions
- Google App Script
- Google APIs.
This path mostly focues on automating tasks when working with G Suite (Google Workspaces) apps. Think MS Office / Excel Macro.
You can stretch abilities of Google App Script quite a bit. You can even write web apps with standard JS mixed in.