# Accessing google sheets relational/lookup columns outside of glide
**URL:** https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521
**Category:** Ask for Help
**Created:** [January 21, 2022, 6:30pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521 "2022-01-21T18:30:47Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@crixlet](https://community.glideapps.com/u/crixlet)
#### Post date: [January 21, 2022, 6:30pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/1 "2022-01-21T18:30:47Z")
I have an app that uses google sheets as the main database, but each sheet also has some glide fields for lookups, etc.
I would love to be able to interact/use the data outside of Glide on an ongoing basis. Is there a way to sync the Glide fields (relational data, lookup values, or rollups) with another source? Does an API endpoint exist to access this data? I’m not looking for export, but more of an ongoing sync or way to get this data outside of Glide.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [January 21, 2022, 7:10pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/2 "2022-01-21T19:10:35Z")
Hola,
do you want to read the Glide’s data from your Google Sheets via API? As far I know, only the customers with an Enterprise plan can do it:
> **[Enterprise • Glide](https://www.glideapps.com/enterprise)**
>
> For larger businesses with Enterprise requirements.
Bye
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [January 21, 2022, 7:15pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/3 "2022-01-21T19:15:49Z")
There’s no great way to do this. If you NEED the data outside of Glide, it’s probably best to build it in the sheet redundantly.
---
### Author:  [@crixlet](https://community.glideapps.com/u/crixlet)
#### Post date: [January 21, 2022, 7:19pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/4 "2022-01-21T19:19:24Z")
Ah, ok. Yeah I’d like to read data outside of Glide, via API or some other method
---
### Author:  [@crixlet](https://community.glideapps.com/u/crixlet)
#### Post date: [January 21, 2022, 7:20pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/5 "2022-01-21T19:20:57Z")
Thanks @Robert_Petitto. Though if I’m not mistaken, I can’t really do that redundantly with lookup and relational fields?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 21, 2022, 7:36pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/6 "2022-01-21T19:36:38Z")
You would probably have to add an action somewhere that takes those glide fields and writes thembasic columns whenever you interact with that row in the app.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [January 21, 2022, 7:43pm UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/7 "2022-01-21T19:43:04Z")
You’d need to use spreadsheet formulas…vlookups and whatnot
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 22, 2022, 2:51am UTC](https://community.glideapps.com/t/accessing-google-sheets-relational-lookup-columns-outside-of-glide/37521/8 "2022-01-22T02:51:00Z")
> [@crixlet](#):
>
> I would love to be able to interact/use the data outside of Glide on an ongoing basis. Is there a way to sync the Glide fields (relational data, lookup values, or rollups) with another source?
I have no idea what your use case is for the data outside of Glide, so this suggestion could be way off base. But… have you investigated the option of doing whatever you plan to do with the exported data inside of Glide? If you are new to Glide, I can almost guarantee you that Glide is way more powerful than you think it is when it comes to manipulating and presenting data.