Before opening a new ticket, please verify SureDone status at https://status.suredone.com and also review our helpful articles below.

Start a new topic
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?


Best Answer

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. 

1 Comment

Answer

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. 

Login or Signup to post a comment