Answered
Automation for Google Drive
One of the manufacturers provides a google sheet as an inventory ( with a public access)
How would you set up an automation for this?
One of the manufacturers provides a google sheet as an inventory ( with a public access)
How would you set up an automation for this?
Hey Erno,
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.