Information
  • Author: Appian Corporation
  • Type: Plug-in (Connected System)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 21.4
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Google Sheets Connected System

Google Sheets Connected System

Overview

Integrate your Google Sheets Spreadsheets with Appian so you can work with your data anywhere!

With the Google Sheets Connected System, you can create a service-backed record based on any Google Spreadsheet - when your data is updated in the spreadsheet, it is automatically updated in your Appian record as part of your applications’ data fabric.

Embed your Google Sheet in Appian to open, view, and edit this information from within your application for a truly seamless experience.

Key Features & Functionality

  • Data Source Integration - Create a record based off of the sheet to connect Sheets to your organization’s data fabric
  • Sync Integration - After updates are captured in a webhook, use this integration to sync new changes made to your sheet to your Appian Record
  • Get Sheet Details - Get relevant metadata about the sheet
  • Add Rows - Add new rows to the sheet
  • Get Rows - List all rows in the sheet
  • Update Row - Update rows or individual cells
  • Clear Rows - Delete rows
  • Create Spreadsheet - Create a new spreadsheet
Anonymous
Parents

  • Hii

    When i am testing google sheet plug from connected system, i am getting permission denied issue.

  • in reply to parveenk0002

    Hi ,

    Seems that the account you use to read the spreadsheet does not have permission to read the sheet.

    Based on the authentication you are using,

    • If you use Service Account authentication, kindly check that the spreadsheet your are trying to read is shared with that service account.
    • If you are using OAuth 2.0 Authorization Code authentication, kindly confirm that your Google console Project has /auth/drive, ./auth/drive.file, and /auth/drive.readonly scopes enabled. Refer the Connected System documentation provided in the downloaded package for detailed steps.
Comment
  • in reply to parveenk0002

    Hi ,

    Seems that the account you use to read the spreadsheet does not have permission to read the sheet.

    Based on the authentication you are using,

    • If you use Service Account authentication, kindly check that the spreadsheet your are trying to read is shared with that service account.
    • If you are using OAuth 2.0 Authorization Code authentication, kindly confirm that your Google console Project has /auth/drive, ./auth/drive.file, and /auth/drive.readonly scopes enabled. Refer the Connected System documentation provided in the downloaded package for detailed steps.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.