@appsparkler/spreadsheet-editor
v1.0.0
Published
- Visit [Google Cloud Console][google-cloud-console] - Create a new project or select an existing project to enable the Google Sheets API. - Create a `Service Account` with `Owner` access. - Create a `KEY` for the newly added `Service Account`. This key w
Downloads
5
Readme
Editing Google Sheet With Service Account
- Visit Google Cloud Console
- Create a new project or select an existing project to enable the Google Sheets API.
- Create a
Service Account
withOwner
access. - Create a
KEY
for the newly addedService Account
. This key would be automatically downloaded which we'll use to authenticate theRobot User
. - Visit
APIs and Services > Library
and ENABLE theGoogle Sheets API
to interact with aGoogle Sheet
. - Create a
Google Sheet
in your user account and click onShare
. Share it with theRobot User
- the email would be something likeservice-accountu3928492@appsparkler-sheet-editor.iam.gserviceaccount.com
withEditor
access.
Service Account is a fancy name for a
Robot User
.
Now you can read, write, append cell values for any spreadsheet to which the Robot User has access to.