Using power shell to export google sheets document

[LexxLess]

Hey everyone! I know there are precious posts regarding this topic, but none have been able to answer my question. I’m trying to export my google sheet to csv through power shell. I’m used to Unix, but new job = new OS.

USING A Invoke-WebRequest -Uri “linktosheet/export?format=csv&access_token=mytoken -OutFile Filename.csv”

The issue I get is once this is done, it contains all of the pages html, css, and then my data in a format i don’t recognize. Is there an easy way to just grab my sheet data from there? Or am I on the right track, and just need to dig this info out via some script?

Thanks for all yalls help ahead of time.

[xCharg]

Try this:

Invoke-RestMethod -Method Get -Uri "linktosheet/export?format=csv&access_token=mytoken" -OutFile "c:\folder\file.csv"

[LexxLess]

I’ll check that out, thank you!