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?
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.