If you've ever viewed and edited a spreadsheet online, chances are good you've used Sheets, Google's online spreadsheet editor with real-time collaboration. Google Sheets is great for many use cases, but what if you want to connect your spreadsheets with Appian? Building out an integration from scratch could easily take weeks of development time to get a solution up and running.
Fortunately, there's a better option. With the Google Sheets Connected System plug-in for Appian, you can start interacting with Sheets from within your Appian applications in minutes. The plug-in is easy to install and includes a number of operations that cover a variety of use cases. Pull in revenue data from your financial spreadsheets? Check! Write a list of users' names an emails to an employee directory sheet? Check! Export your sales projections to a new spreadsheet that management can use to make decisions? Check! Whether you need to read data, write data, create new sheets, or do all three, this plugin allows you do so with ease.
In addition to the plugin, which can be easily deployed to any cloud or self-managed environment, this component also comes with a companion Appian application. The companion application has a connected system and integration objects already created, which can be configured with just a few fields. There are also a number of functions available that make it easier to do common operations (like converting column numbers to a spreadsheet header), as well as several examples that show how the plugin functionality can be used in a real-world application. As a result, you not only get the functionality of the plugin, but also get a head-start on the Appian development as well!
This plug-in allows you to create a new type of connected system, Google Sheets. The connected system uses Appian's out-of-the-box OAuth 2.0 handling for authentication and is easy to set up.
There are three integration operations available for this connected system:
The companion app also includes a number of useful functions and examples:
Put together, the plug-in and companion app can shave weeks off the development time for your Google Sheets project.
© 2020 Appian. All rights reserved.