# \#google-sheets **URL:** https://community.thunkable.com/tag/google-sheets/525.md [Latest](https://community.thunkable.com/latest.md) · [Categories](https://community.thunkable.com/categories.md) · [Tags](https://community.thunkable.com/tags.md) --- ## [Need help creating and updating data](https://community.thunkable.com/t/need-help-creating-and-updating-data/3996253)
**Author:** [@jsrambles](https://community.thunkable.com/u/jsrambles)\ **Replies:** 4\ **Last updated:** [July 16, 2025, 2:56pm UTC](https://community.thunkable.com/t/need-help-creating-and-updating-data/3996253 "2025-07-16T14:56:36Z")
Hello, I am very new to Thunkable and might be overreaching in my excitement to try Thunkable. I started with what I thought was a decently simple project but it has since gotten complicated. I am trying to create a si… --- ## [Check box or switch value in google sheet](https://community.thunkable.com/t/check-box-or-switch-value-in-google-sheet/3848476)
**Author:** [@edricnirmal5vjophu](https://community.thunkable.com/u/edricnirmal5vjophu)\ **Replies:** 0\ **Last updated:** [May 20, 2025, 2:23pm UTC](https://community.thunkable.com/t/check-box-or-switch-value-in-google-sheet/3848476 "2025-05-20T14:23:30Z")
i want a tick or marked value in my google sheet if i slide or tick my checkbox in my form..as u can see in my google sheet it is giving unusual values --- ## [How to search student details by name from Google Sheet in Thunkable?](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460)
**Author:** [@indilipi.info62syhc](https://community.thunkable.com/u/indilipi.info62syhc)\ **Replies:** 2\ **Last updated:** [May 16, 2025, 9:48pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460 "2025-05-16T21:48:58Z")
Hi everyone, I’m creating an app in Thunkable that is connected to a Google Sheet containing student details. I want to implement a search function as follows: The user enters a student’s name in a Text Input (TextInp… --- ## [Data read out](https://community.thunkable.com/t/data-read-out/3813014)
**Author:** [@joelmoser15jl4fh2](https://community.thunkable.com/u/joelmoser15jl4fh2)\ **Replies:** 1\ **Last updated:** [May 12, 2025, 7:28pm UTC](https://community.thunkable.com/t/data-read-out/3813014 "2025-05-12T19:28:55Z")
Hello, this is my first time working with Thunkable and I’m not having a great time with it. I’m only used to a bit of programming and scripting in Powershell. I’m currently trying to read the database for my blocks.… --- ## [Making items in dataviewer list clickable to display more info on another page about chosen item](https://community.thunkable.com/t/making-items-in-dataviewer-list-clickable-to-display-more-info-on-another-page-about-chosen-item/3702196)
**Author:** [@briahna.fo0nq](https://community.thunkable.com/u/briahna.fo0nq)\ **Replies:** 6\ **Last updated:** [April 3, 2025, 12:49am UTC](https://community.thunkable.com/t/making-items-in-dataviewer-list-clickable-to-display-more-info-on-another-page-about-chosen-item/3702196 "2025-04-03T00:49:53Z")
My app lets users view skills they may want to learn, click a skill, and get redirected to a page showing information about the skill, in a similar layout to trade me/Facebook Market place, where you can see more info on… --- ## [\[Solved\] Obtain Row ID without Data Viewer](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989)
**Author:** [@krish05](https://community.thunkable.com/u/krish05)\ **Replies:** 3\ **Last updated:** [April 2, 2025, 11:08pm UTC](https://community.thunkable.com/t/solved-obtain-row-id-without-data-viewer/3694989 "2025-04-02T23:08:31Z")
I’m using an authentication process with Firebase Authentication and Google Sheets. The reason I’m using Google Sheets to obtain a name from the email entered. I want to retrieve the data through row ID, but have no idea… --- ## [How to Refresh data from data source with a label](https://community.thunkable.com/t/how-to-refresh-data-from-data-source-with-a-label/3657714)
**Author:** [@gw14haugheyfraserdd2](https://community.thunkable.com/u/gw14haugheyfraserdd2)\ **Replies:** 1\ **Last updated:** [March 17, 2025, 7:48am UTC](https://community.thunkable.com/t/how-to-refresh-data-from-data-source-with-a-label/3657714 "2025-03-17T07:48:09Z")
I have made a simple app where there is a title at the top of the screen and the user can type in a text and click a button to set that as the title. I want to in future make this more advanced and practical, as I am new… --- ## [Errors in my App (Google Sheets Database)](https://community.thunkable.com/t/errors-in-my-app-google-sheets-database/3523821)
**Author:** [@coder78proj-pro](https://community.thunkable.com/u/coder78proj-pro)\ **Replies:** 10\ **Last updated:** [February 6, 2025, 4:02pm UTC](https://community.thunkable.com/t/errors-in-my-app-google-sheets-database/3523821 "2025-02-06T16:02:21Z")
Hi! I made an app called Vote App. I am facing some database errors. Screenshots: to HOW??? --- ## [How to sort lists of data taken from Google Sheets, and grouped as objects](https://community.thunkable.com/t/how-to-sort-lists-of-data-taken-from-google-sheets-and-grouped-as-objects/3535334)
**Author:** [@grant.mccallum](https://community.thunkable.com/u/grant.mccallum)\ **Replies:** 2\ **Last updated:** [February 4, 2025, 10:13pm UTC](https://community.thunkable.com/t/how-to-sort-lists-of-data-taken-from-google-sheets-and-grouped-as-objects/3535334 "2025-02-04T22:13:51Z")
Hi all. Thanks in advance for your help with this. I have recreated an issue I am facing with my app project here: https://x.thunkable.com/copy/cf38b1d827349d69f0475d5a5c218a4e Task: Using the data in google sheets, ha… --- ## [Wrong tables columns mapping in data source](https://community.thunkable.com/t/wrong-tables-columns-mapping-in-data-source/3506825)
**Author:** [@olteanu.alex.ao25zob](https://community.thunkable.com/u/olteanu.alex.ao25zob)\ **Replies:** 6\ **Last updated:** [January 25, 2025, 4:42am UTC](https://community.thunkable.com/t/wrong-tables-columns-mapping-in-data-source/3506825 "2025-01-25T04:42:43Z")
Hello, Google sheet source: Data Source in Thunkable after second sync: The columns are not the same. Thank you, Alex --- ## [Create Rows Not Working](https://community.thunkable.com/t/create-rows-not-working/3367539)
**Author:** [@mezonieto.diegoku5gi](https://community.thunkable.com/u/mezonieto.diegoku5gi)\ **Replies:** 6\ **Last updated:** [November 25, 2024, 8:50pm UTC](https://community.thunkable.com/t/create-rows-not-working/3367539 "2024-11-25T20:50:36Z")
Hi! I’m not sure what i’m doing wrong, but after clicking the button to send the data (I tried G Sheets and Airtable) it doesn’t do anything, the data is not sent to the database, and it won’t navigate to the next scree… --- ## [Problem with Updating Score Using List Index in Thunkable – Returns NaN](https://community.thunkable.com/t/problem-with-updating-score-using-list-index-in-thunkable-returns-nan/3359172)
**Author:** [@andreas.michalopoulo](https://community.thunkable.com/u/andreas.michalopoulo)\ **Replies:** 5\ **Last updated:** [November 25, 2024, 6:19pm UTC](https://community.thunkable.com/t/problem-with-updating-score-using-list-index-in-thunkable-returns-nan/3359172 "2024-11-25T18:19:53Z")
Hello Thunkable Community, I’m working on an app where users can select countries from a list, and based on their selection, I need to update a score from another list that matches the selected country. However, I’… --- ## [How do you make a signature app?](https://community.thunkable.com/t/how-do-you-make-a-signature-app/3351783)
**Author:** [@terraceaccapp3hc7yk](https://community.thunkable.com/u/terraceaccapp3hc7yk)\ **Replies:** 5\ **Last updated:** [November 20, 2024, 1:25am UTC](https://community.thunkable.com/t/how-do-you-make-a-signature-app/3351783 "2024-11-20T01:25:41Z")
Hi! I’ve been looking around for how to make a signature app and non of the posts I have come across have been solved and I can’t find out how to do this on my own. I’m trying to have it so that a user first submits th… --- ## [There was a problem fetching the data, please check your input and try again](https://community.thunkable.com/t/there-was-a-problem-fetching-the-data-please-check-your-input-and-try-again/3166828)
**Author:** [@tmcakeed7830](https://community.thunkable.com/u/tmcakeed7830)\ **Replies:** 2\ **Last updated:** [October 30, 2024, 7:50pm UTC](https://community.thunkable.com/t/there-was-a-problem-fetching-the-data-please-check-your-input-and-try-again/3166828 "2024-10-30T19:50:43Z")
I have searched this topic. I have deleted the Google sheet and re-created a much simpler one with text only and without picture/public link. I have removed the access and re-added it again in Google and Thunkable. I h… --- ## [Efficient data handling (and a question on design)](https://community.thunkable.com/t/efficient-data-handling-and-a-question-on-design/3188070)
**Author:** [@grinkingr3yr6z](https://community.thunkable.com/u/grinkingr3yr6z)\ **Replies:** 6\ **Last updated:** [October 19, 2024, 1:19am UTC](https://community.thunkable.com/t/efficient-data-handling-and-a-question-on-design/3188070 "2024-10-19T01:19:21Z")
Apologies in advance for the lengthy post - providing as much detail as I can in order to try and help you to help me, without too much back and forth :slight\_smile: Ok, so I’ve been looking over the Thunkable doco, doi… --- ## [Google Drive picture link - what is wrong?](https://community.thunkable.com/t/google-drive-picture-link-what-is-wrong/3206876)
**Author:** [@pavelcxyz](https://community.thunkable.com/u/pavelcxyz)\ **Replies:** 10\ **Last updated:** [September 19, 2024, 3:32pm UTC](https://community.thunkable.com/t/google-drive-picture-link-what-is-wrong/3206876 "2024-09-19T15:32:54Z")
Please May I ask you What’s wrong with my Google Drive links to images? (I tried the link outside Google Drive and it works) --- ## [Google Sheets creating new + offline](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279)
**Author:** [@pavelcxyz](https://community.thunkable.com/u/pavelcxyz)\ **Replies:** 3\ **Last updated:** [September 16, 2024, 10:58pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279 "2024-09-16T22:58:19Z")
Hello Everybody I have Q. questions regarding working with Google Sheets in Thunkable I would like to ask whether the following scenario is possible in Thunkable. I assume some parts are possible, but I would like conf… --- ## [Failing to write to a specific cell in a Google Sheets data source](https://community.thunkable.com/t/failing-to-write-to-a-specific-cell-in-a-google-sheets-data-source/3167652)
**Author:** [@grinkingr3yr6z](https://community.thunkable.com/u/grinkingr3yr6z)\ **Replies:** 5\ **Last updated:** [August 31, 2024, 5:20am UTC](https://community.thunkable.com/t/failing-to-write-to-a-specific-cell-in-a-google-sheets-data-source/3167652 "2024-08-31T05:20:57Z")
Hi team, as per the subject, I have a small project I am working on for myself as a learning exercise (it’s a personal recipes database, and am trying to set it up to find any matches on rows that match a certain string … --- ## [Google sheets row data identified but update does not work](https://community.thunkable.com/t/google-sheets-row-data-identified-but-update-does-not-work/3144909)
**Author:** [@shabi2313kgb](https://community.thunkable.com/u/shabi2313kgb)\ **Replies:** 5\ **Last updated:** [August 21, 2024, 5:59pm UTC](https://community.thunkable.com/t/google-sheets-row-data-identified-but-update-does-not-work/3144909 "2024-08-21T17:59:29Z")
Hi there, iwm new here but great APP! i use google sheets as a DB for a phonebook app. when i click an item in the DataViewer it recognize and present the information, but when i try and update the any field for the r… --- ## [How to get data for an individual user from a google sheet?](https://community.thunkable.com/t/how-to-get-data-for-an-individual-user-from-a-google-sheet/3135139)
**Author:** [@jake-cohen](https://community.thunkable.com/u/jake-cohen)\ **Replies:** 3\ **Last updated:** [August 11, 2024, 2:17am UTC](https://community.thunkable.com/t/how-to-get-data-for-an-individual-user-from-a-google-sheet/3135139 "2024-08-11T02:17:57Z")
Hi, first of all sorry if this title is badly worded I don’t know how to fully explain my issue. Now - I am making an app for my school and when the user signs up (they need to enter name, email, password, phone number,… --- ## [Error saving photo to Cloudinary](https://community.thunkable.com/t/error-saving-photo-to-cloudinary/3128437)
**Author:** [@a.towlerc9gdh4](https://community.thunkable.com/u/a.towlerc9gdh4)\ **Replies:** 1\ **Last updated:** [August 6, 2024, 9:55am UTC](https://community.thunkable.com/t/error-saving-photo-to-cloudinary/3128437 "2024-08-06T09:55:09Z")
Hi there, I’m using the following blocks to save a photo from the camera in cloudinary, and the link to the photo in a google sheet. These blocks were working perfectly for the last two weeks, but have stopped worki… --- ## [Extract Data and Update](https://community.thunkable.com/t/extract-data-and-update/3088677)
**Author:** [@IJohnKennady](https://community.thunkable.com/u/IJohnKennady)\ **Replies:** 5\ **Last updated:** [July 18, 2024, 3:40pm UTC](https://community.thunkable.com/t/extract-data-and-update/3088677 "2024-07-18T15:40:37Z")
i have data like this… in that data have 2 admin users. ( User 1: 123@te.com and User2: 321@te.com) when the User 1 will login it will show how many data’s match User 1 id and this my code block after when i … --- ## [Problem with value fetching ; Google Sheets](https://community.thunkable.com/t/problem-with-value-fetching-google-sheets/3091240)
**Author:** [@msd.revoltboqf](https://community.thunkable.com/u/msd.revoltboqf)\ **Replies:** 1\ **Last updated:** [July 9, 2024, 2:12am UTC](https://community.thunkable.com/t/problem-with-value-fetching-google-sheets/3091240 "2024-07-09T02:12:42Z")
Hello! I’m currently making an app on Thunkable and i’ve run into a problem. I’m trying to make a button where when i click it, the button’s text is updated to a value fetched from Google Sheets and then returns back to… --- ## [Need Help Arranging Google Sheets Data From A Web API Into Local Table](https://community.thunkable.com/t/need-help-arranging-google-sheets-data-from-a-web-api-into-local-table/3029494)
**Author:** [@8bitretrofishep](https://community.thunkable.com/u/8bitretrofishep)\ **Replies:** 10\ **Last updated:** [June 3, 2024, 2:03pm UTC](https://community.thunkable.com/t/need-help-arranging-google-sheets-data-from-a-web-api-into-local-table/3029494 "2024-06-03T14:03:13Z")
Hi all, Edit: I am now looking for help with arranging data from a Google Sheets via a WebAPI. I’ve managed to bring the data in but not sure on the next steps to arrange and make sense of it. Original: I’m currently t… --- ## [Iterate through two google sheets columns at once?](https://community.thunkable.com/t/iterate-through-two-google-sheets-columns-at-once/2992756)
**Author:** [@anxirileyrhsuqv](https://community.thunkable.com/u/anxirileyrhsuqv)\ **Replies:** 3\ **Last updated:** [May 9, 2024, 1:58am UTC](https://community.thunkable.com/t/iterate-through-two-google-sheets-columns-at-once/2992756 "2024-05-09T01:58:20Z")
i have a google sheet that is displaying this data: i am trying to get the “bad”, “good”, etc labels to display from the row the student id and class hour is in. for example, the specific student id shown has a tota… --- ## [(Solved) How can i turn these functions into list blocks?](https://community.thunkable.com/t/solved-how-can-i-turn-these-functions-into-list-blocks/2880182)
**Author:** [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)\ **Replies:** 16\ **Last updated:** [March 10, 2024, 11:56pm UTC](https://community.thunkable.com/t/solved-how-can-i-turn-these-functions-into-list-blocks/2880182 "2024-03-10T23:56:08Z")
this is the pivot table i am pulling data from: what i have here are these functions that search for the class code and return the “Student Mood Count” from the “Student Mood 2” column: (for example, if i go into the… --- ## [\[SOLVED 3/4/24 6:03 AM EDT\] Extremely slow process retrieving data](https://community.thunkable.com/t/solved-3-4-24-6-03-am-edt-extremely-slow-process-retrieving-data/2861275)
**Author:** [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)\ **Replies:** 34\ **Last updated:** [March 6, 2024, 10:40am UTC](https://community.thunkable.com/t/solved-3-4-24-6-03-am-edt-extremely-slow-process-retrieving-data/2861275 "2024-03-06T10:40:30Z")
currently, in a page i have a section to show a chart from quickchart, and the data on the chart is meant to show data points from a google sheet. below are all of the blocks used: the problem is that the p… --- ## [Variables don't set?](https://community.thunkable.com/t/variables-dont-set/2871591)
**Author:** [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)\ **Replies:** 1\ **Last updated:** [March 4, 2024, 12:31am UTC](https://community.thunkable.com/t/variables-dont-set/2871591 "2024-03-04T00:31:56Z")
there’s more information about my issue in this post, i just thought it would have been better to create a separate topic for it: Extremely slow process retrieving data - #13 by wulfy\_starr to summarize, the debugging l… --- ## [Returning a Value](https://community.thunkable.com/t/returning-a-value/2858476)
**Author:** [@briseno1984q](https://community.thunkable.com/u/briseno1984q)\ **Replies:** 1\ **Last updated:** [February 27, 2024, 12:39am UTC](https://community.thunkable.com/t/returning-a-value/2858476 "2024-02-27T00:39:11Z")
Hello Everyone… first post here. I am making a “Sign in, Sign Out” Hall Pass App. Students enter their ID Number ----\> Google Sheet will record: Name, Time, Teacher, Location etc. I am having issues returning a studen… --- ## [App does not correspond to google sheets update](https://community.thunkable.com/t/app-does-not-correspond-to-google-sheets-update/2826517)
**Author:** [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)\ **Replies:** 1\ **Last updated:** [February 8, 2024, 11:14pm UTC](https://community.thunkable.com/t/app-does-not-correspond-to-google-sheets-update/2826517 "2024-02-08T23:14:05Z")
i basically have a similar issue to this post here are the blocks that are used to update the google sheet values i am aware that the “get value” block has a bug where it gets cached data. so in this case, how wou… [Next page](https://community.thunkable.com/tag/google-sheets/525.md?match_all_tags=true&page=1&tags%5B%5D=google-sheets)