# Fetch User's Data From Spreadsheet

**URL:** https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885
**Category:** Questions about Thunkable X
**Created:** [July 31, 2020, 9:22am UTC](https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885 "2020-07-31T09:22:21Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![anchor.sudiptau77](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@anchor.sudiptau77](https://community.thunkable.com/u/anchor.sudiptau77)
#### Post date: [July 31, 2020, 9:22am UTC](https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885/1 "2020-07-31T09:22:21Z")

</div>

Hi,  
I’m beginner here. I have app with auto login option using device ID.

I want to display user’s data on screen initialisation when device ID matches with spreadsheet data. Tried with different blocks but didn’t get the desired result. Can anyone help me with how to set the blocks?

 ![20200731_144741](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/2/a259c28ed5c0b8ff5b5dcf6f04a1647355ea1146.jpeg) ![20200731_144703](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/2/02cec2334a070bd0d0ea17824c5cc8a1c6777592.jpeg)

---

<div class="post-metadata">

### Author: ![StartShare](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/startshare/32/75883_2.png) [@StartShare](https://community.thunkable.com/u/StartShare)
#### Post date: [July 31, 2020, 9:26am UTC](https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885/2 "2020-07-31T09:26:18Z")

</div>

Use firebase for this, it’s more optimized for storing user profiles than Airtable. Airtable is better for simpler things like elements for a list viewer and i love it, but I must caution you that you should use firebase for account data.

-Ethan at SwagShare, LLC.

---

<div class="post-metadata">

### Author: ![anchor.sudiptau77](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@anchor.sudiptau77](https://community.thunkable.com/u/anchor.sudiptau77)
#### Post date: [July 31, 2020, 9:28am UTC](https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885/3 "2020-07-31T09:28:08Z")

</div>

Ok, I’ll shift to Firebase. But is it possible to get the data from Spreadsheet?

---

<div class="post-metadata">

### Author: ![StartShare](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/startshare/32/75883_2.png) [@StartShare](https://community.thunkable.com/u/StartShare)
#### Post date: [July 31, 2020, 9:38am UTC](https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885/4 "2020-07-31T09:38:56Z")

</div>

Yes, but it’s not something like Firebase that’s gonna allow you to quickly manipulate data entries (like say editing a profile), its better for storing and accessing collections of data that app code or software automation tools tie together into meaningful information. Airtable is better at storing common user content like posts, and Firebase has the security rules necessary to make it useful for storing user profile data. For example, user data can be stored in firebase, organized by a path related like “Users Database\>UserID\>content”, and have airtable host user posts. Make sure each record in airtable is organized by an automumbered ID, put links of those to your firebase under a Content\>Post IDs path (sepatated in commas, e.g. “2, 1”). Then finally, make each airtable record have a field for “UserID” and you’ll be able to link posts back to who actually posted it.

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:26pm UTC](https://community.thunkable.com/t/fetch-users-data-from-spreadsheet/712885/5 "2024-11-08T12:26:55Z")

</div>


