V2.1 | Gsheet

| Error Type | Retry? | Max Retries | Backoff | |------------|--------|-------------|---------| | 429 (rate limit) | Yes | 5 | 2^N seconds | | 500-502 (server error) | Yes | 3 | 1s, 2s, 4s | | 404 (sheet missing) | No | N/A | N/A | | 403 (permission) | No | N/A | N/A |

Results from AWS t3.micro instance, us-central1 region. from gsheet import GSheetClient client = GSheetClient( credentials="service_account.json", spreadsheet_id="1abc...xyz" ) Read a range data = client.read("Sheet1!A1:C10") Batch write with formulas client.batch_update([ "range": "A2", "value": "=SUM(B2:B10)", "range": "B2", "value": 42, "range": "C2", "value": "Completed" ], atomic=True) Export to Markdown print(client.export("Sheet1!A1:F20", format="markdown")) 6. Error Handling & Retry Policy v2.1 introduces granular error classification: gsheet v2.1

| Feature | Description | |---------|-------------| | | All-or-nothing updates across multiple sheets | | Cell metadata access | Read font color, background, and note fields | | Formula passthrough | Write formulas that auto-calculate | | Export filters | JSON, CSV, or Markdown output from a range | | Connection pooling | Reuse HTTP sessions for lower latency | 3. Architecture GSheet v2.1 sits between the client application and Google’s API. | Error Type | Retry