I need help with exporting data from app inventor to google sheets

[amercado]

Hello everyone,

I'm trying to make an application where I can export some data from my app to google sheet. The data is being exported, but when I do it with special characters (Example: José, Martínez, Mañana) it exports the data to my google sheets but without the special characters (Jos, Martnez, Maana). Is there any way I can make my application to export the data correctly? Thanks!

[Patryk_F]

You probably use the "putText" block?

Try it this:

instead of this:

[amercado]

I tried the method you gave me and it didn't work. This is how my block looks and it's exporting the data successfully, the only problem is that it won't copy the special characters to google sheets.

[Patryk_F]

As I wrote above. They'll replace their method with mine, and it will work. You just need to change "number=" to "?number=".

[TIMAI2]

See this guide:

Google Sheets - Simple Post and Get Data

Here, in my view, one of the simplest solutions to uploading and downloading data to a google sheet from AI2. Google Sheets - Simple POST and GET Data

Works OK for me:

[Juan_Antonio]

@amercado

p136ii_googlesheet_GET_POST.aia (3.2 KB)

Use GET
or
POST and UriEncode

GET: El ñandú de Cádiz.
POST: El and de Cdiz.
POST + UriEncode: El ñandú de Cádiz.

function doGet(e) {
var sheet = SpreadsheetApp.openById(e.parameter.Identificador_Hoja).getSheetByName(e.parameter.Nombre_Hoja);
var func = e.parameter.func;

if (func == 'myFunction') {
rx = e.parameter.rx;
cx = e.parameter.cx;
vx = e.parameter.vx;
sheet.getRange(rx,cx).setValue(vx);
return ContentService.createTextOutput("Agregado con GET.");
}
}

/////////////////////////////////////////////////////////

function doPost(e) {
var sheet = SpreadsheetApp.openById(e.parameter.Identificador_Hoja).getSheetByName(e.parameter.Nombre_Hoja);
var func = e.parameter.func;

if (func == 'myFunction') {
rx = e.parameter.rx;
cx = e.parameter.cx;
vx = e.parameter.vx;
sheet.getRange(rx,cx).setValue(vx);
return ContentService.createTextOutput("Agregado con POST.");
}
}

[amercado]

Your method worked! I just changed number to ?number and it works perfectly. Thank You!