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.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 560 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 575 Beast Mode
- 13 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive