• 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

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

• Drive Items

<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

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

gdoc <UserGoogleDoc>

Read a Drive file with MIME type text/html.

ghtml <UserGoogleDoc>

<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 [email protected] <DriveFileIDEntity> "Sheet 1" gam create user firstname "~FirstName" lastname "~lastName" email "~email"

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 command and make these settings:

gam user [email protected] update serviceaccount

[ ] 20)  Drive API (supports readonly)
[*] 21)  Drive API - read command data
[ ] 42)  Sheets API (supports readonly)
[*] 43)  Sheets API - read command data

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

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

gcscsv <StorageBucketObjectName>

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

gcsdoc <StorageBucketObjectName>

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

gcshtml <StorageBucketObjectName>