Google Sheets Connected System (Vuram)

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs office suite offered by Google within its Google Drive service. The app is compatible with Microsoft Excel file formats and is available as a web application, mobile app for Android, iOS, Windows, BlackBerry, and as a desktop application on Google's ChromeOS.

You can easily build different integrations using the Google Sheets connected system and access various functionalities directly in Appian by using the desired google sheet ID as input. The download package contains documentation for how to set up the connected system.

Functionality

  1. Add Rows - Add row data to the spreadsheet
  2. Get Sheet Details - Return the spreadsheet metadata by the given ID
  3. Get Rows - Get row data from the spreadsheet
  4. Update Rows - Update row data to the spreadsheet
  5. Clear Rows - Clear row data from the spreadsheet
Anonymous