Native connection from Google Data Studio to Appsheet (web data connector)

[Hamlet]

Would be nice to be able to work with virtual columns on Google Data Studio.

[MultiTech]

Why not make them physical columns then? (Would reduce load on your app, making it run faster.)

[Hamlet]

Hi Matt!

As of right now, they are physical columns. I have them setup using a Google Sheets formulas, because of the way they are calculated, but that means that in the app you get the “Sync to compute” message every time the column changes. I was thinking of making these columns into Virtual Columns so that the App user gets the new values faster, but then this change would make a Google Data Studio report unusable.

So I was thinking maybe there would be a direct AppSheet conector, but there’s not.

I could also make the column values get calculated using bots so that I don’t need Google Sheets formulas… Maybe I can quickly tell you how these column values work and get your opinion on how to best have them setup?

[MultiTech]

Hamlet:

I have them setup using a Google Sheets formulas

Move these to ‘App Formulas’ for the columns, this way their values are calculated by AppSheet and not dependent on the sheet.

---

FYI: It’s a best practice to remove any and all sheet formulas, conditional formatting, data validations, etc. from your Google sheet when using it as a data source for an AppSheet app.

[Hamlet]

MultiTech_Visions:

FYI: It’s a best practice to remove any and all sheet formulas, conditional formatting, data validations, etc. from your Google sheet when using it as a data source for an AppSheet app.

I figured as much. It’s just that these columns values need to be recalculated from changes in other tables. So I need bots to have them be recalculated. When I made the app, I didn’t know much about automation.

[MultiTech]

Hamlet:

So I need bots to have them be recalculated

Instead of using bots, I would try the following:

• Implement the quick update system in your app
• Move all your Google Sheet formulas into App Formulas for each column

This way when you need a row to update, you can simply call the update action and everything does what it’s supposed to.

[Hamlet]

MultiTech_Visions:

Instead of using bots, I would try the following:

• Implement the quick update system in your app
• Move all your Google Sheet formulas into App Formulas for each column

This way when you need a row to update, you can simply call the update action and everything does what it’s supposed to.

Thanks! Will do and post back.