# Scrambled data when adding data to Google Sheet

**URL:** <https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999>\
**Category:** Ask for Help\
**Created:** [July 18, 2024, 3:52pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999 "2024-07-18T15:52:56Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brandon/32/58098_2.png) [@Brandon](https://community.glideapps.com/u/Brandon)\
**Post date:** [July 18, 2024, 3:52pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/1 "2024-07-18T15:52:56Z")

</div>

Whenever I duplicate a sheet in the platform it scrambles the data and does not go into the correct cell columns.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e6bdd13f7fd7310267cade1911b4c8a46b60c41.png)

Project data I am duplicating:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd35521d6dbd1bb9f709cb6e102f330a245d0b5b.png)

Result duplicate:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c227139edd551a06290f96216590567644e007f.png)

It does not set the correct values in the right cells. I’ve looked at the row creation and it values are correct in the action flow but not when the action completes. Why is my data getting scambled.

This happends for duplicating the rows or when I add data in the connected Google Sheet.

---

<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:** [July 18, 2024, 4:27pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/2 "2024-07-18T16:27:35Z")

</div>

Looks like the components are pointing to the wrong columns.

When you say that you duplicate a sheet, what does that mean? Are you duplicating an app along with the underlying data? Are you changing a data source? I’m not clear on what you are doing when you say you duplicate a sheet.

---

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brandon/32/58098_2.png) [@Brandon](https://community.glideapps.com/u/Brandon)\
**Post date:** [July 18, 2024, 4:40pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/3 "2024-07-18T16:40:56Z")

</div>

I created a douplicate of an existing row. The components are not pointing to the wrong columns.

---

<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:** [July 18, 2024, 4:47pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/4 "2024-07-18T16:47:20Z")

</div>

Can you show how everything is configured in your action flow?

---

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brandon/32/58098_2.png) [@Brandon](https://community.glideapps.com/u/Brandon)\
**Post date:** [July 18, 2024, 5:08pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/5 "2024-07-18T17:08:18Z")

</div>

Row for row it is the same.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4bccbefb2004db2da5e1e36987a52cf44a7e10b0.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49b73da647a70f0764f8ee572cc5b1db844b6d7c.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8bdb3d713e98097222ec2ef948c1626be0b8eb5d.png)

---

<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:** [July 18, 2024, 5:25pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/6 "2024-07-18T17:25:48Z")

</div>

So I assume it’s just a button with that Add Row action? Nothing is immediately jumping out to me. I’m curious what would happen if you deleted and recreated the button/action, but before going that far, a couple things I would try first would be to duplicate the button. If that new button does the same thing, try creating a new one with a new action that only fills a few columns to start.

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [July 18, 2024, 5:32pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/7 "2024-07-18T17:32:29Z")

</div>

When you duplicated the row did it have any Unique-IDs or Row-IDs in it? Cause chances are they may be pointing to the wrong/no data. Some of the data that is showing definitely looks like a Unique-ID/Row-ID. Plus it is showing the same UID which may be the underlying issue - it can’t find the relation or points to a random/wrong relation.

Good luck!

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5ffd8ea9dbed39098e0cd57b8064f9a6443e4941.png)

---

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brandon/32/58098_2.png) [@Brandon](https://community.glideapps.com/u/Brandon)\
**Post date:** [July 18, 2024, 10:30pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/8 "2024-07-18T22:30:07Z")

</div>

What you are seeing here is the USER ID getting placed set as their First Name.  
The USER ID should not be placed in the first name field.

---

<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:** [July 18, 2024, 11:15pm UTC](https://community.glideapps.com/t/scrambled-data-when-adding-data-to-google-sheet/74999/9 "2024-07-18T23:15:45Z")

</div>

How did you create the initial duplicate of the table?  
It sounds like Glide thinks the Name column is the RowID column.  
I would be inclined to do the following:

- Delete that column in the Google Sheet
- Sync the change with Glide
- Add a RowID column from within Glide
- Add a new Name column from within Glide.
- Reconfigure the action and try again.
