GW Apps vs AppSheet

We’re often asked about the differences between GW Apps and AppSheet, and which product will offer the best solution.

Both products have unique underlying architectures that make them more suitable for building different types of applications. In this paper we'll look at the relative strengths of both products, as well as the types of applications each is a better fit for.

Architecture - Form Builder vs Data Modeling

GW Apps

GW Apps drag-and-drop form builder offers a visual way for users to build their apps. With multiple layout options and lots of customizability, it enables users to easily build and organize highly functional forms to fit their needs. Forms can have up to 4 columns of fields, and will automatically reformat to fit different screen sizes. GW Apps can also create forms automatically by uploading existing data from a spreadsheet. This initial form can then be easily reformatted and extended to complete the design.

Form Features
Form Builder User Interface

AppSheet

AppSheet takes a data modeling approach, allowing you to easily create a front-end app to work with an existing data source. The form is automatically generated from the data source as a single column of fields in the same order as the underlying table. There are very few options to control how the form is laid out, and no easy way to add non-field elements to your form such as images, dividing lines, labels or sections. AppSheet does offer strong mobility features, making it more suited for users in the field rather than office employees. It is a strong candidate for simple apps that involve onsite data entry like inventory mgmt or inspection.

Workflow and Automated Actions

GW Apps

The GW Apps Workflow Builder allows you to easily model complex business processes (workflows), with features like multiple levels of approval, routing, automatic and scheduled triggers, conditional actions, granular security, and more. User permissions are controlled by custom roles, and each application has its own set of roles. Permissions can be configured all the way down to individual fields at a specific step in the process (i.e., workflow stages), as seen in the image below. GW Apps also allows you to create Shared Global Roles - roles that can be pre-populated with users and imported into any application.

Granular Security
Example of the granularity and flexibility in assigning user roles and access in GW Apps

AppSheet

AppSheet handles workflow and user permission differently. Workflow is created and designed through the use of bots and automation, which combined can create the usual actions of a workflow. There are only two possible roles in AppSheet (Admin and User), and permissions for each apply to a whole type of data (e.g., all sales records or all inspection report records). While it is possible to define access at a row/stage level, to do so you need to program it using AppSheet expressions to define each field’s access, and these would get very, very complex to match what’s possible via the simple GW Apps form security interface.

Ease of Use

GW Apps

GW Apps is designed to be both easy to use and simple to learn, while simultaneously providing features that enable users to build enterprise grade applications. This is achieved through the use of drag, drop, and configure style builders. Even the most complex features in GW Apps have no code, no expression language to learn, nothing but wizard style, pick from list configurations.

Unlike AppSheet, there is no separate data-modeller in GW Apps. As you build a form the data model is automatically created for you, resulting in fewer steps to creating an application and only one interface for creating forms.

GW Apps Conditional Logic
Conditional logic in GW Apps - No coding required

AppSheet

If you already have a Google or Excel sheet data source, and just need a simple form for data entry and review, then nothing could be much simpler than AppSheet. Point AppSheet at your data and it will create a form and a view automatically, in a matter of seconds.

However, if you need to create a more complex app from scratch, or you need record or workflow stage security, conditional logic in how fields display or workflow actions, or any number of more advanced requirements, things get complicated very quickly. You typically need to learn how to program AppSheet expressions to get these accomplished. Similarly, workflow has to be tracked using custom columns added to the data source, as there is no traditional workflow builder.

AppSheet Conditional Logicn
Conditional logic in AppSheet

Feature Comparison Summary

FeatureGW AppsAppSheet
Start from a Template, Spreadsheet, or Scratch

🟢

🟢

Form Customization

🟢

🟡

Workflow Customization

🟢

🟡

Role Based Security

🟢

🟡

Custom Roles

🟢

🔴

Workflow Stage and Field Level Security

🟢

🟡

Custom Views

🟢

🟢

Email Template Builder

🟢

🟡

PDF Template Builder

🟢

🟡

Mobile App/Functionality

🟡

🟢

Community Support

🟡

🟢

SMS/Push Notifications

🔴

🟢

🟢 Available     🟡 Available but Lacking     🔴 Not Available

Pricing

GW Apps

GW Apps offers 4 plans for businesses: A starter plan for 5 users ($50/mo), the SMB value plan for teams of up to 100 users ($300/mo), and two additional plans targeted at Mid Market and Large enterprises, with an average price of $2/user/mo. The free trial plan has no feature limitations, enabling new users to try the platform and build a test application and fully validate its effectiveness. Unlike AppSheet, all GW Apps plans give users access to all of the features of the platform.

AppSheet

AppSheet pricing is based on the number of end-users for your applications. Plans start at $5/user/mo for the basic starter edition, while most business apps will require at least the Core plan at $10/user/mo. To access the platform's most advanced features (team collaboration, advanced data access, governance, etc.) require that you upgrade to the enterprise level. AppSheet offers a free plan to get you started, but it has limitations that don’t allow you to properly build and test an application before you commit to the platform.

Customer Support

GW Apps

Access to live human support is an important resource to help you understand and build apps on the platform. Many GW Apps users have built complex applications with minimal support, while others have needed a helping hand from the beginning. We provide live support to all our users. GW Apps continues to invest in online support content, and we welcome your call anytime you need to get answers or help with your next step.

AppSheet

AppSheet is now a Google product, giving you access to a large set of resources. But larger does not always mean better. Many large organizations make it difficult to reach a live person, and want the customer to leverage all online resources or community support before allowing you to get live support and help with your application.

Other Considerations

Data and Platform Security

Both GW Apps and AppSheet are built on the Google Cloud Platform and leverage the strong data security features that it provides: uptime, data access, stability and compliance.

Reports, View and Dashboards

Both products offer a variety of views and reports to help you and your team view and analyze data, and initiate actions. AppSheet has more view styles available, while GW Apps has a KanBan view, more detailed view display options, and a more feature-rich PDF builder.

Integration with 3rd party apps

Both platforms give you capabilities to integrate with 3rd party apps via webhooks and APIs. AppSheet has more specific out of the box integrations and capabilities (ORC and machine learning, for example).

In Conclusion

These differences in approach can often be the deciding factor in determining which product is more suitable for the application you want to build.

GW Apps real strength lies in its ability to create audit-ready applications for secure business transactions where it is vital only specific people can see or edit specific data, at specific stages in the process life-cycle. It also offers far greater control over how data is laid out in forms.

AppSheet is a very quick way to build web apps if you already have a populated Google or Excel sheet, or a SQL database to serve as the data source. It also has powerful features for mobile applications like geolocation and barcode scanning.

To learn more about how No-Code can help modernize and optimize your organization send us an email to support@gwapps.com and we'll help you get started.

Don't take our word for it! Let us show you.

Our team is always excited to show you our product. Request a demo or get started with a trial account.