Get Sheet action in Google Sheet gives 404 error

(0) Share

Report

Posted on by Swapnil

Hi All,

I have created a flow which goes like this:

1) get attachment from mail. (attachment is a excel file)

2) create file in google drive with data from attachment.

3) read the created file using googlesheet connector.

the first 2 steps work perfectly.

In 3rd step, I tried to read the file using id, name, displayname but nothing works. It gives me error 404, but when I check in google drive the file is present.

What could be the possible reason?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Swapnil,

Could you please show a bit more about your error message?
Further, do you want to get rows of the excel file using Google Sheets connector?

The 404 error told that the resource that you request is not found. The excel file is created in Google Drive rather than Google Sheets, we couldn’t read the created file in Google Drive using actions of Google Sheets connector.

If you want to read the created file in Google Drive, please take a try with the following workaround:

Add “When a new email arrives” trigger.

Add “Apply to each”, input parameter set to output of output of above trigger.

Within “Apply to each”, add “Create file” action of Google Drive.

Add a “Get rows” action of Excel connector, create a connection to Google Drive, the screenshot as below:
Note: The data of Excel file should be formatted as a table, otherwise, the "Get rows" action of Excel connector will not take effect.

Image reference:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
Swapnil 8 on at

Like (0)

Report
Copy link

Link copied!

hi @v-xida-msft

Thanks for your reply.

Following is the screenshot with the error msg. In get sheet action I had given the "id" of the file created in google drive.

Yes I want to get rows from the excel sheet.
The excel file is created in Google Drive rather than Google Sheets, we couldn’t read the created file in Google Drive using actions of Google Sheets connector. : Did not understood this.
Is there a way to create file in google sheets?
I have tried the same thing with Excel connector, but the issue with that approach is we need to manually define the excel table in each sheet of the excel, since excel connector can only retrieve the data from the sheet if the content is marked as excel table.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Swapnil,

Creating files in Google Sheets is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

More details about the Google Sheets connector, please check the following document:

Google Sheets connector

Best regards,

Kris

Was this reply helpful? Yes No
Swapnil 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft

Thanks for the reply.

Was this reply helpful? Yes No