Is it possible to upload many google sheets at the same time?
I have 30 sheets under a google sheet workbook. Can I upload them(30 sheets) in one time?
Now via Google Sheets Connector, I can select only 1 sheet each time. I have the whole year data waiting to be uploaded, It is really too many manual workload.
Is it possible to upload many google sheets at the same time?
Best Answers
-
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()
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**2 -
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.
3 -
@Lu_zhang sure, happy to help. For an example, let's say you have the following 3 sheets, all with the same column headers.
Sheet1, Sheet2, Sheet3
You can use the following formula to combine all 3
=UNIQUE(QUERY({Sheet1!A1:C;Sheet3!A1:C},"WHERE Col1 IS NOT NULL ORDER BY Col1 ASC"))
You would adjust with your sheet names and columns. In this case there are 3 columns, so I go to Column C.
Unique makes sure that there are no duplicate rows, and also allows you to pull in the headers only once. It's important that there is a primary key in your dataset when taking this approach. In this example, I'm assuming that Col1 is the primary key (hence the NOT NULL check).
The formula that you see pulls together all 3 sheets into one.
Hope this is helpful!
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**2
Answers
-
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()
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**2 -
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.
3 -
@david_cunningham Thank you for the enlightment. Can you show me how to design QUERY() function in Google Sheets alongside ArrayFormula()? This way looks automatic with small manual workload, but I failed to design it.
0 -
@Lu_zhang sure, happy to help. For an example, let's say you have the following 3 sheets, all with the same column headers.
Sheet1, Sheet2, Sheet3
You can use the following formula to combine all 3
=UNIQUE(QUERY({Sheet1!A1:C;Sheet3!A1:C},"WHERE Col1 IS NOT NULL ORDER BY Col1 ASC"))
You would adjust with your sheet names and columns. In this case there are 3 columns, so I go to Column C.
Unique makes sure that there are no duplicate rows, and also allows you to pull in the headers only once. It's important that there is a primary key in your dataset when taking this approach. In this example, I'm assuming that Col1 is the primary key (hence the NOT NULL check).
The formula that you see pulls together all 3 sheets into one.
Hope this is helpful!
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**2 -
@david_cunningham I've tried this approach and I am being shocked. It is so great way! VERY FAST! thank you!
2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive