Using Data from Google Sheets

The easiest way to build AppSheet apps from Google Sheets is to use the AppSheet add-ons found in the Google add-on gallery.

Written by Santiago Uribe Montoya Updated over a week ago

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