Email connector

vaco
vaco Member

Hi, we are getting data in excel format from a service provider by email. I was trying to use the email connector, but only the data on the first page is uploaded in domo while we need the second to the 4th page. Is there another way to automate this task in Domo? Thanks

Best Answer

  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓

    You'll have to set up a separate import for each tab in your document. There is an "Excel Sheet Tab Number" parameter when you set up the connector. If they all have the same data structure, you can then use a dataset view or Magic ETL to union them together.

Answers

  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓

    You'll have to set up a separate import for each tab in your document. There is an "Excel Sheet Tab Number" parameter when you set up the connector. If they all have the same data structure, you can then use a dataset view or Magic ETL to union them together.

  • vaco
    vaco Member

    It worked! Thanks @Sean_Tully 😀