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
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.
Hi Santhosh, thanks for the reply. My JSON file doesn't have a private_key_id or private_key values. The only values that are present are client_id, project_id, auth_uri, token_uri, auth_provider_url, client_secret, and redirect_uris