Built In Google Sheets Component for App Inventor

[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?

[Gordon_Lu]

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.

[Nova_Sulistyo]

sorry I'm a beginner, I tried to post data to google spreadsheets but it failed, am I wrong in creating the credentials or the block, please help me..

[ABG]

Did you create the ,json file mentioned in
http://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html
and upload it to the Media folder?

Did you create a Google Project?

Did you create a service account email address?

Did you share update permission to your sheet with that service account?

What was the error message?

[Nova_Sulistyo]

yes sir, i have done it, i have created developer account, service account, generated key in json format then upload in media, but i failed to enter data into google spreadsheet

[Nova_Sulistyo]

[ABG]

Pull in the Spreadsheet event block that catches errors, and have it post the error to a Notifier with an OK button, so you can catch and show the error here.

[Nova_Sulistyo]

this is the error message,

[TIMAI2]

Are the designer properties for the Spreadsheet component correct ? (Spreadsheet ID, Sheet Name, json file...)

[Nova_Sulistyo]

finally I succes to post the data to google sheet, my mistake was when configuring the service account, thanks for the insight and your advice..

[ABG]

Can you post a screen shot of the solution, for the next person?

[Nova_Sulistyo]

1. set role of my credential as editor / owner
   
2. then I generate key in json format
   
   
   
   checklist first and manage keys

[Susan_Lane]

This is useful to have on the forum. I'm sorry this process is so cumbersome, but we don't currently have a way to make the Google process smoother.

[Daniel_Fontolan]

The Query Block is not avaible for me. I can´t find the ReadWithQuery method nor GotQueryResult event. Could you please help me?

[TIMAI2]

It was unfortunately removed from the component in a previous update.