403 or 404 ErrorsUsers of Google Drive can sometimes see Error 403 (permission denied) or Error 404 (not found). There are a few common reasons for this: Show
Click here to learn more about enabling Google permissions. Google AppScript "onEdit" TriggersIf 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 FiltersAlso, 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 SheetsMake 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 LengthMake 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 CharacterWhen AppSheet attempts to read your Google worksheet you may see an error like the following: 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:
Here are some things to check:
|