Using tdaddsheet to add a tab to an existing sheet

125 views
Skip to first unread message

Simon Laycock

unread,
Jan 7, 2021, 1:56:56 PM1/7/21
to GAM for Google Workspace
I'm trying to use Advanced GAM to add the latest Classroom interaction data to an existing Google Sheet. My plan is to run this as a scheduled task on a daily basis then do some analysis in the spreadsheet in another tab.

I'm trying (aaaaaaaaaaaaaaaaaaa11111  is a placeholder file id, obviously):

gam report user ou /Students parameters classroom:timestamp_last_interaction todrive tdfileid aaaaaaaaaaaaaaaaaaa11111 tdtitle "Classroom Daily Activity Report" tdaddsheet tdsheet ""

I've gradually removed bits from the example James posted here but I can't figure out where I'm going wrong...

All help gratefully received.

Simon

Ross Scroggs

unread,
Jan 7, 2021, 2:17:49 PM1/7/21
to google-ap...@googlegroups.com

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/74052e06-ee82-4758-ae4b-e81fa721dcbcn%40googlegroups.com.


--

Cassie Danaher

unread,
Feb 8, 2022, 4:31:20 PM2/8/22
to GAM for Google Workspace
I'm running a similar process and I want it to run weekly.  However it can't update because the string after tdtitle already exists.  Is there a way to also add the date that it is run? 

Ross Scroggs

unread,
Feb 8, 2022, 4:48:55 PM2/8/22
to google-ap...@googlegroups.com
Cassie,

I believe we can get you where you want but I'm slightly confused.
What can't be updated? Show me the command and describe what yiu want.

Ross Scroggs

unread,
Feb 8, 2022, 5:01:43 PM2/8/22
to google-ap...@googlegroups.com
On Feb 8, 2022, at 1:31 PM, 'Cassie Danaher' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Ross Scroggs

unread,
Feb 8, 2022, 5:24:31 PM2/8/22
to google-ap...@googlegroups.com
Cassie,

If you're trying to update an existing tab within an existing sheet, but the tab has a variable name, use it's id instead of its name.



tdfileid <DriveFileId> tdsheet id:12345 tdupdatesheet

The sheet id is the number after gid= at the end of the URL.

On Feb 8, 2022, at 1:31 PM, 'Cassie Danaher' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

Cassie Danaher

unread,
Feb 8, 2022, 5:43:52 PM2/8/22
to google-ap...@googlegroups.com
This is what I have 

 gam all users print forwardingaddresses todrive tdparent id:shareddriveidhere tdfileid "fileidhere" tdaddsheet tdtitle "Titleofthenewtab" tdsheettimeformat “%B %Y” tdnobrowser tdnoemail 


You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/jkPbFFL1cz4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CD3790E5-C609-4E20-A468-BF109DADB17E%40gmail.com.

Ross Scroggs

unread,
Feb 8, 2022, 6:29:06 PM2/8/22
to google-ap...@googlegroups.com
Cassie,

Contact me directly via Meet/Zoom

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CACQ2waGdrhyaXxvVoBbRipXjVNrhRjUXOKsNCJe30%3D%3DnNH8fbg%40mail.gmail.com.


--
Reply all
Reply to author
Forward
0 new messages