AppSheet

Last updated
AppSheet
Company type Subsidiary
Industry
Founded2014 (2014)
Headquarters Seattle, Washington, U.S.
Products
  • AppSheet platform
Number of employees
Approximately 35 (2019)
Parent Google LLC
Website www.appsheet.com

AppSheet is a no-code development platform for application software, which allows users to create mobile, tablet, and web applications. It allows using data sources like Google Drive, DropBox, Office 365, and other cloud-based spreadsheet and database platforms. AppSheet can be utilized for a broad set of business use cases including project management, customer relationship management, field inspections, and personalized reporting. [1] AppSheet was acquired by Google in January 2020. [2] [3] [4]

Contents

Platform

The AppSheet platform allows users to create mobile apps from cloud-based spreadsheets and databases. [5] Apps can also be created directly as an add-on from spreadsheet platforms like Google Sheets. [6] The platform is available from both a self-service model and a corporate licensing model for larger organizations with more governance, data analytics, and performance options. [7] Compared to low-code development platforms which allow developers to develop with faster iteration cycles, AppSheet is a no-code platform which allows business users familiar with basic spreadsheet and database operations to build apps. [8]

AppSheet compatible data sources include:

Features

AppSheet Platform AppSheet Data Security.png
AppSheet Platform

Data Capture

AppSheet apps capture data in the form of images, signatures, geolocation, barcodes, and NFC. Data is automatically synced to the cloud-based, or users can opt to manually sync the data at any time. Common uses for data capture include field or equipment inspections, safety inspections, reporting, and inventory management. [10]

Data Collaboration

Synced, shared data allows users to collaborate across mobile or desktop devices. Workflow rules can also be used to trigger notifications or work-based assignments where appropriate. Offline access is also possible as data storage is localized to the device and synced upon internet connectivity returns. [11]

Data Display

AppSheet data can be displayed in graphical and interactive formats. Common data views include tables, forms, maps, charts, calendars, and dashboards. Each app can hold multiple views consisting of data from various sources. [12]

Declarative Programming Model

AppSheet's platform allows users to declare the logic of the app's activity in order to customize the app's user experience rather than use traditional code. This level of abstraction essentially trades a granular level of customization that would be available through hard code for increased efficiency, scalability, and security that would be available through a declarative model. [13]

Security

Data is stored on a user's device and the user's existing cloud-based storage system. When users sync their app, changes they make are sent to the AppSheet web service over an encrypted protocol (HTTPS). AppSheet then applies the changes to the backend spreadsheet (on Google Drive, Dropbox, etc.). The latest version of the spreadsheet or database is read (from Google Drive, Dropbox, etc.) and sent back to the mobile app. [14]

AppSheet's platform is also verified as SOC2 compliant. [15]

Google provides a HIPAA implementation guide for AppSheet developers who have signed Business Associate Contracts.

History

AppSheet was originally founded by Praveen Seshadri in March 2014 after several months of developing the product at his home in Seattle, Washington. [16]

In 2015, AppSheet received seed funding from New Enterprise Associates. [17]

In 2018, AppSheet was recognized by TiE as a Tie50 award recipient recognizing innovative tech startups. [18]

In 2018, AppSheet launched SPEC, a natural-language programming tool allowing non-coders to build apps by asking users in plain English what they want to build. [19]

In 2018 and 2019, AppSheet was named a leader by Forrester Research for mobile low-code platforms for business developers. [20] [21]

On January 14, 2020, AppSheet announced they had been acquired by Google and would be joining the Google Cloud team. [22] [23]

Related Research Articles

A collaborative real-time editor is a type of collaborative software or web application which enables real-time collaborative editing, simultaneous editing, or live editing of the same digital document, computer file or cloud-stored data – such as an online spreadsheet, word processing document, database or presentation – at the same time by different users on different computers or mobile devices, with automatic and nearly instantaneous merging of their edits.

<span class="mw-page-title-main">Adam Bosworth</span> American businessman

Adam Bosworth is a former Vice President of Product Management at Google Inc. from 2004 to 2007; prior to that, he was senior VP Engineering and Chief Software Architect at BEA Systems responsible for the engineering efforts for BEA's Framework Division. Bosworth had co-founded Crossgain, a software development firm acquired by BEA in 2001. Crossgain's "Cajun" project developed into BEA's WebLogic Workshop product. At BEA, Bosworth also developed the Alchemy intelligent caching framework in a team consisting of Bosworth and his son, Alex. Alchemy was a software layer used by Internet Explorer to communicate with a corresponding software layer on the web server allowing both upload and download data to be cached when the browser was disconnected from the network. Architecturally, this approach is similar to the design of the Google Web Accelerator although that product only performs server-side caching, rather than client-side caching.

