Automate DOMO pulling an Excel File

ColinHaze

Hi,

I have several excel files that I upload to domo manually every week. I was wondering what would be the easiest way to have DOMO grab and update the file automatically. This would be my first time doing this so if you could provide the steps that would be super beneficial.

ColemenWilson

Is the file name, format, tab name, etc… remaining the same and just the data changing? If so, the files could be stored in OneDrive and you could use the OneDrive for Business connector in Domo. https://domo-support.domo.com/s/article/360043436753?language=en_US

Otherwise, this sounds like a job for Workbench https://domo-support.domo.com/s/article/360056669354?language=en_US

Ashleigh

@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think there is also an excel plug in where you can have a file directly connected to Domo and you can just click upload. https://domo-support.domo.com/s/article/360043437933?language=en_US

ColemenWilson

Is the file name, format, tab name, etc… remaining the same and just the data changing? If so, the files could be stored in OneDrive and you could use the OneDrive for Business connector in Domo. https://domo-support.domo.com/s/article/360043436753?language=en_US

Otherwise, this sounds like a job for Workbench https://domo-support.domo.com/s/article/360056669354?language=en_US

ColinHaze

ColemenWilson I just read about that one but we dont really use one drive. I was thinking either the Excel SFPT connector or workbench. Im not quite sure what the difference is.

Ashleigh

@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think there is also an excel plug in where you can have a file directly connected to Domo and you can just click upload. https://domo-support.domo.com/s/article/360043437933?language=en_US