<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Filter By Categories
Santiago Uribe
April 02, 2015

How to Build Mobile Apps in Minutes with AppSheet (Part 1)

AppSheet helps you create and deploy custom mobile apps in minutes. It greatly reduces the cost and time to build mobile apps through a combination of powerful ingredients. So, how do you get started?

Start with spreadsheet data stored in your favorite cloud provider. Connect your cloud storage with AppSheet to customize the mobile app. Finally, deploy the app to mobile devices directly from appsheet.com.

The app maker for everyone

There are four ingredients in place to help you build a mobile app with AppSheet:

1. Spreadsheet

2. Cloud Storage

3. App Editor

4. Mobile Device

That's it, four ingredients for quick and powerful business apps. Keep reading to get some tips for each ingredient.

Four Ingredients for Mobile Apps - Infographic


Cloud Storage

  • AppSheet connects to the most popular cloud services (Google Drive, OneDrive, Dropbox, Box, Smartsheet).
  • When you edit your spreadsheet, make sure you are editing the file in cloud storage and not a copy that you downloaded so the data in the app and spreadsheet are always in sync.
  • If you use Excel files, you can store them in OneDrive, Dropbox, Box, and Google Drive and you'll get the same results.
  • Google Sheets files work best with Google Drive.


  • AppSheet will read the first table available in your spreadsheet. Make sure that the table has a clear column structure and that each row represents a distinct data entry.
  • You can connect several tables from multiple spreadsheets through the App Editor. You simply need to make sure that the data in each keeps a clear column structure.
  • You can add rich media to your spreadsheet to enhance your app. Click here to learn more about adding images to the spreadsheet that automatically load in the app.
  • AppSheet can use Excel, Google Sheets, and Smartsheet spreadsheets. We're pretty sure you're covered. :)
  • It also works with Google Forms! Create your Google Form, then use the AppSheet add-on to turn the form into a mobile app and start collecting data.
  • You can help the AppSheet algorithms to understand your spreadsheet if you have at least five rows of data entered in the table. You can refine the type of data for each column in the App Editor.

App Editor

  • This is where AppSheet automatically builds mobile apps from your data, and where you can customize your app.
  • There are two editors: the Basic and Advanced. The Basic Editor allows for simple changes to the app. For adventurous users, the Advanced Editor will let you tweak the app at a granular level, change the behavior for each field, add multiple tables and views, and much more.
  • Use the Data, UX, and Settings tabs to tweak the app. You can add more views, limit the number of users that can see your app, allow users to upload data through the app, choose what data gets shown in the app, and more.

Mobile Device

  • The AppSheet app for iOS and Android will host your business app. Deploying is easy; once the app is ready, send an install link to the app users. After a few simple steps, they will have your app installed on their phones.
  • You can make your app private and share it only with a limited group of people by requiring sign-in. You can configure this option through the App Editor.
  • Users won't have access to your spreadsheet. They will only see what's available to them through the app, unless you directly share the spreadsheet with them via your cloud provider's share settings.
  • Our apps also work on the Web. You can design powerful workflows for your business that connect mobile devices and desktop computers to your business data using AppSheet apps.

How are you building mobile apps with AppSheet? Let us know in the AppSheet User Community!


Learn More About AppSheet


Google Search

Subscribe Email