Set up Google Sheets
alphaSetup guide coming soon. Google Sheets has no step-by-step guide in the catalogue yet. Until it does, here is what a connection needs, and where to read more.
What a connection holds
| Field | Secret | Where it comes from |
|---|---|---|
OAuth client IDclientId | Not secret | From Google Cloud Console -> APIs & Services -> Credentials. ONE value for the whole installation, not per connected account. |
OAuth client secretclientSecret | Secret | The client secret for the same OAuth app. One value for the whole installation. |
Access tokenaccessToken | Secret | Per connected Google account, and it expires after ONE HOUR. The host refreshes it with the refresh token. |
Refresh tokenrefreshToken | Secret | Per connected Google account. Google issues one only when the consent request asks for offline access; without it the connection dies within the hour. |
Links
Google Sheets API docs
Consent is requested at https://accounts.google.com/o/oauth2/v2/auth
React (editor surface, every host)
@particle-academy/google-sheets-ui v0.7.1
