403 or 404 Errors
Users of Google Drive can sometimes see Error 403 (permission denied) or Error 404 (not found). There are a few common reasons for this:
- You may have inadvertently deleted the Google worksheet. You can recover the deleted Google worksheet as described here.
- You are not the owner of the document but this is a shared document owned by a different Google account. Check your document sharing permissions on Google.
- You have multiple Google accounts (let's call them Acct1 and Acct2): your spreadsheet is owned by Acct1 but you sign into AppSheet using Acct2 to access the spreadsheet. Either use the same account or share the document across accounts.
- You had access to the file at one point, but the access has been removed.
- This can sometimes occur if you have a corporate Google Docs account that has an admin policy that prohibits all users from enabling third party software like AppSheet (so you may need to talk to your account admin).
Google AppScript "onEdit" Triggers
If you use one of the AppSheet add-ons to integrate with Google Forms, Sheets, or Docs, please also read this article to learn more about specific limitations on those integrations.
In particular, if you utilize Google AppScript onEdit triggers on your Google Sheet, or a third-party add on that utilizes these triggers, the triggers are not fired when AppSheet makes a change to the data in the spreadsheet. This is an unfortunate limitation imposed by Google on all third-party solutions like AppSheet. The best workaround is to utilize a timed AppScript trigger (or an onChange trigger) rather than an onEdit trigger.
Google Sheet Filters
Also, do not use filters on your Google Sheets -- it can make the filtered rows invisible to updates. Instead, use filter views (this is a Google Sheets feature that lets each user create and use their own filters without affecting other users of the sheet).
"Public" Google Sheets
Make certain that your spreadsheet is not marked as "Public". The Google spreadsheets API doesn't enable updates against public spreadsheets.
Google Worksheet Names Exceeding 31 Characters in Length
Make certain that your Google worksheet names do not exceed 31 characters in length. All characters in the name are counted including blanks and special characters.
Unable to Read Spreadsheet. Hexadecimal Value 0xNN, is an Invalid Character
When AppSheet attempts to read your Google worksheet you may see an error like the following:
"Unable to read the spreadsheet for '<worksheet name>' due to spreadsheet reader error: '', hexadecimal value 0x0C, is an invalid character. Line 9999, position 999.
The "hexadecimal value" will vary and as will the "Line" and "position". The line and position are not helpful for the reason described below.
AppSheet reads the Google Sheet by asking Google to "export" the worksheet as a Excel .xlsx document. Google converts the Google worksheet into an Excel .xlsx document file and returns this .xlsx file to AppSheet. AppSheet reads the .xlsx file and extracts all of the worksheet cell values, formulas, formatting, and other information from the Excel .xlsx document.
An "Invalid Character" error occurs when Google fails to export the Google worksheet as a valid Excel .xlsx document. Instead, the exported Excel .xlsx document contains invalid data that Excel cannot read. The "Line" and "position" values in the error message are not very helpful, because they refer to a location in the exported Excel .xlsx document. There is no easy way to use these values to locate the problem in your worksheet.
You may be able to locate the problem by doing the following:
- Open your workbook in Google Sheets.
- From the Google Sheets File menu select Download as... and then select Microsoft Excel (.xlsx). By doing this you are exporting the Google workbook to Excel in the same way that Google Sheets is exporting it to AppSheet.
- When the export finishes, you will see the exported .xlsx file name at the bottom left of your browser screen.
- Click the ^ character to the right of the .xlsx file name and select Open. This will open the exported file in Excel. Excel is very likely to report an error when reading the exported file. The Excel error message may help you locate the problem.
- Return to Google Sheets and modify your workbook to eliminate the problem.
- Repeat the steps above until the you have eliminated the problem.
Here are some things to check:
- Ensure there are no invalid character values in your worksheet cell values. Invalid character values may be displayed in the form "�". You can use the Google Sheets search function to locate the invalid character. Open your worksheet in Google Sheet. From the Edit menu select Find and replace ... Copy � into the Find box to search for the invalid character.
- One customer reported their problem was caused by an "import range" function in a cell of their Google worksheet. Replacing the "import range" with the actual data values eliminated the problem.
- If you discover other causes for this problem, please report them to us. We will add your information to this list to help other users.