Select specific data in google sheets

[marcio_rosalen]

Hello dear programmers.
Today is my first day programming and I need to adjust the code below to extract only the cell value. I'm not able to do this.
Can you help me?
Thanks for all the help.

void loop()
{
    bool ready = GSheet.ready();

    if (ready && !taskComplete)
    {

        FirebaseJson response;
 
        Serial.println("\nGet spreadsheet values from range...");

        bool success = GSheet.values.get(&response /* returned response */, "My Id Sheet" /* spreadsheet Id to read */, "TESTE!A1" /* range to read */);
        response.toString(Serial, true);
        Serial.println();

        //It works until here where it shows various information, but I only need the value found within the cell
        //I'm trying this but without success

        FirebaseJsonData result;

        response.get(result, "values/[0]/[0]");
        
        Serial.printf(result); 
        
        taskComplete = true;


    }
}

Basically I need to store only the highlighted value in a variable

[StefanL38]

Do some reading with this google-search results and then come back with specific questions
https://www.google.com/search?as_q=arduino+json+extract+data+from+json