Built In Google Sheets Component for App Inventor

You would probably get a better response posting on the original announcement thread:

(topic moved by ABG)

I'm seeing a host not found exception on the server side, but the build server is up and I can resolve the name on my laptop. Not sure what's going on but for some reason the service at Google isn't able to find the buildserver at MIT.

Thank you ewpatton for the clarifications. If I understood correctly, it is not a problem with my connection or system. It is problem with Service at Google which maybe solved in sometime. At present there is nothing I can do from my side to solve it.

I have used the Google Sheets Component on test server, and develop a project to query, delete, add sheet data successfully. Many thanks to [Tommy](https://community.appinventor.mit.edu/u/Tommy_Heng).
When to go online can be placed in ai2? I want to embed this unit in my course, and teach many students to link data table and APP freely.

1 Like

I tried to use the write cell block but nothing changes to my spreadsheet

Hello, just wanted to know where can I find this component? I am unable to find it on the test server(https://ai2-test.appinventor.mit.edu)

The test server for this component can be found here (http://sheets-dot-ai2-ewpatton-temp.uc.r.appspot.com/ ). To clarify, this Google Sheets component is not a feature of the current release of App Inventor and is still under development. In order to use the Google Sheets component, you will need to use the test server linked above and download the companion from the test server by clicking Help > Companion Information . The download link for the test server's companion will be in the resulting pop-up

Below is a tutorial called The PizzaParty App which had previously used the Fusion Tables component. This tutorial has been updated to use the new Google Sheets component instead.

When I try to compile the app, it gives an error!
"The build failed! Connection refused"

Does anyone know why or how to help?

Which server are you using?
I hope not one of the test servers.

oh no..
I'm using http://sheets-dot-ai2-ewpatton-temp.uc.r.appspot.com/

You're at MIT's mercy, unless you can export your .aia and move to one of the regular servers.

I already tried this at http://ai2.appinventor.mit.edu but I get the message that the Google Sheets component could not be found while loading the project.

There are alternative ways to use Google Sheets at

if you can migrate the remainder of your app.

I have no forecasts on when MIT will implement this block type.

I hope it will be implemented soon, but let's wait.
In the meantime, I will test your suggestions, thanks.

Hi, I would love to try out the use of google sheets in the PizzaParty app to get started with using google sheets in apps. I found the tutorial very clear - thank you! I am using the test server http://sheets-dot-ai2-ewpatton-temp.uc.r.appspot.com and have issues with connecting to the companion. I downloaded from the companion from the code given under "help" - " Companion Information" on this test server, I get the message " MIT A12 Companion has stopped". Any advise ? Or is there a way to run the emulator on the test version? ( I tested and can run the "published" version of the companion - but that does not link to an app made on the test version.) any advise is welcome!

Wandering onto a closed construction site is risky.
While we wait for announcement by MIT as to the disposition of the Tommy Heng blocks,
consider using the Google Script control technique described by @TimAI2 at

That approach has the advantage of not requiring special servers or Companion versions, at the expense of learning to do some scripting.

Regarding your data structure and sheet design, I have a sample for a Pizza Store further up in this thread, using the app name APizzaSheet (pun intended.)

Dealing with multiple Companion versions is easier if you use alternative emulators.

When will the next update with this be released? I'm trying to build an app for a project, and this would be an immense help! Is there any way to get the not complete version as an extension into the official App Inventor?

1 Like

Welcome cweditor

Sorry, there is no way to provide you an early copy of the App Inventor tool that is in development. The tool is NOT an extension; it is an App Inventor 2 component so no extension. The tool will be part of a component release of AI when it is available. When? When the bugs are out of the tool. It may be a few months or more in the future.

In the meanwhile, use the api as described below. This works as well as the tool in testing for most people.

You might want to re-read the information posted earlier in this thread.

Where is the extension download link?