AppSheet

Last updated
AppSheet
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 an application that provides a no-code development platform for application software, which allows users to create mobile, tablet, and web applications using data sources like Google Drive, DropBox, Office 365, and other cloud-based spreadsheet and database platforms. The platform can be utilized for a broad set of business use cases including project management, customer relationship management, field inspections, and personalized reporting. [1]

Contents

AppSheet was acquired by Google in January 2020. [2] [3] [4]

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]

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>

Adam Bosworth is a former Vice President of Product Management at Google Inc. from 2004–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.

Wrike, Inc. is an American project management application service provider based in San Jose, California. Wrike also has offices in Dallas, Tallinn, Nicosia, Dublin, Tokyo, Melbourne and Prague.

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

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.

This is a comparison of file hosting services which are currently active. File hosting services are a particular kind of online file storage; however, various products that are designed for online file storage may not have features or characteristics that others designed for sharing files have.

<span class="mw-page-title-main">Microsoft Azure</span> Cloud computing platform by Microsoft

Microsoft Azure, often referred to as Azure, is a cloud computing platform run by Microsoft, which offers access, management, and development of applications and services through global data centers. It provides a range of capabilities, including software as a service (SaaS), platform as a service (PaaS), and infrastructure as a service (IaaS). Microsoft Azure supports many programming languages, tools, and frameworks, including Microsoft-specific and third-party software and systems.

Sauce Labs is an American cloud-hosted, web and mobile application automated testing platform company based in San Francisco, California.

Google Drive is a file storage 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 permits 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 is an open-source software product for 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. ownCloud supports extensions like online document editing, calendar and contact synchronization. Users can work with documents from a browser, and there are clients for a variety of operating systems as well as mobile clients for Android and iPhone.

Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, Google Drive, and YouTube. Alongside a set of management tools, it provides a series of modular cloud services including computing, data storage, data analytics and machine learning. 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 included as 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, Microsoft Windows, BlackBerry OS; 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 is a set of backend cloud computing services and application development platforms provided by Google. It hosts databases, services, authentication, and integration for a variety of applications, including Android, iOS, JavaScript, Node.js, Java, Unity, PHP, and C++.

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

Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a database, webpage, or structured files such as spreadsheets, CSV, XML, and JSON.

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.

A low-code development platform (LCDP) provides a development environment used to create application software 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 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 require good governance 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 by Collabora Productivity based on LibreOffice

Collabora Online is an open source online office suite built on LibreOffice Technology, 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.

Microsoft Power Platform is a line of business intelligence, app development, and app connectivity software applications. Microsoft developed the Power Fx low-code programming language for expressing logic across the Power Platform. It also provides integrations with GitHub and Teams.

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.