Spreadsheet (Google)

Saya ingin menampilkan data hasil pencarian/ filter dari textbox1 dengan data dari google spreadsheet dimana cell A2 ditampilkan di textbox2, cell A3 di tampilkan di textbox3.

saya mencoba menggunakan "spreadsheet" namun kebingungan dalam mengisi data Applicationname, Credentials.Json, dan SpreadsheetID.

apakah bisa dibantu

Hello hrd silcane

It is a little complicated to setup the spreadsheet.

From the Tooltip in App Inventor:

Spreadsheet is a non-visible component for storing and receiving data from a Spreadsheet document using the Google Sheets API.

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API.

Instructions on how to create the Service Account, as well as where to find other relevant information for using the Spreadsheet Component:


If you only want to GET the data from the google sheet, and the google sheet is set with "Anyone with the link", then you do not need to setup the Spreadsheet component. You can use the web component, and call down the sheet data as a csv, then work with that data to display your information in textboxes.

If you just want a range:

Application Name is not a URL.

setelah menjadi format csv, apakah kita bisa ambil data nya untuk mengisi textbox atau hanya ditampilkan dalam listview?