If you want only to allow the account read access to the spreadsheet, assign it the Viewer role instead. Click on the Share button in the top right, and add the email address of the service account as an editor.Open the service_account.json file and find the client_email property.Create or select an existing Google Sheet.Find the downloaded file and rename it to service_account.json.Ĭreate a new Google Sheet and add the Service Account as an editor to it.The credentials file allows anyone to access your cloud resources, so you should store it securely.

The credentials JSON file will be downloaded by your browser.

On the next screen, choose a name for your service account, assign it a role of Project-> Editor, and click Continue.Then click on the What credentials do I need? button. Select Other UI from the dropdown and select Application Data. Create new credentials to the Google Sheets API.Create a new project and give it a name.Access the Google APIs Console while logged into your Google account.To access the data stored in Google Sheets, you will need to create a service account and get a set of OAuth2 credentials from the Google API Console. The account used by the robot will then need to be added as a collaborator to the sheet(s) you want to access. Your robots will need to authenticate with Google to be able to interact with Google Sheets spreadsheets, using the concept of service accounts. The library, part of RPA Framework, enables interaction with Google Sheets. For many processes, all you need is a shared spreadsheet and a robot using it! Which automation library should you use? Google Sheets, part of Google Workspace, allows teams to create and share spreadsheets online and has grown into a widely used business tool. How to read from and write into Google Sheets from your robots

Automation studio 6.0 googledrive