The maximum number of results to return per page from Google Sheets.

Syntax

Connect-GoogleSheets -Pagesize int

Data Type

int

Default Value

1000

Remarks

The Pagesize property affects the maximum number of results to return per page from Google Sheets. While the data source optimizes the default page size for most use cases, you may need to adjust this value depending on the specific object or service endpoint you are querying. Increasing the page size may improve performance, but it could also result in higher memory consumption per page.