search

taers232c / GAMADV-XTD3

Command line tool to manage Google Workspace
732 stars 86 forks source link

Run Commands from Google Sheet #120

Closed mthrelfo2 closed 3 years ago

mthrelfo2 commented 3 years ago

I want to be able to run commands from a Google Sheet. Currently, I have the following command: gam csv gsheet <<USER>> <<FILEID>> <<SHEET>> gam user ~User ~Command

It pulls the sheet and the ~User field works, however, the command one doesn't work because it is adding "" to the start and end of the command. Currently, the command is just "print delegates", but might be more complicated in the future.

How can I make it put the command in without having to do a different column for each word.

taers232c commented 3 years ago

This will not work as ~Command is taken as a single argument, not as a list of arguments as you desire. To get what you want would require a column per word.

You can make a Google Doc with gam commands and execute it as a batch file. For example, the Google Doc GamBatch contains the following lines: gam user testuser1 print delegates gam user testuser2 print delegates

gam batch gdoc <<USER>> <<FILEID>>