Hi all users,
I have a question about reading data from Google Sheets API v4
I use this format from google sheet API : https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
Unfornately I dont know how to write this data back into UI BAKERY, maybe some data mapping required as the header is separate from the values array
Below is the result from my sheets API
{
“range”: “Users!D1:G10”,
“majorDimension”: “ROWS”,
“values”: [
[
“Last Name”,
“Grade”,
“Class”,
“Email”
],
[
“SS - Nguyễn Tuấn Anh”,
“ASM HNC01 - Phan Hùng”,
“Linh Giang”,
“RH14801”
],
There is an example of Airtable template, however the structure of data return is very different . Also I think Airtable quota for http request is limited to 5 request / second / base , thus cannot scale to many users (Refer to this : https://community.airtable.com/t/hitting-api-limits/22810)