📝 Overview
This guide explains how to troubleshoot errors when using 'Operating a Database' in a Google Spreadsheet.
If you checked all the points below, but still cannot perform operations, please contact us via chat.
☑️ Troubleshooting Checklist
① Is the file in Excel format?
If the spreadsheet is in Excel format (.xlsx, .xls), the operation will not work.
❗ Please convert it to Google Sheets format before using it.
② Is the Spreadsheet ID entered correctly?
The spreadsheet ID is the ●●●● prt of the URL below:
spreadsheets/d/●●●●/edit#gid=
⚠️ Check for the following mistakes:
Incorrect or missing Spreadsheet ID
Accidental spaces or extra characters
③ Are the sheet name and table range correctly entered?
✔️ Ensure there are no extra spaces in the sheet name or table range.
✔️ Check for uppercase and lowercase differences.
④ Does the registered account have editing permission?
Make sure the email address used in My Apps registration has edit access to the target spreadsheet.
📌 How to check:
Open the spreadsheet
Click Share
Verify that the correct email is listed with Editor access
⑤ Are table headers properly set?
The first row in the specified range should contain column headers (field names).
⚠️ Common mistakes that cause errors:
Empty header cells
Merged cells (Unmerge them)
Line breaks (Alt + Enter) inside header cells (Remove them)
⑥ Are column names empty?
If "Add a Record" fails and returns an error like this:
{"readyState":4,"responseText":"","status":400,"statusText":"error"} ➡ At least one column name is empty.
💡 Solution: Check and enter a value in any empty column header cell.
Related Keywords
Related Keywords
Database, Operating database, Operation, Spreadsheet, Google Sheets, GSS, Error, Troubleshooting, Table Header, Editing