We are excited to announce the preview launch of AppSheet integration with Google Data Studio. Data Studio is a rich reporting and dashboarding tool that is available to AppSheet subscribers at no extra cost. Use Data Studio to generate fully customizable visualizations of your app data and combine data from multiple data sources to generate a rich dashboard to share with stakeholders. We are looking for users to build reports on Data Studio, provide us with feedback including bugs and ideas for enhancements.
|
|
|
| - | - |
Access requirements: You must be an app creator to visualize your app data using Data Studio. You need a Google account to use Data Studio. You can only access your AppSheet apps created with the same Google account.
Why use this feature:
This feature lets you reuse your existing data model from the app in Data Studio. Without this feature, users will have to directly use their underlying data source(if supported) in Data Studio or other BI tools, and recreate the data model and then configure reports - a tedious process. AppSheet Connector for Data Studio avoids this step by making app data and its model directly available in Data Studio.
Preview link: To start creating the dashboard for your apps, you can access the Data Studio Connector via this link. This link must be visited at least once to activate the feature.
Updates as of 6/15/2022
- Configure data freshness down to 15 mins, with default being 1 hour.
- Data Sources are named based on the App name and Table name instead of “AppSheet”.
- Data source allows changing the App and the table in a pre-configured data source.
Get Started:
To help understand the Data Studio features, we created a quick tutorial here. This tutorial will help you learn how to:
- Create a Data Studio data source linked to a table in an AppSheet app.
- Create a Data Studio report using this data source.
- How to Use your new report and drill-down across dimensions.
- Schedule an email delivery of the report as a PDF.
Learning resources:
How do I give feedback?
Please add your feedback directly to this post!
17 Likes
Awesome!
I was able to follow the connector preview link, connect to my Appsheet account, select an app, select a table, and create a report on the source. Including virtual columns!
8 Likes
GRREEEATTT !! I’ve been waiting for this integration 
Thank you!
4 Likes
I assumed this connetors will automatically establish “blending” tables, based on the REF column which is set in AppSheet side, using GDS blending multiple table feature (introduced earlier this year in Feb/2022. However, it appears to me we have to re-create such relationship between tables after reading multiple tables from AppSheet app. Currently REF type column in AppSheet tables are not supported? This part of process (establishing relatinship in GDS) is tedius, and hoped new connector will makes our life easier to start buiding dashboard, retaininng the relations between table which are defined in AppSheet, more simply speaking the connector respect REF type column in AppSheet.
Or am I missing something?
7 Likes
@preethamm
Data freshness is fixed at 12 hours for AppSheet and cannot be changed, while with Google Sheets you can choose 4 hours, 1 hour or even leave it at the default of 15 mins. 
So I should tell the customer you have this great opportunity to have your reports displaying every 12 hours instead of 15 mins?!! 
That’s a deal breaker.
8 Likes
Thanks for trying the feature! You are correct. We do not have the new “blend” feature based on the Refs. This is mainly because Data Studio can only import one table a time and blending is only available at report level(it is not a real data source). We are working with Data Studio team to see if we can do something here but we do not have any concrete solution yet.
If there are enough community requests for this, it would help us prioritize this with the Data Studio team.
12 Likes
Good point! 12 hours is the default refresh rate and it is too big. I will discuss with the Data Studio team on lowering this and get back to you.
9 Likes
@preethamm Thanks you for your clarity, understood.
Yes, data blending in GDS (GDP?) is only happening on report level, which is a problem to me, making our works less productive. We make appsheet app and set up schema (connect tables), but we need to do those process again with GDP, which I have to admit cumbersome. Lack in auto-generating ref (blending), the benefit using with this new connector seems to be “GDS would read VC values to draw the chart” For the rest to build dashboard, the process would be exactly same as we connect to other data sources such as spreadsheet.
I just conducted a quick test (just a single shot), and earlier feedbacks are : -
-
Only able to add one table at one time from appsheet app.
-
Probably I m missing the right way to do it, but it seems we have to disconect a connector which was connected to a certain app in order to add connect with another appsheet app. We need to disconnect the connector (Which will break up the report) and then re-select another app to establish the connection.
-
As highighted here in this post, the data blending process is problematic, especially to connect app with large number of tables where each table has connection with others.
-
This could be native and inherite problems with GDP, so new connectors should not be blamed for, but the data sets we establish connection with blending is not re-useable in other place. We have to repeat the blending repeatedly all the time when we create new report file.
-
Wish to have capability to add multiple tables from app via single action rather than adding new tables from report and mix.
Will test further, but hope this will help.
@takuya_miyai
6 Likes
@preethamm
We currenlty dont have option for “iframe” globally in AppSheet. But for this data studio report alone, we wish to have option to add report through Iframe inside AppSheet app. Lets say, new view type is added to view settings and we simply past embed code into it to display dashboard as it they are built in dashboard inside AppSheet. Clicking url to open dashboard externally wiht browser is current option, but embeding report inside appsheet is more rubust. Thank you.
11 Likes
Thank you very much @preethamm and AppSheet team for providing GDS integration capability.
I also very much second the request by @Koichi_Tsuji . GDS capability is definitely great and will add great value and help get a bird’s eye view analysis of aggregated data of the entire app involving all app users/ all zones/ all stores / all time frames/ all orders / all projects’ progress that the app data provides.
But I think an app is equally used extensively by each user of the app. In that sense either iframe for GDS or strengthening charting capability to display natively in the app itself will go a long way. Each user will want to see graphical representation of my orders/ my sales/my attendance/ my tasks in my project, preferably in the app itself.
Request you to include iframing GDS / native display of charts in the app in your roadmap.
Incidentally, this recent post by another community member , just asks the same thing showing GDS in AppSheet app:
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Show-Data-Studio-in-AppSheet/m-p/408681#M160685
7 Likes
Currently, interval to refresh data souce is 15min 1 hours etc. Only the Report owner and co-author can manually and explicitly refresh the cached data to reflect the most latest backend data onto the charts. I know this should be thrown to Google Data Studio (or workspace) community instead of here, but GDS chart could work with Appsheet where any user who access to the dashboard/report could trigger such REFRESH option. App user edit the data, but they have no optoin to immidiately to refresh the report, then it will lead to the claim for sure. The realtime refresh could be difficult in view of the GDS current architectures, but at least we should present option to manually refresh the data, like we SYNC the AppSheet app to pull the most latest data over the app.
Once we present the GDS report to the user concurrenty present the appsheet app, user update the data from the app, but they surely claim the chat / reprort is not updated immidiately (min 15 min to wait to refresh. They dont understand why they need to wait.) Hence to solve this possible problem, heavy re-load to refresh GDS chart should be presented to all the user who are allowed to access to chart rather than giving this optio to owner/co-author of the report.
Thank you.
5 Likes
Hi @preethamm
Thank you for releasing the functionality to further utilize AppSheet. 
I have two pieces of feedback.
The name of the data source is always “AppSheet” by default.
It would be preferable to add it in the format “Application Name: Table Name”.
I think the message at the point of selecting a table should be “Click “Add” to continue”.
6 Likes
Thanks for trying the feature and pointing these out!
- Renaming the data source automatically is a good idea. I will bubble it up in our action items.
- “Connect” → “Add” : The button shows “Connect” text for me. This might be some translation issue and I will look into this further.
3 Likes
We will definitely look into this! I think this would be a great add to the desktop functionality. However for mobile, this will not fit well and we might have to do something custom.
3 Likes
I was added these as our action items to investigate further.
Re [2] You do not need to disconnect the data source. You could create one data source per table. Then you can use them in multiple reports.
Blending not being reusable definitely increases manual work. A potential workaround is to create the “blends” in AppSheet itself by adding columns or creating derivative tables. Then you can use it in Data Studio without manually creating blends. However, this depends on how data is structured and is not a universal solution.
2 Likes
Good point, @takuya_miyai
In terms of the default data source name after reading table from AppSheet, it might be better to give a name, by concate the name of app + name of table. Once we go on the journey with GDS + AppSheet, we keep adding the tables from various apps. Some table may have the same name. It is posssible we have the table with the same names (contents different). To get an idea which table and from which app at a glance of the list of data source, naming the data sources by concate app name + table name probably make us easier to find out who they are.
7 Likes
@Koichi_Tsuji Where do you see these 15 mins please? I can only see 12 hours that cannot be changed. With Google Sheets as a data source, yes. But with AppSheet, no, it is 12 hours fixed at my side. Thank you!
1 Like
Hi @Joseph_Seddik Sorry, my comment should have been unclear. As you pointed earlier in this thread, I also saw only 12 hours, did not find any other options. 15 min should be shorted interval when we connect other sources such as google sheet.
1 Like
