Connectors

Connectors

Automate DOMO pulling an Excel File

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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answers

  • edited January 2024 Answer ✓

    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. Site faviconCustomer Support Community

    Otherwise, this sounds like a job for Workbench Site faviconCustomer Support Community

    If I solved your problem, please select "yes" above

  • Coach
    Answer ✓

    @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. Site faviconCustomer Support Community

    **If this answer solved your problem be sure to like it and accept it as a solution!

Answers

  • edited January 2024 Answer ✓

    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. Site faviconCustomer Support Community

    Otherwise, this sounds like a job for Workbench Site faviconCustomer Support Community

    If I solved your problem, please select "yes" above

  • 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.

  • Coach
    Answer ✓

    @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. Site faviconCustomer Support Community

    **If this answer solved your problem be sure to like it and accept it as a solution!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In