Built In Google Sheets Component for App Inventor

Open Source Development
114

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 :100:**% completely free** with 300 read and write requests per minute.

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

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

1 Like
115

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.

116

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.

117

(added to FAQ)

118

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

119
120

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.

122

4 posts were split to a new topic: Transferred from Google Sheets Test Server to aia server. Save to PDf no longer works

123

A post was merged into an existing topic: Transferred from Google Sheets Test Server to aia server. Save to PDf no longer works

Started a new topic for this, as not related to Google Sheets Component

124

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..

blok
blok1064×466 50 KB

credential
credential1574×641 37.8 KB

125

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?

1 Like
126

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

127

Screenshot_20230224-104959_Chrome
Screenshot_20230224-104959_Chrome720×1600 182 KB

Screenshot_20230224-105055_Chrome
Screenshot_20230224-105055_Chrome720×1600 117 KB

128

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.

129

this is the error message,

error
error506×585 81.5 KB

130

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

132

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.. :pray:

1 Like
133

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

134
  1. set role of my credential as editor / owner
    role
  2. then I generate key in json format
    generate key
    generate key1647×388 29.4 KB

    checklist first and manage keys
135

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.

1 Like