Use data from Google Sheets with AppSheet in the following ways:
- Create an app using a Google Sheet. See Create apps: The Essentials.
- Use the Google Sheets AppSheet add-on (described below)
Use the Google Sheets AppSheet add-on
The Google Sheets AppSheet add-on automatically converts a Google Sheet to an AppSheet app when you click Go from the AppSheet add-on pane in your Google Sheet. You'll be taken to appsheet.com to a working mobile app you can customize.
Caveats and limitations
onEdit Triggers
Google Sheets allow you to create onEdit
triggers: code functions that run whenever a Google Sheet is edited via Google's web interface. However, onEdit
triggers do not fire when data is edited and synced to the spreadsheet via AppSheet. If you have important functionality that needs to run on updated data, we suggest moving it to a timed trigger (a different kind of trigger that Google supports). You can learn more about these different trigger types via the Google Docs page.
Filters
Do not use filters on your Google Sheets: it can make the filtered rows invisible to updates. Instead, use filter views, a Google Sheets feature that lets each user create and use their own filters without affecting other users of the spreadsheet.