Reproduction steps:
1. Set up OAuth Authentication based on this: https://docs.unity3d.com/Packages/com.unity.localization@1.4/manual/Google-Sheets-Configuring-Authentication.html
2. Open the attached “IN-118881.zip” project
3. From the Project Window, select the “Google Sheets Service.asset”
4. Input your “Client Id” and “Client Secret” that were set up during 1st step and Authorize
5. From the Project Window, select the “UI_Text.asset”
6. Click “Create New Spreadsheet”
7. Click Push to set up the Google Sheet and click Open to view it in browser
8. Delete all empty rows (from 5-999)
9. Delete any row that has entry (e.g. 4th row)
10. Click Push again in “UI_Text.asset”
11. Observe the Console

Expected result: Push operation is completed without exceptions, the missing row is detected and resized to accommodate all required rows (entries + header) before pushing data
Actual result: “Push UI_Text to Google Sheets: Failed" exception is thrown

Reproducible with: 1.5.5, 1.5.8 (6000.0.59f1, 6000.2.7f1, 6000.3.0b4, 6000.4.0a1)

Reproducible on: Windows 11
Not reproducible on: no other environments tested