<span class="mw-page-title-main">Papers (software)</span> Reference management software

Papers is a reference management software available for macOS and Windows. It was designed to facilitate the management of bibliographies and references for essays and articles. The software's primary function is to organize references and maintain a digital library of PDF documents.

<span class="mw-page-title-main">MediaFire</span> File hosting service

MediaFire is a file hosting, file synchronization, and cloud storage service based in Shenandoah, Texas, United States. Founded in June 2006 by Derek Labian and Tom Langridge, the company provides client software for Microsoft Windows, macOS, Linux, Android, iOS, BlackBerry 10, and web browsers. MediaFire has 43 million registered users and attracted 1.3 billion unique visitors to its domains in 2012.

<span class="mw-page-title-main">Google App Engine</span> Cloud-based web application hosting service

Google App Engine is a cloud computing platform used as a service for developing and hosting web applications. Applications are sandboxed and run across multiple Google-managed servers. GAE supports automatic scaling for web applications, allocating more resources to the web application as the amount of requests increases. It was released as a preview in April 2008 and launched officially in September 2011.

This is a comparison of online backup services.

Dropbox is a file hosting service operated by the American company Dropbox, Inc., headquartered in San Francisco, California, U.S. that offers cloud storage, file synchronization, personal cloud, and client software. Dropbox was founded in 2007 by MIT students Drew Houston and Arash Ferdowsi as a startup company, with initial funding from seed accelerator Y Combinator.

Google Drive is a file-hosting service and synchronization service developed by Google. Launched on April 24, 2012, Google Drive allows users to store files in the cloud, synchronize files across devices, and share files. In addition to a web interface, Google Drive offers apps with offline capabilities for Windows and macOS computers, and Android and iOS smartphones and tablets. Google Drive encompasses Google Docs, Google Sheets, and Google Slides, which are a part of the Google Docs Editors office suite that allows collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the Google Docs suite are saved in Google Drive.

ownCloud Free software for cloud computing

ownCloud, a Kiteworks Company, is a free and open-source software project for content collaboration and sharing and syncing of files in distributed and federated enterprise scenarios. It allows companies and remote end-users to organize their documents on servers, computers, and mobile devices and work with them collaboratively while keeping a centrally organized and synchronized state.

Backend as a service (BaaS), sometimes also referred to as mobile backend as a service (MBaaS), is a service for providing web app and mobile app developers with a way to easily build a backend to their frontend applications. Features available include user management, push notifications, and integration with social networking services. These services are provided via the use of custom software development kits (SDKs) and application programming interfaces (APIs). BaaS is a relatively recent development in cloud computing, with most BaaS startups dating from 2011 or later. Some of the most popular service providers are AWS Amplify and Firebase.

Google Cloud Platform (GCP) is a suite of cloud computing services offered by Google that provides a series of modular cloud services including computing, data storage, data analytics, and machine learning, alongside a set of management tools. It runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, and Google Docs, according to Verma et al. Registration requires a credit card or bank account details.

<span class="mw-page-title-main">Google Sheets</span> Cloud-based spreadsheet software

Google Sheets is a spreadsheet application and part of the free, web-based Google Docs Editors suite offered by Google. Google Sheets is available as a web application; a mobile app for: Android, iOS, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by which user made them, along with a revision history. Where an editor is making changes is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features that use machine learning, including "Explore", which offers answers based on natural language questions in the spreadsheet. Sheets is one of the services provided by Google that also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep.

Firebase was a company that developed backend software. It was founded in San Francisco in 2011 and was incorporated in Delaware.

<span class="mw-page-title-main">Pyrus (software)</span>

Pyrus is a cloud-based workflow automation and document management system developed by Simply Good Software, Inc. Pyrus comes as SaaS and offers a web-based interface to launch workflows, assign tasks, and manage documents. It is a unified corporate communication environment, accessible from any device. Mobile versions are available for all platforms, including iOS, Android, and Android Wear. Users are able to set up and route workflows without coding and IT assistance.

Firebase Cloud Messaging (FCM), formerly known as Google Cloud Messaging (GCM), is a cross-platform cloud service for messages and notifications for Android, iOS, and web applications, which as of May 2023 can be used at no cost. Firebase Cloud Messaging allows third-party application developers to send notifications or messages from servers hosted by FCM to users of the platform or end users.

