Google form responses?

This topic contains 1 reply, has 2 voices, and was last updated by Profile photo of Tim Pringle Tim Pringle 1 year, 3 months ago.

  • Author
  • #27649
    Profile photo of Vincent Morris
    Vincent Morris

    Is there any way I can use powershell to submit data to a google form easily?

    Basically I have a couple hundred PCs with an Asset Tag Configured into the bios, and using PS I can pull that data, along with a PC name. So I want to create a script that gathers this data, then sends it to a google form with two fields, PC_Name

    Post @PC_Name = $Name
    Post @AssetTag = $Asset Tag

    So at the end of the day I have a nice spread sheet managed with Google sheets.

    Is this possible to do with powershell, or is there a better solution?

  • #27655
    Profile photo of Tim Pringle
    Tim Pringle

    Hey Vincent,

    The best way to do this would be via Google's Sheets API. Take a look at their documentation for this, link below. They have a .NET library available and examples which should make this easier to work into a PowerShell script.

You must be logged in to reply to this topic.