Does anybody know if it’s possible to link cells from a Glide table to cells in a Google sheet or Google doc?
I Would like to report some data from my Glide table dynamically into a sheet or doc without having to do manual updates. Is this possible?
You can use a set column action.
Thanks @Jeff_Hager I will have to dig into how that works. I appreciate the guidance on where to look.
1 Like
As long as you have the google sheet table in your project and you have a way to link each Glide table row to the corresponding row in the google sheet through a relation, you should be able to set a column value through that relation, which would update the columns in the google sheet.
Hey @Jeff_Hager sorry, you just said some stuff I don’t understand. My project is built on “tables” rather than sheets. Now you are talking about having a Google sheet table in my project, which I don’t understand.
What am I missing?
If you add your Google sheet to your project, you can directly update values in the Google sheet, or link it with your Glide table through a relation and set values like I described in my previous post.
1 Like
Who knew? I thought it was a binary choice between tables and sheets. The more I learn, the more I realize the power of Glide.
Thanks very much for this little tidbit. I will give it a shot, and likely be back when I make the next mistake.
If you really wanted, and your plan allowed it, you could have Glide Tables, Glide Big Tables, Google Sheets, Airtable, Excel, and any of several third party SQL databases all in the same app. You are not locked into one choice.
But do note that you can only connect one Google worksheet at a time, so all of the sheet tabs you need would have to be within the same worksheet.
Okay, this seems like it should be simple. I want to connect this single row in my Table to a blank Google sheet I created especially for this purpose just to see if I can make it work.
You talked about creating a relation, but I don’t know how to create a relation between a table row and a sheet row.
It’s no different than creating a relation between two glide tables or between two google sheet tables. At the end of the day, a table is a table regardless of it’s source.
Creating a relation just requires a matching value in both tables. That could be some sort of ID or even a simple character like ‘X’ in both tables. Relations just look for a match.
Alternatively, if you are always linking to a single row in the Google sheet table, you could instead create a Single Value → Whole Row column in your glide table, which is like a relation, but without the need to create a matching value.
With that said I’m noticing a couple things in your screenshot.
- One is that I don’t see any Google sheets tables listed. I only see glide tables. I can tell by the color of the table icons.
- The other thing is that you mentioned a blank google sheet table. Blank tables are not synced and probably why you don’t see any Google sheet tables listed at all. You’re going to need some headings at the very least, and probably one data row with at least some data in it. Then resync the google sheet and it should appear as a table in the data editor.
If you are going to update data in that Google sheet via a set column action, you’re going to need a table and row that can be updated.
2 Likes
Hey @Jeff_Hager I am really sorry to be so dense, but I just don’t get it. I’m trying to do something that seems so simple.
I wish to copy the single row from the TRACKER table into the Google sheet so I can use it dynamically in other places. It’s very simple to link cells in Google sheets, but I’m not understanding the Relations idea.
I placed a row of dummy data in the sheet to make sure it would sync.
Sorry to be such an idiot.
Let me ask this to make sure we are on the same page. Do you want a direct one-to-one sync between tables or would the google sheet accumulate multiple rows?
I ask because if it’s just a one to one sync you may be better off changing your app to directly use the google sheet table instead of the Tracker table. No use creating exact duplicates of the same table when the google sheet can serve the same purpose as the tracker table.
If you are using the google sheet as a sort of running history log, then a button with an Add Row action could be used to keep adding rows to the google sheet containing current data from the Tracker table at the time the row is added.
If your intention was to only take a select few column values from the Tracker table and copy them to the google sheet, then a button with a Set Column action could be used to update values through a ‘Single Relation’ or a ‘Single Value → Whole Row’ column in the tracker table. I’m starting to think the Relation or Single Value is not the best option for you, so I won’t go into detail to avoid confusion unless necessary.
2 Likes
@Jeff_Hager I appreciate all your help. At this point, this might be more trouble than it’s worth, but now I am just insanely curious.
I understand what you said about creating a single row in my Google sheet and using that instead of the row in my table. So I did that.
However, it seems that computed columns and rollup columns don’t show up when I sync Glide with the Google sheet – screenshots attached.
The whole point was being able to copy cells from the Google sheet, so I’m in the same spot.
Is there a way to get computed columns and rollup columns to show when I sync?
Computed columns do not store values. They are computed directly on the end users device as needed. Glide does not and has never synced computed columns to a Google sheet.
You have two options. Either duplicate the computed logic in the Google sheet itself, or go back to using a set column action like I initially suggested to write the computed columns to basic columns in that Google sheet.
1 Like