Enterprise file synchronization and sharing refers to software services that enable organizations to securely synchronize and share documents, photos, videos and files from multiple devices with employees, and external customers and partners. Organizations often adopt these technologies to prevent employees from using consumer-based file sharing apps to store, access and manage corporate data that is outside of the IT department's control and visibility.

Google Cloud Datastore is a highly scalable, fully managed NoSQL database service offered by Google on the Google Cloud Platform. Cloud Datastore is built upon Google's Bigtable and Megastore technology. Google Cloud Datastore allows the user to create databases either in Native or Datastore Mode. Native Mode is designed for mobile and web apps, while Datastore Mode is designed for new server projects.

<span class="mw-page-title-main">Low-code development platform</span> Software development system

A low-code development platform (LCDP) provides a development environment used to create application software, generally through a graphical user interface. A low-coded platform may produce entirely operational applications, or require additional coding for specific situations. Low-code development platforms are typically on a high abstraction level, and can reduce the amount of traditional time spent, enabling accelerated delivery of business applications. A common benefit is that a wider range of people can contribute to the application's development, not only those with coding skills, but good governance is needed to be able to adhere to common rules and regulations. LCDPs can also lower the initial cost of setup, training, deployment, and maintenance.

<span class="mw-page-title-main">Collabora Online</span> Online office suite based on LibreOffice

Collabora Online is an open source online office suite based on LibreOffice, enabling web-based collaborative real-time editing of word processing documents, spreadsheets, presentations, and vector graphics. Optional apps are available for desktops, laptops, tablets, smartphones, and Chromebooks.

References

  1. "Startup Spotlight: AppSheet lets non-developers build custom mobile apps". geekwire.com. Retrieved 2018-06-22.
  2. Ron Miller, "Google acquires AppSheet to bring no-code development to Google Cloud", TechCrunch, January 14, 2020
  3. Bridgwater, Adrian. "Google Says Yes To No-Code, Acquires AppSheet". Forbes. Retrieved 2020-06-23.
  4. "Google acquires no-code app development platform AppSheet". VentureBeat. 2020-01-14. Retrieved 2020-06-23.
  5. "An Ode to the Underappreciated Spreadsheet". hbr.com. Retrieved 2018-06-22.
  6. "4 Essential Android Add-Ons for Google Docs and Sheets". pcworld.com. Retrieved 2018-06-22.
  7. "Pricing". appsheet.com. Retrieved 2019-02-20.
  8. "What No-Code Software Really Looks Like". forbes.com. Retrieved 2019-03-21.
  9. "How to make an app". appsheet.com. Retrieved 2019-02-20.
  10. "How to make an app". appsheet.com. Retrieved 2019-02-20.
  11. "Teams and Collaboration". appsheet.com. Retrieved 2019-02-20.
  12. "Views". appsheet.com. Retrieved 2019-02-20.
  13. "What No-Code Software Really Looks Like". forbes.com. Retrieved 2019-03-21.
  14. "Understanding the Secure Flow of Data". appsheet.com. Retrieved 2019-02-20.
  15. "AppSheet Information Security" (PDF). appsheet.com. Retrieved 2019-02-20.
  16. "AppSheet". geekwire.com. Retrieved 2018-06-22.
  17. "Startup Spotlight: AppSheet lets non-developers build custom mobile apps". nea.com. Retrieved 2018-06-22.
  18. "TiE Inflect 2018 announces AppSheet as a 2018 TiE50 Winner". Business Insider. Retrieved 2018-06-21.
  19. "AppSheet's new 'Spec' feature aims to make apps easier to build using natural language, without code". Geek Wire. Retrieved 2018-06-21.
  20. "The Forrester Wave™: Mobile Low-Code Platforms For Business Developers, Q3 2018". Forrester. Archived from the original on 2018-08-15. Retrieved 2019-02-19.
  21. "The Forrester Wave™: Mobile Low-Code Platforms For Business Developers, Q2 2019". Forrester. Retrieved 2019-07-17.
  22. Miller, Ron (2020-01-15). "Google acquires AppSheet to bring no-code development to Google Cloud". TechCrunch. Archived from the original on 2020-01-16. Retrieved 2020-01-16.
  23. Seshadri, Praveen (2020-01-16). "AppSheet Acquired by Google Cloud". AppSheet. Archived from the original on 2020-01-16. Retrieved 2020-01-16.