Excel Sheet to Domo

jmmc
jmmc Member
in Datasets

Hi Everyone, Happy Friday Eve.

I have a shared Excel workbook with multiple sheets that are appended together via power query into a master list sheet.

I'd like to set up a Domo connector to pull from this master list sheet only.

Is this possible? What is the ideal connector for this, and where is the ideal place to store the Excel workbook? Currently the book is just saved on one drive but it can be moved to share point.

Tagged:

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    I would suggest using the OneDrive for Business Connector. It is fairly straightforward to setup and you can control which sheet in the file you pull from: https://domo-support.domo.com/s/article/360043436753?language=en_US

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

  • Ashleigh
    Ashleigh Coach
    Answer ✓

    @jmmc if you can't use the one drive connector (like me) you can also use a combo of Power Automate and the Email Connector. I set up Power Automate to read the file and send an attachment via email and then used the Domo Email Connector to bring it in.

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

Answers

Categories