trouble getting files from google drive

[aztk]

Hi,

I try to copy a file or file content from Google drive.

I tried different approaches - get file, get file content, list files, get file content by id etc.

There is always an error: The specified file is a Google Spreadsheet, which cannot be downloaded.

The connection to drive works, folders browseable from the google drive connector, files visible.

It doesn't matter if files are shared or not, published o not.

Always the same error.

I would appreciate your help!

[JohnAageAnderse]

Hello @aztk 

Are you talking about one specific file that always gives an error and for every other file it just works?

I just tried to get the file content from my Google Drive and it works for me.

Can you provide more details about the error - code, message, etc.?

Kind regards, John

[v-litu-msft · Accepted solution]

Hi @aztk,

To get file content of google sheet, there is a special connector named Google sheet, you could use the Get rows action to get the Google Spreadsheet file content:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aztk]

Hi,

I've tried Get sheets with one file (duly shared and published) and I always get:

status: 409, The specified file is a Google Spreadsheet, which cannot be downloaded.

I tried Get sheets, not Get rows which is probably the problem.

("Get rows" is not named intuitively indeed... and it is my fault I haven't read the documentation.)

Just tried Get rows and I get no errors. The OneDrive connector failed to create a file, but that's probably another story.

Anyway, I used a script in the document on GDrive to solve my case.

Thank you!

[kapilchittora]

The specified file is a Google Spreadsheet, which cannot be downloaded.
clientRequestId: 7b7f31e0-c34d-41ef-b767-b0baf3291fe5

Getting this error - everytime I use the option to get content using path

get row option does not give option to specify file content when making routine for automated email from gheet to gamil 

[anuradhac01]

Can someone share how to use Get rows after List files in the folder if google sheets have different work sheets names?

Say for example in a "Data" folder on google drive i have  "Google Sheet 1" with Worksheet name "S1" and "Google Sheet 2" has worksheet name "S2". 

I want to copy these two google sheets to my sharepoint as excel