search

taers232c / GAMADV-XTD3

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

[Question] Query email when using command data from Google Sheets #320

Closed iKeqing closed 1 year ago

iKeqing commented 1 year ago

Hi Ross,

I tried using the gam command below to collect data from google sheets but it seems doesn't work, can you help to have a look at how to fix it? I believe is somewhere wrong with after:"~Date" & from:"~Email", how can I use : with ""?

gam csv gsheet it@xxx.com 1V6yO1Jy4mgnAwZ1o7S3a6W3l6aNRs0 "Sheet1" gam user "~Email" print messages query after:"~Date" and query from:"~Email" headers all showattachments todrive tduser it@xxx.com

Thanks in advance.

taers232c commented 1 year ago

You want:

When you embed a CSV column name in an argument, you surround it with ~~

I'm assuming that you want one todrive upload, so I corrected for that.

gam redirect csv - multiprocess todrive tduser @. @.> csv gsheet @. @.> 1V6yO1Jy4mgnAwZ1o7S3a6W3l6aNRs0 "Sheet1" gam user "~Email" print messages query "after:Date from:Email" headers all showattachments

Ross

Ross Scroggs @.***

On Dec 29, 2022, at 8:21 PM, iKeqing @.***> wrote:

Hi Ross,

I tried using the gam command below to collect data from google sheets but it seems doesn't work, can you help to have a look at how to fix it? I believe is somewhere wrong with after:"~Date" & from:"~Email", how can I use : with ""?

gam csv gsheet @. @.> 1V6yO1Jy4mgnAwZ1o7S3a6W3l6aNRs0 "Sheet1" gam user "~Email" print messages query after:"~Date" and query from:"~Email" headers all showattachments todrive tduser @. @.> Thanks in advance.

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/320, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACCTYL4TNUCVXUWLVDMA2D3WPZPNRANCNFSM6AAAAAATMTDXJQ. You are receiving this because you are subscribed to this thread.

taers232c commented 1 year ago

See: https://github.com/taers232c/GAMADV-XTD3/wiki/Bulk-Processing#csv-files

Scroll down to just above the line Example

Ross

Ross Scroggs @.***

On Dec 29, 2022, at 8:21 PM, iKeqing @.***> wrote:

Hi Ross,

I tried using the gam command below to collect data from google sheets but it seems doesn't work, can you help to have a look at how to fix it? I believe is somewhere wrong with after:"~Date" & from:"~Email", how can I use : with ""?

gam csv gsheet @. @.> 1V6yO1Jy4mgnAwZ1o7S3a6W3l6aNRs0 "Sheet1" gam user "~Email" print messages query after:"~Date" and query from:"~Email" headers all showattachments todrive tduser @. @.> Thanks in advance.

— Reply to this email directly, view it on GitHub https://github.com/taers232c/GAMADV-XTD3/issues/320, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACCTYL4TNUCVXUWLVDMA2D3WPZPNRANCNFSM6AAAAAATMTDXJQ. You are receiving this because you are subscribed to this thread.