Command Data From Google Docs Sheets Storage

Command data from Google Docs, Sheets and Cloud Storage

• Introduction
• Definitions
• Read data from a Google Doc or Drive File
  • Plain Text
  • HTML
• Read data from a Google Sheet
• Limited Service Account Access
• Read data from a Google Cloud Storage File
  • Plain Text
  • CSV
  • HTML

Introduction

Google Sheets can be used in gam csv ... commands.

• Bulk Processing

Google Docs and Sheets can be used to specify collections of data.

• Collections of ChromeOS Devices
• Collections of Items
• Collections of Users

Google Docs and Drive Files can be used to specify notes, messages and signatures.

• Domain Shared Contacts - Global Address List
• Send Email
• Users
• Users - Contacts
• Users - Gmail - Messages/Threads
• Users - Gmail - SendAs/Signature/Vacation

Definitions

• Drive Items

Read data from a Google Doc or Drive File

<UserGoogleDoc> ::=
        <EmailAddress> <DriveFileIDEntity>|<DriveFileNameEntity>|(<SharedDriveEntity> <SharedDriveFileNameEntity>)

• <EmailAddress> - The email address of a user with at least read access to the document

Use one of the following to specify the file:

• <DriveFileIDEntity> - The ID of the file on a Drive or Shared Drive
• <DriveFileNameEntity> - The name of the file
• <SharedDriveEntity> <SharedDriveFileNameEntity> - A Shared Drive and the name of the file on that drive

Plain Text

Interpret a Google Doc as plain text or read a Drive file with MIME type text/plain.

gdoc <UserGoogleDoc>

HTML

Read a Drive file with MIME type text/html.

ghtml <UserGoogleDoc>

Read data from a Google Sheet

<SheetEntity> ::= <String>|id:<Number>

<UserGoogleSheet> ::=
        <EmailAddress> <DriveFileIDEntity>|<DriveFileNameEntity>|(<SharedDriveEntity> <SharedDriveFileNameEntity>) <SheetEntity>

• <EmailAddress> - The email address of a user with at least read access to the document

Use one of the following to specify the file:

• <DriveFileIDEntity> - The ID of the file on a Drive or Shared Drive
• <DriveFileNameEntity> - The name of the file
• <SharedDriveEntity> <SharedDriveFileNameEntity> - A Shared Drive and the name of the file on that drive

If a file name is specified, it must resolve to a single file ID; otherwise an error is generated.

If a Shared Drive name is specified, it must resolve to a single Shared Drive ID; otherwise an error is generated.

Select a sheet/tab from the Google Sheet with its ID or name; it is verified to exist within the Google Sheet.

Example:

gam csv gsheet you@exmaple.com <DriveFileIDEntity> "Sheet 1" gam create user firstname "~FirstName" lastname "~lastName" email "~email"

Limited Service Account Access

If you want to disable a user's service account access to Drive and Sheets but still allow reading command data from Google Docs and Sheets, issue the following commands. The admin specified in gam oauth create can read command data from Docs and Sheets to which it has access.

gam config commanddata_clientaccess true save
gam oauth create
Enable the following and proceed to authorization.

[*] 42)  Drive API - commanddata_clientaccess
[*] 54)  Sheets API - commanddata_clientaccess

In these options, the <EmailAddress> is not used, but for clarity you may want to specify the email address of the admin specified in gam oauth create`.

gdoc <EmailAddress> <DriveFileIDEntity>|<DriveFileNameEntity>|(<SharedDriveEntity> <SharedDriveFileNameEntity>)
gsheet <EmailAddress> <DriveFileIDEntity>|<DriveFileNameEntity>|(<SharedDriveEntity> <SharedDriveFileNameEntity>) <SheetEntity>

Read data from a Google Cloud Storage File

<StorageBucketName> ::= <String>
<StorageObjectName> ::= <String>
<StorageBucketObjectName> ::=
        https://storage.cloud.google.com/<StorageBucketName>/<StorageObjectName>|
        https://storage.googleapis.com/<StorageBucketName>/<StorageObjectName>|
        gs://<StorageBucketName>/<StorageObjectName>|
        <StorageBucketName>/<StorageObjectName>

CSV

Read a Google Cloud Storage file with contentType text/csv.

gcscsv <StorageBucketObjectName>

Plain Text

Read a Google Cloud Storage file with contentType text/plain.

gcsdoc <StorageBucketObjectName>

HTML

Read a Google Cloud Storage file with contentType text/html.

gcshtml <StorageBucketObjectName>