Author Posts

July 17, 2015 at 12:15 pm

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?

July 18, 2015 at 7:13 am

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.

https://developers.google.com/google-apps/spreadsheets/