Goggle Sheets - Can a single cell be accessed and used?
Best Answer
-
Here is an example of how I brought a specific cell into Domo:
Here is what my google sheet looks like and I want the green highlighted value in cell E2
This is how I would setup my connection to the google sheet in Domo:
Output:
Alternatively, if you are bringing in the entire sheet, you need some way to point to that cell. Generally you would use a case statement or filter tile to return the value you are looking for from the column. So if your data was formatted like the below, then you would create a case statement.
Something like this:
MAX(CASE WHEN `Total` = 'Total' THEN `Org #` END)Which would return the value 3 highlighted in dark purple above.
If I solved your problem, please select "yes" above
0
Answers
-
Yes. You can use the Google Sheets connector to connect to the sheet. You could bring in all the data for that sheet and in an ETL pull the specific cell you are looking for, or choose a specific range (in this case just the cell and a cell to the left or above it as the header) to pull in.
If I solved your problem, please select "yes" above
0 -
I am pretty new to this so please bear with me… I have the input dataset google sheet set up in my etl…..
but do not know how to access a specific cell's value
0 -
Here is an example of how I brought a specific cell into Domo:
Here is what my google sheet looks like and I want the green highlighted value in cell E2
This is how I would setup my connection to the google sheet in Domo:
Output:
Alternatively, if you are bringing in the entire sheet, you need some way to point to that cell. Generally you would use a case statement or filter tile to return the value you are looking for from the column. So if your data was formatted like the below, then you would create a case statement.
Something like this:
MAX(CASE WHEN `Total` = 'Total' THEN `Org #` END)Which would return the value 3 highlighted in dark purple above.
If I solved your problem, please select "yes" above
0 -
thanks a bunch Coleman!
I Very much appreciate the excellent explanations with screenshots!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive