FLOW: Error "Google Sheets invalid spreadsheet url.\"

Shopify Plus
1

Hi everyone!

I am trying to use FLOW to add data to a google spreadsheet. But somehow I keep getting the error that the URL is invalid.

{“status”:400,“response_body”:"{"message":"Google Sheets invalid spreadsheet url.","body":"

In my action I used the URL google provides for sharing:

https://docs.google.com/spreadsheets/d/12GXbZwBAgzJFb2-YD_pUWAgmS59-on9xpZ5KaTKUxWY/edit?usp=sharing

I also tried

https://docs.google.com/spreadsheets/d/12GXbZwBAgzJFb2-YD_pUWAgmS59-on9xpZ5KaTKUxWY/edit#gid=0

and just

https://docs.google.com/spreadsheets/d/12GXbZwBAgzJFb2-YD_pUWAgmS59-on9xpZ5KaTKUxWY

All result in the same error. The spreadsheet is set as shared and with writing permissions.

So my question: Whats the correct URL syntax to get speadsheet access to work?

Thank you very much in advance!

Armin

2

Hm, got it to work by myself by actually just waiting some time :thinking:

3

Its important to use this format:

https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxx/edit?usp=sharing