How do you send information to a specific cell from Google Sheet with mit app inventor?

[programmer]

Hello
Is there a way to send the data in the program to a specific cell for example A10 in Google Sheet?
I am looking for a method that the user sends from the Google sheet application is editable, that is, by sending new information to the same cell, the previous information is edited.

[TIMAI2]

No extension needed, you can use the native spreadsheet component for this.

[Spicy_Topics]

@programmer

the previous information is edited.

yes of course the second value will be overwritten

[programmer]

If you can explain more, I don't know so much

[programmer]

What is your method for this?

[TIMAI2]

@programmer

If you can explain more

Spreadsheet component. Example. Google Sheets

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. How to create the Service Account, here: http://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html At the end of the whole process we will obtain a file of the form: app-inventor-338017-8c72fd465555.json We must upload…

[Spicy_Topics]

Or this method also can be used with web component

METRIC RAT AI2 - Google Sheets for AppInventor

@programmer

your method for this?

i always use this script, given in the above link (credit @TIMAI2 )

[programmer]

I succeeded with your guidance, thank you very much

[programmer]

Thank you for your guidance.