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 Comment Children
  • 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.