google2csv.ps1

param (
	[string]$Query
)

$apiKey = "" # https://console.cloud.google.com/apis/credentials
$cseId = "" # https://programmablesearchengine.google.com/
$results = @()

$encodedQuery = [System.Uri]::EscapeDataString($Query)

for ($start = 1; $start -le 91; $start += 10) {
	$url = "https://www.googleapis.com/customsearch/v1?key=$apiKey&cx=$cseId&q=$encodedQuery&num=10&start=$start"

	Write-Host "Request URL: $url"

	try {
		$response = Invoke-RestMethod -Uri $url -Method Get
		if ($response.items) { $results += $response.items }
	} catch {
		Write-Error "Request failed: $($_.Exception.Message)"
	}
	Start-Sleep -Milliseconds 200
}

$safeQuery = ($Query -replace '[:\\\/\?\*\|"<>\+]', '_')
$date = Get-Date -Format "yyyy-MM-dd"
$outFile = "{0}_{1}_results.csv" -f $date, $safeQuery

$results | Select-Object title, link, snippet | Export-Csv $outFile -NoTypeInformation
Write-Output "Saved $($results.Count) results to $outFile"