Error 400

[Carmen_Tur]

Hi, I’m doing the activity “First Automation using Google workspace” and I’ve been handle this error.

Can anybody help me? Thanks!

[Palaniyappan (Forum Leader)]

Hi

Pls Check with this doc on how to automate with google sheet using studioX

Google Workspace Automation

And make sure file is in google spreadsheet format

@Carmen_Tur

Cheers

[Yoichi]

Hi,

The following might help you.

Read Range: "This operation is not supported for this document"

I have an Google spread sheet stored in Google Drive. I have already downloaded GSuite package, enabled API, and got credential (Service Account Key). Inside GSuite Application Scope, I am using Read Range activity, but it returns the following error: Read Range: Google.Apis.Requests.RequestError This operation is not supported for this document [400] Errors [Message [This operation is not supported for this document] Location[ - ] Reason[failedPrecondition] Domain[global] How can I fix thi…

In this case, we need to convert xlsx to GooglSpreadsheet format in advance.

Regards,

[Carmen_Tur]

Even though I’ve checked the file extension and it was .xlsx, I’ve changed it to GSheet … still not working.

1. On the one hand, I should find a way to download the files that If it is in .xlsx format, it should be saved in Gsheet format automatically, not manually.

2. On the other hand, even if I change the files to GSheet (manually, of course) I still get the same 400 error.

Do you know another alternative?

Thank you so much!

[Yoichi]

Hi,

To isolate cause, can you try to create newly spreadsheet using UseGoogleSpreadsheet and Write Range for test?

Regards,

[Carmen_Tur]

I have only achieved this by using the googlespreedsheet task and telling it to create a file “if it didn’t exist”