Google Sheets as an API

Using Google Apps Script (a very helpful extension developed by Google) extension in Google Sheets, we can use our Google Sheets spreadsheet as an API to post/update/read/filter data.

Updating Multiple fields at once

The current update block of Google Sheets datasource in Thunkable allows us to update only one field at a time. Working with this block is easy, but certainly not efficient if we want to update multiple fields for a certain row.

Let's have a look at how we can do this efficiently with Google Apps Script & the Thunkable API component.

Setting up Apps Script on our Spreadsheet

In the Extensions menu in toolbar, click on Apps Script, which opens a new app script project for this spreadsheet in a new tab.

The new tab opened will look like this, which would have code.gs file opened in our Apps Script project. You can rename your apps script project by clicking the 'Untitled Project' beside the apps script logo.