Update query for Google Sheets fails with "Query Error: Cannot read properties of undefined (reading 'schema')"

[kovarn]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Cloud
  • Tenant ID: fmbberlin.budibase.app

Describe the bug
Update query for Google Sheets fails with "Query Error: Cannot read properties of undefined (reading 'schema')".

To Reproduce
Steps to reproduce the behavior:

1. Go to a Google Sheets datasource
2. Create an update query
3. Specify a Sheet, RowIndex, and add a nonempty body for the row to update
4. Click on 'Run query'
5. Query fails with the error Query Error: Cannot read properties of undefined (reading 'schema')

Expected behavior
The row should be updated with the new values.

Desktop (please complete the following information):

• OS: Ubuntu
• Browser: Chrome
• Version: 124.0.6367.207

Additional context
Adding a new table to Google Sheets adds an extra first column with the table name in the column header.

[linear]

BUDI-8256 Update query for Google Sheets fails with "Query Error: Cannot read properties of undefined (reading 'schema')"