utils

Get credentials.

Import googleapiclient.discovery.build function.

Build a Google Sheets service with OAuth2 credentials (full access).

Build a Google Sheets service with API key (read-only access).

Validate and normalize a Google Spreadsheet ID.

Validate A1 notation range format.

Supports:

• Single cells: 'A1', 'Z99'
• Areas: 'A1:B2'
• Whole columns: 'A:A', 'B:D'
• Whole rows: '1:1', '5:10'
• Sheet-qualified: 'Sheet1!A1', "'My Sheet'!A1:B2"
• Named ranges: 'MyData', 'Sales_2024'

Validate and normalize a range name.

Permissive A1 validator. Supports:

• Single cells: 'A1', 'Z99'
• Areas: 'A1:B2'
• Whole columns: 'A:A', 'B:D'
• Whole rows: '1:1', '5:10'
• Sheet-qualified: 'Sheet1!A1', "'My Sheet'!A1:B2"
• Named ranges: 'MyData', 'Sales_2024'