Can anyone create this MIT AI2 Google sheets component as extension

I have been using this server "http://sheets-dot-ai2-ewpatton-temp.uc.r.appspot.com/" as it has Google sheets as storage component. But MIT version is outdated, where we cannot copy and paste arrangements to other screens. As Google provides free API with 300 Read and Write requests per minute, then it will be the best database. Please anyone give me the component as extension or "include the component in the latest version of MIT AI2

You could try searching Extensions

But it uses Apps Script which has daily limit of just 90 mins. Why that component is not added as it's been in testing for more than 2 years

That quota is for Triggers, my scripts do not use Triggers.

The Google Sheets component is still under testing, you can get involved and help test it, which may help to bring it into production sooner.

Ok brother, which means i can use the script unlimited times, to send and get data

There do not appear to be any read/write restrictions on google sheets using apps script.......


But I get this error, total executable time completed, and cannot run even single function untill 12 o clock

Do you have any triggers on your spreadsheet, if you have other apps script running locally there ?

You do not explain what you are doing, which script you are using, or how you are using it, there may be a better way....

1 Like

Ok leave it. In GSConnected extension, all get data blocks working fine, but set data values are not working

If there is a problem, I need to know so that I can fix it.

Please show what is not working....

image
check this, no data is entered in the sheet, if we try row or column, only row and column inserted, but no data stored


all blocks including add sheet, delete sheet works fine, except set datas and insert blocks

Thanks, I will look into it.

waiting for your reply :heart:

For this one:
image

You should be using SetDataToCell

Does that work ?

yes, it works fine.
But others not working like Append column and set data

Verified all, see the image for the blocks that didn't work.

Can you confirm that you have ShowListsAsJson checked in your Screen1 Designer properties ?
You appear to be using Kodular and this is not set by Default.

Are you adhering to the list setting requirements for each of the extension blocks as shown in the usage blocks ?

For example, you show this:

image

My usage blocks show this:

image

yes, for your reference i tried to take screen, it's a minor mistake.

wait few minutes, as i turn on show list and try again

this is the solution brother, all blocks works fine after turning on the "ShowListsAsJson" in project settings