# Google Sheets import is creating new rows instead of updating existing

**URL:** <https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202>\
**Category:** Integrator.io\
**Tags:** google-sheets, export, import, netsuite\
**Created:** [March 5, 2024, 7:53pm UTC](https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202 "2024-03-05T19:53:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![larsrundquist](https://avatars.discourse-cdn.com/v4/letter/l/977dab/32.png) [@larsrundquist](https://connective.celigo.com/u/larsrundquist)\
**Post date:** [March 5, 2024, 7:53pm UTC](https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202/1 "2024-03-05T19:53:35Z")

</div>

I am using the Google Sheets Helper from the marketplace to export a saved search from NetSuite to write to a Google Sheet. It is set up to export the modified data based on the "Date Last Modified" field:

 ![5301043caa20740200000001-b1411009212e4b73a5549c250e66a234.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0baff968d1bc2bcd093dd9031359c87e785f4985.png)

The import is configured to compare the ID fields of the data set (which is the NetSuite Internal ID):

 ![5301043caa20740200000001-e1656bf622e4485393e178a05ebe2cb1.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0f800fc5d2a1f3b1110926daaaa527486d9924f6.png)

However, when the data is inserted into the Google Sheet, it is NOT updating the existing record; it adds a new record every time:

![5301043caa20740200000001-38a8dd2999794e86a79d42e8de145065.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5db060ae3ad918788648e1b4908555e9d20a9a3d.png)

I have not been able to figure out why this is happening. It should be updating the existing record. Any thoughts?

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [March 5, 2024, 10:36pm UTC](https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202/2 "2024-03-05T22:36:34Z")

</div>

My suspicion is that the value 'ID' should be 'id' in the field 'Source record field to find existing rows \*'. Can you double check the case sensitivity, and (see pic) you can click the 'Edit mock input' link to see the exact record and fields being processed.

 ![5301043caa20740200000001-a5b0d35d79ca4f6294d7add09333c8a3.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/496e51a6705a4b43c63d4ce53737d22f7fbd9d35.png)

---

<div class="post-metadata">

**Author:** ![larsrundquist](https://avatars.discourse-cdn.com/v4/letter/l/977dab/32.png) [@larsrundquist](https://connective.celigo.com/u/larsrundquist)\
**Post date:** [March 6, 2024, 3:01pm UTC](https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202/3 "2024-03-06T15:01:19Z")

</div>

Thanks, Scott! That seems to have done the trick, though I thought I had tried that in my many iterations of troubleshooting this. Regardless, you've got the magic touch! :)

Cheers,

Lars

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [March 7, 2024, 12:54am UTC](https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202/4 "2024-03-07T00:54:24Z")

</div>

FYI, I just published a new version of the marketplace template that includes new validations and error messages to make debugging this much easier.

---

<div class="post-metadata">

**Author:** ![larsrundquist](https://avatars.discourse-cdn.com/v4/letter/l/977dab/32.png) [@larsrundquist](https://connective.celigo.com/u/larsrundquist)\
**Post date:** [March 12, 2024, 1:26pm UTC](https://connective.celigo.com/t/google-sheets-import-is-creating-new-rows-instead-of-updating-existing/202/5 "2024-03-12T13:26:03Z")

</div>

Thanks, Scott!