If you do not meet the following guidelines you may be charged $75/hour to resolve your issue. Only open a P1 ticket for EMERGENCY Issues with LISTING/ORDERS (NOT ADDING/EDITING) for over 25% of items having a material effect on your business income or if you have received a warning of suspension/have been suspended from channel.
Do you still want to set this as a P1 issue?
In the connection part of the config, try setting "method" to "GET" and "address" to "https://docs.google.com/spreadsheets/d/<yourkey>/export?exportFormat=csv", and set up the rest of the config as normal.
Let me know if that works, and if it doesn't, if you can provide the link to the spreadsheet, I can try to test locally and provide a working config.