Tengo un problema con la extracción de datos de google sheets a mi aplicacion en mit app inventor

El contexto de la aplicación es la asignación de turnos, pero eso ya esta resuelto, lo que quiero es que se vean 2 columnas de celdas de google sheets en mit app inventor, pero con los tutoriales que he visto no a salido como espero o siquiera funciona, adjunto bloques de una prueba que hice, posdata lo intente con un scrip.

Perhaps try with Tableviewer instead of listview ?

but, the data that I need to be seen in the application is from google sheets

With the method you are using, the data is returned as a csv table.

Can you show me where you got each block from, as well as what it looks like?

What do you not see from the aia project I linked ?

Hello, timai2, yes it works for me but I need you to make the connection with a google meet sheet as a database where the data that the list will show in the application is generated

image

I thank you for your quick answer TIMAI2, the first link is from the sheet, but where are the second and third links from?.

I can't find it since I have it in Spanish

There is only one link / spreadsheet url ?

me refiero al segundo, luego del link de la hoja, por que el tercero es del rango que se va a enviar

I am sorry, I do not understand what you mean....

  1. where did this come from?
    Captura de pantalla 2023-04-11 153445

2.Where did the table viewer come from or from which block is n taken?

  1. It is just a google sheet (ID) I use with a table of data, for examples and demonstrations...

  2. If you go back to post number 2 in this topic, I suggested using Tableviewer to display your two columns of data....

Could you send me the extension, I can't find it, I'm very new to this so do you know how I can get the (ID) from my google sheets sheet?

Go to THIS URL, you want v6

If you open a google sheet you will see its url in the url address bar at the top. The ID is the long string of characters in the middle of the url.
for example:

https://docs.google.com/spreadsheets/d/1IdpGILd7Nii8nq5yb2Qu3kVFyyL50eo5la2xbDN1Cok/edit#gid=0

The ID is:

1IdpGILd7Nii8nq5yb2Qu3kVFyyL50eo5la2xbDN1Cok

keep bugging about cvs

What does your responseContent look like ?

It looks something like this when I ask for the list

What does your responseContent look like (see my previous post for how to show it) ?