[Solved] Data Viewer and Google Sheets

[saramdl.gaunde021]

im having same trouble here. Local DB & Airtable seem so fine but only Google Spreadsheet doesnt work.

i was selected for beta tester a few days ago. Google sheets didnt work. so i wait. but still same. please help

[tatiang]

This is exciting but I’m still finding the data source interface to be so buggy. I have like 20 data sources from the beta testing and although there’s a way to create new sources, there is no way to remove sources. There should be.

And when I create a new source, it loops me through the dialog boxes multiple times so it’s hard to tell when I’ve completed any of the steps. I’ll post a video when I get a chance.

I’m trying to add Google Sheets and reference data from them.

[sr3]

I still can’t use Google Sheets with the Data Viewer. I can get the desired sheet into the Data Source field, but from there, the binding fields tell me to select a data source. I try again and again, and I get the same results. I’ve deleted the data sources from the app in progress and put them back in with no different result. I can’t remove the data sources from the system because the data sources tab on my projects page gives me a blank browser screen. NEED HELP please!

[jared]

what kind of google account are you using for that? a school or work account? or a free account?

[sr3]

I didn’t realize there were different kinds of accounts. I suppose it’s a free account: the same account I use to sign in to Thunkable.

[jared]

I have had issues using my school account in the past. I use my work account though with no problem.

Have you performed a hard refresh recently?

[sr3]

I cleared the cache, installed a newer version of Chrome, shut down Chrome and restarted my computer. I still get the same thing:

The Binding fields are the same. The My Data Sources tab on the Projects page still gives me a white screen. I get the same results in Chrome and Edge browsers.

[jared]

I have reported this on github here. please add any relevant details or a relevant project link

Clicking on the "Data Sources" tab causes white screen

Hi @sr3, @uliana.bruno & @eoinparkinson. If your issue is the same as the one we identified for @jonathanvalgarlh4ow, we should be able to fix it for you. We just need to remove the corrupted data sources from your account. Do we have permission to do so? We also have a fix for this which should be coming out shortly. It will notifiy you that your data source(s) are corrupt and allow you to delete them yourself. Sorry for the inconvenience!

[saramdl.gaunde021]

unable to sync, unable to view data, no update at all.

[domhnallohanlon]

Hey @saramdl.gaunde021 - it’s a little difficult to tell from the context of your message.

Are you having an issue with Google Docs? or are you referring to something else?

@jared

what kind of google account are you using for that? a school or work account? or a free account?

Are you using Thunkable with a gmail.com email or do you use a work/school email address?

Thanks.

[saramdl.gaunde021]

please check this Latest Thunkable ✕ Release; NEW COMPONENTS Data Viewer List and Data Viewer Grid! 2020-05-05

im using google free account. and only Google spreadsheet doesn’t work (Airtable and Local DB work fine)

as you can see in screenshot, there are columns and values in spreadsheet. but in Blocks @ Thunkable it doenst seem recognize the column.

[domhnallohanlon]

That’s what I was assuming - but thanks for clarifying.

So what happened when you did this?

@paulmw

@saramdl.gaunde021 go to https://x.thunkable.com/projects Click on the “My Data Sources” tab, then click the “Sync with Source” icon for your data source.

[rojroj101s]

I have the same problem as sr3 with google sheets . cant choose a sheet… no options.

[domhnallohanlon]

Thanks @rojroj101s - can you also provide the same info that we asked for above please:

@jared

what kind of google account are you using for that? a school or work account?

[rojroj101s]

personal email

[rollke]

Same for me. Personal google account. Cannot create data source with google sheets.
And all former data sources are still listed, even when I deleted them. That brings confusion with duplicate names,

[jared]

Deleting data sources is working well for me.

[domhnallohanlon]

@rojroj101s

personal

Thanks @rojroj101s

---

@rollke

And all former data sources are still listed, even when I deleted them.

Hey when you go to your Data Sources tab? Can you remove data sources manually?

[sr3]

It took a while, but it’s working now with my Google Sheets. I deleted the data sources I had and created a brand new one. Then the last step before it started working was deleting the Data Viewer List from the app and putting in a new one. Once I did that, the data source linked up like it was meant to do. Thanks!

[domhnallohanlon]

Thanks everyone who has helped us make improvements to this component over the past few weeks.

We’ve just started a new playlist over on YouTube specifically for working the the Data Viewer. Take a look at the clip below to see how to connect to Google Sheets and import your data:

Turn any Google Sheet into a Mobile App

We also have new and improved docs to go with this:
https://docs.thunkable.com/data-viewers

cc: @rollke @rojroj101s @ubimidia @1604796tj @doctorsof @actech @ptptmailj9epqr @simpsonja.scabqzb5 @neuheisser @sr3 @saramdl.gaunde021 @tatiang @jared @Steven