[Solved] Data Viewer and Google Sheets

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

screenshot1 screenshot2

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

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.

3 Likes

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!

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

1 Like

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.

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?

1 Like

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.

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

1 Like

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

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?

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

Thanks.

please check this :tada: 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.

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

So what happened when you did this?

1 Like

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

1 Like

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

1 Like

personal email

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,

Deleting data sources is working well for me.

2 Likes

Thanks @rojroj101s


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

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!

2 Likes

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:

We also have new and improved docs to go with this:

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

3 Likes