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.
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
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".
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?
© 2022 Appian. All rights reserved.