Automating Google spread sheets

Help
1

Hi All,
I am trying to write the data in google spread sheets using Gsuite Application Scope, but getting an error. Please check the below image.

image
image1366×768 82.6 KB

Thanks in advance!

2

@suma123 What is your authentication type ?

3

Hello @shibani, Thanks for your quick reply
It is ServiceAccountKey

4

@suma123 Have you created a project on https://console.developers.google.com/ and enabled the API ?

5

@shibani Yes, I have already created project on that link and enabled API

6

@suma123 Provide the path for the JSON file you’ve just downloaded in the KeyPath field.The last step is to give the service e-mail access to the files you want to work with. This can be done through the share button. and set services to Sheet, since the api for Sheets and drive will be different

7

Thanks for the hint @shibani
But it got 404 error. Please kindly check the below image.

image
image1366×768 77.9 KB