MCP Server for Google Sheets

Build 25.0.9440

TypeDetectionScheme

Determines how to determine the data types of columns.

Possible Values

None, RowScan

Data Type

string

Default Value

"RowScan"

Remarks

NoneSetting TypeDetectionScheme to None returns all columns as the string type. Note: Even when set to None, the column names are still scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan scans rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. Setting this to -1 directs the driver to scan the entire sheet.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440