Use data from Google Sheets

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 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.


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.

Was this helpful?
How can we improve it?

Need more help?

Try these next steps:

Clear search
Close search
Google apps
Main menu
Search Help Center