Parse Range

The Parse Range action converts A1 notation into structured fields without calling Google Sheets.

Inputs

Input	Type	Required	Description
Range	String	Yes	A1 notation such as `Sheet1!A1:B2` or `A:C`.

Input column letters must be uppercase and contain no more than three letters. Quoted sheet names are accepted.

Output	Type	Description
Sheet Name	String	Sheet qualifier, or empty when omitted.
Start Column Letter	String	Starting column letter.
Start Column Number	Number	One-based starting column number.
Start Row	Number	Starting row, or empty for full-column ranges.
End Column Letter	String	Ending column letter, when present.
End Column Number	Number	One-based ending column, when present.
End Row	Number	Ending row, when present.
Is Single Cell?	Boolean	Whether the notation identifies one cell.

Invalid range format

Use uppercase A1 notation. Examples include A1, A1:B20, A:C, and 'Sales Data'!B2:D10.