PowerShell and Google Sheets

This topic contains 3 replies, has 2 voices, and was last updated by  Brian Clanton 11 months, 2 weeks ago.

  • Author
  • #76891

    Brian Clanton

    Anyone have any experience or can reference a tutorial on how to upload, submit, change data in Google Sheets with PowerShell?

    Goal is to gather Server information across our farm (hardware, plugins, software version, etc..) to then keep a report in our company google Sheets account.

    I see that Cdata has a module you can buy, but was wondering if anyone has had any luck or can reference an example of using google Sheets API.

  • #76912


    Google is your friend.

  • #77029

    Brian Clanton

    Yes thank you for that link. You see that I referenced CData in my post, which is the link you posted back.

  • #77262

    Brian Clanton

    After much searching, it appears you do not have to purchase CMDLETS from CDATA but there is a tutorial for interfacing with Google API that google makes available. There is a 'Google Cloud' module that allows for interfacing with public Google API's.

    Including this info in case anyone is also looking for this documentation.


You must be logged in to reply to this topic.