Email connector

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
-
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.
1
Answers
-
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.
1 -
It worked! Thanks @Sean_Tully 😀
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive