# Sending info from Glide to Google sheets

**URL:** https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959
**Category:** Ask for Help
**Created:** [February 14, 2023, 9:28pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959 "2023-02-14T21:28:04Z")
**Posts on this page:** 17
**Page:** 1

<div class="post-metadata">

### Author: ![daniel30aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel30aguilar/32/54343_2.png) [@daniel30aguilar](https://community.glideapps.com/u/daniel30aguilar)
#### Post date: [February 14, 2023, 9:28pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/1 "2023-02-14T21:28:05Z")

</div>

Hello community,

Sending info from Glide to Google sheets

I created a WEB/APP from google sheets synced to Glide, and so far; it looked good until yesterday. In my google sheets:  
-One row contains information per user

- All columns are User Specific; that information should be visible only to the user, but if I create a new column in Glide (user-specific), that column won’t be created y Google Sheets.

The point here, I need to send the info the user is entering in Glide back to Google Sheets because, in Google Sheets, I need to run Autocrat to populate that info in some documents.

Dear @Darren_Murphy I saw a case similar to this in the community, I saw you have a clear Idea of a case similar to this but it was unclear for me how to send info from Glide to Google Sheets. If you have some feedback about this, it would be great.

 ![Sending info to google sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de224d3f27a26dd2442474cd70ce40d4b22d16d7.png)

Glide

 ![2023-02-14 15_46_09-Window - Glide View - User Data Entry](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f774cfdcb6d86c6a4b427fe2f94860565775ea9a.png)

Autocrat in Google Sheets

 ![Sending info to google sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de224d3f27a26dd2442474cd70ce40d4b22d16d7.png)

Glide Imputs

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 14, 2023, 11:43pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/2 "2023-02-14T23:43:56Z")

</div>

> [@daniel30aguilar](#):
>
> All columns are User Specific; that information should be visible only to the user

I’m not sure I understand this part. Wouldn’t you want to have a row per user instead?

What does Autocrat do in this app?

---

<div class="post-metadata">

### Author: ![daniel30aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel30aguilar/32/54343_2.png) [@daniel30aguilar](https://community.glideapps.com/u/daniel30aguilar)
#### Post date: [February 15, 2023, 12:05am UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/3 "2023-02-15T00:05:13Z")

</div>

> [@ThinhDinh](#):
>
> I’m not sure I understand this part. Wouldn’t you want to have a row per user instead?

Right now it is like this, one row per user, and Columns are User Specific

> [@ThinhDinh](#):
>
> What does Autocrat do in this app?

It takes data from Google Sheets and migrates some Google Docs (creates some contracts) for each user.

---

<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: [February 15, 2023, 1:16am UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/4 "2023-02-15T01:16:22Z")

</div>

> [@daniel30aguilar](#):
>
> Right now it is like this, one row per user, and Columns are User Specific

User Specific columns only exist in Glide.  
If you need that data in your Google Sheet, then you need to change those to non-user specific.

If the data needs to be secure in the App (ie. users only see their own data), then you should use Row Owners.

---

<div class="post-metadata">

### Author: ![daniel30aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel30aguilar/32/54343_2.png) [@daniel30aguilar](https://community.glideapps.com/u/daniel30aguilar)
#### Post date: [February 15, 2023, 2:13am UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/5 "2023-02-15T02:13:06Z")

</div>

Hello @Darren_Murphy, thank you for your reply. It seems it is not working since I switched to view as anyone or my user; the data is not visible.

Before Row Owner

 ![2023-02-14 21_00_11-Daniel's Page · Glide 5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3bcde7fe125c758a1257f651d60dd92ceca0140d.png)

Row owner

 ![Row Owner](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/333855eb9b3923f2a79e4d2fbb08dd41b6e1944d.png)

Result 1

 ![2023-02-14 20_56_42-Daniel's Page · Glide 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27810e60793abefc6e60784f5587da4025f0e73c.png)

Result 2

 ![2023-02-14 21_07_56-Daniel's Page · Glide 5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/6/c60eb35fc039c5bf83f0b20b226c9a753d3b5c2a.png)

---

<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: [February 15, 2023, 2:19am UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/6 "2023-02-15T02:19:47Z")

</div>

Two problems with the below:

 ![CleanShot 2023-02-15 at 10.17.02@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37284c7c37025d4ebe09b9b9b92f6909015bbdb8.png)

1. You’re using the RowID column as a Row Owner column. That won’t work. You need to have a column that contains the users email address, and make that the Row Owner column.
2. You still have at least one User Specific column in that table.

---

<div class="post-metadata">

### Author: ![daniel30aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel30aguilar/32/54343_2.png) [@daniel30aguilar](https://community.glideapps.com/u/daniel30aguilar)
#### Post date: [February 15, 2023, 12:41pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/7 "2023-02-15T12:41:00Z")

</div>

> [@Darren\_Murphy](#):
>
> You’re using the RowID column as a Row Owner column. That won’t work. You need to have a column that contains the user’s email address and make that the Row Owner column.

Hello @Darren_Murphy, you are a genius; it worked. But now I have an issue; my question is, when I put view as anyone, I should be able to see the input spaces in blank ready to fill them out, but I can not see the input spaces, and neither the label.

> [@Darren\_Murphy](#):
>
> You still have at least one User Specific column in that table.

What do you mean by this? After your previous solution, I do not need User Specific columns; I need to solve the problem of the blank inputs and labels.

Row Owner  
 ![Case 15.02.2023](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/182474df054d4ba111cbe2f051451293aed3212c.png)

My view

 ![15.02.2023 Case 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b06cda5f60c7b5f472c18934f026852c815d041a.png)

Anyone View

 ![Case 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40cd2d4bf8ca664d62056a58cb0026b45b364d4c.png)

---

<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: [February 15, 2023, 12:45pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/8 "2023-02-15T12:45:35Z")

</div>

> [@daniel30aguilar](#):
>
> > [@Darren\_Murphy](#):
> >
> > You still have at least one User Specific column in that table.
> 
> What do you mean by this?

Here…

 ![CleanShot 2023-02-15 at 20.43.25@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/4449654a36a9922b236a2fbed73e21760f25facf.png)

That little purple A tells me that column is user specific.  
You should not be using user specific columns, so you need to replace that column and any other columns in that table that are also user specific.

---

<div class="post-metadata">

### Author: ![daniel30aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel30aguilar/32/54343_2.png) [@daniel30aguilar](https://community.glideapps.com/u/daniel30aguilar)
#### Post date: [February 15, 2023, 1:11pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/9 "2023-02-15T13:11:11Z")

</div>

> [@Darren\_Murphy](#):
>
> You should not be using user-specific columns, so you need to replace that column and any other columns in that table that are also user-specific.

@Darren_Murphy, I do not have any User Specific Columns now, but I wanted to know the explanation,

- If I have them, what is affecting me?
- If I do not have them what is the effect on my app?  
I would appreciate your answer and knowledge. Thank you!

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 15, 2023, 1:31pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/10 "2023-02-15T13:31:12Z")

</div>

You should only use user-specific columns when you want multiple users to act on the same cell (same row, same column) in the database, and the data tied with that cell should be specific to the user.

Example: A boolean column that marks the task as completed or not, and multiple users can do that same task.

---

<div class="post-metadata">

### Author: ![daniel30aguilar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel30aguilar/32/54343_2.png) [@daniel30aguilar](https://community.glideapps.com/u/daniel30aguilar)
#### Post date: [February 15, 2023, 1:35pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/11 "2023-02-15T13:35:12Z")

</div>

Thank you @ThinhDinh

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 15, 2023, 10:24pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/12 "2023-02-15T22:24:30Z")

</div>

> [@Darren\_Murphy](#):
>
> That little purple A

Wait…that’s purple?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 15, 2023, 10:55pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/13 "2023-02-15T22:55:52Z")

</div>

I’m coming up with Royal Blue.

> **[Royal Blue ( similar ) Color | 4c58e5 information | Hsl | Rgb | Pantone](https://icolorpalette.com/color/4c58e5)**
>
> Color space information Royal Blue ( similar ) Color | 4c58e5. Similar Pantone Color name Information, Color Schemes, Light / Darkshades, Tones, Similar Colors , Preview the color and download Photoshop swatch and solid color background image

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 15, 2023, 11:32pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/14 "2023-02-15T23:32:20Z")

</div>

I mean, I’m legit partially colorblind, but glad I wasn’t mistaken all this time! 😅

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 15, 2023, 11:37pm UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/15 "2023-02-15T23:37:30Z")

</div>

Hehe, I can probably call it either way. I see purple and blue.

---

<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: [February 16, 2023, 2:33am UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/16 "2023-02-16T02:33:23Z")

</div>

haha… well, “purpley-blue” 🤪

---

<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: [February 17, 2023, 2:33am UTC](https://community.glideapps.com/t/sending-info-from-glide-to-google-sheets/57959/17 "2023-02-17T02:33:29Z")

</div>

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