The new spreadsheet update on AI2 doesn't work for me

[Stanley]

Hello buddies,

I have a problem with interacting with my google.sheet, I am using the clearRange block and just trying to make it interact (no advanced code)

I have inserted my SpreadsheetID

Fixed Credentials + Json key

Any suggestions?

[ChrisWard]

Hello Stanley

Unfortunately it's a known bug. Expected to be fixed in the next incremental release.

[Stanley]

Oh well, that explains a lot. Do you know when the release date is? Is there anywere to read about the release?

Thank you

[ChrisWard]

Sorry Stanley, we don't know, but it could be a fix release just for this issue.

[TIMAI2]

In the meantime you could use WriteRange...

[Stanley]

Oh, thank you. Ill try that!

[ABG]

Has no one mentioned that the web view reload needs to be moved to the event for completion of the range clear?

[ABG]

@ChrisWard

Unfortunately it's a known bug

Link, please?
I must have missed that.

[TIMAI2]

@ABG

Link, please?

Google Sheets call back issue

Can confirm the event does not appear to be firing, the method (clearing the range does work) [image] On pressing Button 2, the range is cleared on the spreadsheet, but the label is not written out with "Cleared Range".

You responded to that topic (it must be getting worse ABG )

[ABG]

Thank you.

I added the link to the Google Sheets FAQ at

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - TimAI2 Google Sheets Create/Read/Update/Delete(CRUD…

[ChrisWard]

@Stanley

Oh well, that explains a lot. Do you know when the release date is?

We have merged a fix for this issue. It should go out with our next release.