Overview
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!
Key Features & Functionality
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.
I created a service account and entered the information from the credentials JSON file when creating the connected system but ran into a 401 error (unauthorized access) when executing the integration. I used the email address that I created the service account with as the "Client Email", the client_id value in the JSON file as the "Private Key ID", and the client_secret value in the JSON file as the "Private Key". Any ideas what I could be doing wrong?
Hi Andrew Frederick
Try private_key_id value in the JSON file as the "Private Key ID" and private_key value in the JSON file as "Private Key".
Please follow this link to create the service account and download the JSON file with the Public and Private key.