PowerShell and Google Sheets

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

  • Author
    Posts
  • #76891

    Brian Clanton
    Participant

    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

    Ivan
    Participant

    Google is your friend.

  • #77029

    Brian Clanton
    Participant

    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
    Participant

    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.

    https://cloud.google.com/tools/powershell/docs/

You must be logged in to reply to this topic.