Use Sheety as an API for Powershell. Using pokemons as an example.

Sheety-Pokemons.ps1

$url = "https://v2-api.sheety.co/randomstringnameforGoogleSheet/test/pokemons"
$contentType = "application/json"      
$method = "POST" # GET DELETE PUT alternatively

$json = @"
{
  "pokemon": {
      "id": 723,
      "number": 722, 
      "name": "Weepinball", 
      "areasOfEncounter": "Route 12 + Route 13 + Route 12 (XY)", 
      "encounterType": "Grass", 
      "caught": "true"
    }
} 
"@

Invoke-RestMethod -Method $method -Uri $url -ContentType $contentType -Body $json