Hi all,
I am currently working toward connecting a Google Sheet using the Web API component. I haven’t finished yet, but I did successfully get the token.
https://x.thunkable.com/copy/f5a3f633ceeb93af16a21e44a67c1f77
(You’ll have to supply the RefreshToken, ClientID, and ClientSecret.)
I hope this helps someone! (@samclever ?)
Brian
Ahhhh… I have created 3 different credentials in the Google API dashboard, but I can’t seem to authorise.
No matter which credentials I use, I get error 401. The JSON result is:
{ "error" : "invalid_client", "error_description" : "Unauthorized" }
Any suggestions?
https://x.thunkable.com/projects/5dd4deea2acb250a941b289b/9f0a6441-92b5-4782-b7f8-7535fbe9417d/designer
(forgive its ugliness)
@cttricks has done quite a bit with Google Sheets, perhaps he can give us a few pointers?
Thanks @domhnallohanlon,
Using the project above (with no modifications) I finally was successful in retrieving a Google Sheet using the suggestions in this StackOverflow post
Next step… appending a row!
Sweet, thanks for the update Brian.
Ok to mark this question as Solved so?
Yes, you can mark it as solved, but I didn’t really have a question. I just wanted to make this available to the community.
Btw… I successfully appended a row of data to a Google Sheet! Once I have it a little more fine-tuned, I’ll share an updated project here.
I had it working beautifully, but once again my project has been corrupted and now is unusable. Copies are unusable. I can’t copy blocks from one sheet to another within the same project. This is about the 10th time this has happened. Every time I start making significant process, the project is mysteriously corrupted and recovery is impossible.
I first tried Thunkable in late 2015 and I recently came back to see how the product has matured, but I think I’ll wait at least another year or two, unless I can help the project by working on the code.
I’ll wait patiently and come back when:
Brian
@domhnallohanlon, @joannietw, @jane
Is there any way to recover from these “internal error” messages? Or are my projects permanently borked? I can’t keep spending 50 hours on projects only to have them become unusable for no apparent reason.
I would love to contribute to the community, but right now I feel like the time I am spending here is a waste of my life since neither I nor anyone else can benefit from reusing my blocks.
Obrigado!
Brian
Fyi… I deleted and rebuilt the offending screen. (Fortunately, I was able to get screenshots of all the blocks.)
However, it was when I added [break out of loop] back into a function that it crashed again. This time, I was able to delete that command and refresh the screen and it seems like it’s okay.
So there may be a bug with exiting loops.
Here is the working project…
https://x.thunkable.com/copy/8f9209b8af7ecad132a27d0eb4253bc3
To use it you will need to go to https://console.developers.google.com/apis/credentials and create both an API key and a OAuth 2.0 client ID which is authorized for a web application. You’ll also need a spreadsheet ID and a sheet name (the default is “Sheet1”).
To be honest, I don’t remember which steps were important versus those which led me in the wrong direction since there is more bad advice out there than good advice.
If anyone out there wants to figure out the minimum number of steps and create documentation, I’m sure a lot of people would appreciate it.
really solid here!
Here’s a fun example of integrating Oauth with our apps here! This uses firebase as a backend to handle background management. Free to run. Not no code but only about 100-150 lines of code max. MAX.
https://x.thunkable.com/projectPage/619eee4648281c0011b2d5bd
This means it’s not a standalone app. That said, most apps arent standalone and have some kind of backend service/server. In this case, it’s a backend server.
