Best Of
Re: Is it possible to upload many google sheets at the same time?
With the Google sheets connector, you have to specify which sheet you want to upload, so unfortunately there isn't a built in way to do this.
Here is what I would recommend
Assuming these sheets all have the same columns. Which I'm guessing is the case since you're wanting to stack them. Combine all your sheets together in Google Sheets or Excel, and then upload that combined file to Domo. This would be much faster than uploading each individual sheet to Domo.
To do this, you can use the QUERY() function in Google Sheets alongside ArrayFormula()
Re: Find Employees Manager Manager
You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.
Re: Is it possible to upload many google sheets at the same time?
Agree with @david_cunningham here, and wanted to point out even if the columns weren't the same, nothing stopping you from making your dataset super-wide and splitting the columns in MagicETL. In other words, you could put your tables side-by-side up to 18,278 columns of data then import.
Re: Indexing Help
You don't need to explicitely create indexes as you would in traditional databases. Domo's automatically optimizes for performance. Slow performance may be due to complexity of the dashboard or an issue in how you have things structured.
Re: Scheduled Report - Excel Attachement
Would it not be better to give users the option to decide whether they want to receive a csv or a xlsx?
@Jones01 how can I request the feature switch please? thanks




