Sure, that’s possible. Check here: https://developers.google.com/sheets/api/guides/values
I would love to write to a Gsheet using the API as well. Could some one digest the documentation which Henri advised? My main struggle is how to set up the POST call around the array with values. Meaning, how to translate this part into Mendix:
$client = new Google\Client(); $client->useApplicationDefaultCredentials(); $client->addScope(Google\Service\Drive::DRIVE); $service = new Google_Service_Sheets($client);