Built In Google Sheets Component for App Inventor

[ewpatton]

We've decided that the component will go into the next release as-is and then we will make usability adjustments afterward.

[Know_About_IT]

I am happiest one to know this

Finally it came !!

[James_Park]

I have searched but unable to find a development time line. Is there a planned date for the next release containing the Google Sheets component? or can you direct me to the correct tool for monitoring development time line please?

ta

James

[ewpatton]

Tentatively the release date is July 12.

[Rafael_Ahl]

Today? Or not?

[Taifun]

@Rafael_Ahl

Or not?

See here

Android Bundle NOT APK to upload and update an app on Google Play starting August 2021

The release needs to be delayed until the File component changes have been merged as part of our SDK 30 update. You can follow that discussion and help with testing the functionality in this thread.

Taifun

[triforcexp]

Will this ever be released?

[Susan_Lane]

Google changed the Sheets API between the time this was written and now. leading to some rewrites that have slowed the component down. I hope to have a new component available for testing in the near future.

[Susan_Lane]

This is the more recent thread. I believe I may have accidentally overwritten the test server, however.

Testers Wanted: Google Sheets component

[t8] [t9] [t10] Correct @Susan_Lane , if the last column is empty, the values ​​are inserted. AddCol is similar to WriteCol. The advantage of WriteCol is that it does not give an error when we click a second time, that is, if we execute AddCol to an empty column twice, we get an error, but with WriteCol we can execute it several times and it does not give an error.

[Shanmuga_Nathan]

it's been nearly 2 years now, Google Sheets Component works fine, will it be added in next update.
or
Let me know that the test server will not shutdown in future as I may lost all the projects, if it gets shut down

[Susan_Lane]

@Shanmuga_Nathan We're not prepared to include it in the next release, but it's in final review with the dev team. Assuming no other significant bugs are found, it should release in the near future.

It sounds like you've been doing some significant work with the component and find it works well. Could you give me some idea of the kinds of projects you've been using the component for? This is incredibly valuable feedback. It's difficult for the team to approve and merge big, complex changes like this because we are small, and it's very difficult to test them completely. This component required quite a bit of redesign because of changes Google made to its API.

Feedback from you and anyone else who is using the component on the test server can speed up our approval process.

As far as your projects, I recommend you keep backups. Export them to your computer using the "Export all Projects" option from the Projects drop-down menu. When we merge the component, you will need to import your projects on the normal server. Also, though I have no immediate plans to take down the test server, it's just a test server with no guarantees. Many things could happen, including things completely out of my control, that could wipe it out.

[Shanmuga_Nathan]

@Susan_Lane

Could you give me some idea of the kinds of projects you've been using the component for? This is incredibly valuable feedback.

I just need to say that it's the best alternative to Firebase Database, the speed of this component is equal to the speed of Firebase DB and the notable thing is the API **% completely free** with 300 read and write requests per minute.

Also no coding knowledge is required like Firebase DB as the Google Sheets Component is basically an Excel sheet.

@Susan_Lane

idea of the kinds of projects

TEST server is too old, and i cannot copy screens, I'm just testing out the component and all blocks on a regular basis and providing feedback. If you upgrade the test server version to latest, then I can provide all my project ideas even with free AIA

[Shanmuga_Nathan]

@Susan_Lane

It's difficult for the team to approve

I hope the main purpose of MIT APP INVENTOR is no code, then This component will be easy for beginners and zero coders to create a no code private and secured Database at no cost.
Hope the team will bring the component soon in next few future release.

[Shanmuga_Nathan]

@Susan_Lane

out of my control

I understand, but if the test server is gonna Wipeout, please send a reminder date to the users, as it might be very useful to take project backups.

[ABG]

(added to FAQ)

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - TimAI2 Google Sheets Create/Read/Update/Delete(CRUD…

[VIVEKANANTHASIVAM_R]

Sir, When i build apk file, there is an error. Server error: could not build target. Please try again later!.
any idea?

[gordonlu310]

MIT Stata Center Powering Down Saturday

On Saturday, January 14th, the building on the MIT Campus (the Stata Center) that hosts some MIT App Inventor servers, will have its power turned off from 8AM local time until 4PM. The critical servers that would be affected have been moved to the cloud. However some servers remaining on campus have backup power and were not moved. The iOS buildserver was not able to be moved and will be unavailable. If you encounter difficulties, please visit the App Inventor help section of the Community we…

[ewpatton]

The spreadsheet component has been published, so the test server in this thread is no longer relevant. Please move any projects from the test server to either ai2.appinventor.mit.edu or code.appinventor.mit.edu.