Navigation
Google Workspace SSO image 1

Google Workspace SSO

JavaScript API Integration Google Apps Script Google Sheets Google Docs Google Workspace

Single Sign-On Azure AAD Google Workspace

I want to develop a Google Workspace Add-on. It will work in Google Sheets, Docs, and Slides to begin with. It will be an
icon on the right-hand side, which you can click and expand to enter information. You will be able to enter information from:
-2-4 different dropdown lists.
-1-2 text description fields
Also, the Add-on will:
-Save all fields in a Firebase Firestore instance, which I have set up.
-Save along with these fields some kind of immutable ID (document ID, as it's known to Google, perhaps) so that next
time you open the doc or click refresh, the fields from Firestore are loaded up into the Add-on.
-Have a button available that triggers a separate action, which will load another simple record into Firestore.

Optional: A key that the user can enter to access Firestore. Presumably, this would require some Firestore
(possibly Functions?) implementation. This is optional.

JavaScript API Integration Google Apps Script Google Sheets Google Docs Google Workspace
Back to Portfolio