# Google Sheets Explained related to Glideapps

**URL:** <https://community.glideapps.com/t/google-sheets-explained-related-to-glideapps/40152>\
**Category:** Ask for Help\
**Created:** [March 28, 2022, 2:03am UTC](https://community.glideapps.com/t/google-sheets-explained-related-to-glideapps/40152 "2022-03-28T02:03:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jacques\_Julmice](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacques_julmice/32/32728_2.png) [@Jacques\_Julmice](https://community.glideapps.com/u/Jacques_Julmice)\
**Post date:** [March 28, 2022, 2:03am UTC](https://community.glideapps.com/t/google-sheets-explained-related-to-glideapps/40152/1 "2022-03-28T02:03:13Z")

</div>

I’m having a hard time understanding how to structure my google sheets to make it work effectively with the app. I manage to get some things done by fumbling around and by trial and error. Please point me to some articles or videos that explain the structure of Google sheets and the relations between the different columns and the connections between a column in one sheet to a different column in another sheet

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 28, 2022, 2:11am UTC](https://community.glideapps.com/t/google-sheets-explained-related-to-glideapps/40152/2 "2022-03-28T02:11:29Z")

</div>

This would be a good place to start:

> **[Introduction to Data Editor](https://docs.glideapps.com/all/product/data-editor/introduction#data-structure)**
>
> Learn the basics of Glide's Data Editor

In general:

- Try to keep your data structure flat. Just simple columns and rows. Avoid things like merged rows/columns, pivot tables, and column or row grouping.
- Keep all related data together in a single sheet/table
- Avoid un-necessary duplication of data
- If you’ve ever worked with Relational Databases, then many of the same conventions that you apply to database design should also be applied to Glide apps.

---

<div class="post-metadata">

**Author:** ![Jacques\_Julmice](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacques_julmice/32/32728_2.png) [@Jacques\_Julmice](https://community.glideapps.com/u/Jacques_Julmice)\
**Post date:** [March 28, 2022, 2:23am UTC](https://community.glideapps.com/t/google-sheets-explained-related-to-glideapps/40152/3 "2022-03-28T02:23:53Z")

</div>

@Darren_Murphy Thank you so much; truly appreciated!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 29, 2022, 2:24am UTC](https://community.glideapps.com/t/google-sheets-explained-related-to-glideapps/40152/4 "2022-03-29T02:24:52Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.