Shopify Flow error: Google Sheets url not found

[Artamonz]

I gave access to my Gmail account and used the google sheet sharable link for this flow. But still, get this error. Is there is something else that needs to be done with URL?

{"status":404,"response_body":"{\"message\":\"Google Sheets url not found.\",\"body\":\"{\\n \\\"error\\\": {\\n \\\"code\\\": 404,\\n \\\"message\\\": \\\"Requested entity was not found.\\\",\\n \\\"status\\\": \\\"NOT_FOUND\\\"\\n }\\n}\\n\"}","verb":"POST","url":"https://flow-connectors.shopifycloud.com/actions","request_body":"{\"shop_id\":57746063529,\"shopify_domain\":\"foodhere.myshopify.com\",\"properties\":{\"spreadsheet\":\"https:\\/\\/docs.google.com\\/spreadsheets\\/d\\/e\\/2PACX-1vTkgxyGIJdahXPpEOi37uM9JikqC-OHaDHuKkeDhmuDx3QDd7txABmhxOCj9kxSOkBtQ5vqkdhooRzP\\/pub?output=csv\",\"worksheet\":\"customer without account\",\"row\":\"2022-01-20T08:09:08Z,INVITED,customer@email.com,Customer,C,true\"},\"action_run_id\":\"6c44a39dbb9de22582d1559e3c66333f187bff96\",\"action_definition_id\":\"Add row to spreadsheet\"}"}

[Hannah99]

I have been having the same issue without finding a solution 😕 

[RennWelten]

Did you ever find a solution to this issue? I am facing exactly the same problem and cant figure out the correct syntax for the spreadsheet URL to get it working ...