# Netsuite - Google Sheet Pre-Built Flow Issues **URL:** \ **Category:** Integrator.io\ **Tags:** google-sheets, netsuite\ **Created:** [May 29, 2025, 2:42pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683 "2025-05-29T14:42:11Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Erdem\_Gungordu](https://avatars.discourse-cdn.com/v4/letter/e/ee7513/32.png) [@Erdem\_Gungordu](https://connective.celigo.com/u/Erdem_Gungordu)\ **Post date:** [May 29, 2025, 2:42pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/1 "2025-05-29T14:42:11Z")
Prebuilt flow for the Netsuite - Google Sheet Integration isn`t working properly when Saved Search is type of Transaction. I think issue is with the hooks - It only pulls the first row of the saved search then it errors out due key field is missing even though source data has it "Internal ID" Hooks maybe expecting each rows to have unique Internal ID but with the transactions that`s the case if journal entry has 10 lines you will have 10 lines of same internal id in the saved search. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [May 30, 2025, 2:07am UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/2 "2025-05-30T02:07:42Z")
Are you using the "group" feature on the export? Also, are you expecting 2 fields to be the key i.e. internal id and line id? You could also just use "line unique key"? ---
**Author:** ![Erdem\_Gungordu](https://avatars.discourse-cdn.com/v4/letter/e/ee7513/32.png) [@Erdem\_Gungordu](https://connective.celigo.com/u/Erdem_Gungordu)\ **Post date:** [May 30, 2025, 7:18pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/3 "2025-05-30T19:18:16Z")
I have tried both - Internal ID - Unique to each transaction Then I have created a Unique ID for each line by combining Internal ID + Line ID - Thinking maybe flow really wants to see unique id for each line It works on test mode since it`s only pulling the first line but when I turn on the integration and run, it errors out. ---
**Author:** ![michaelsmith](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/michaelsmith/32/6886_2.png) [@michaelsmith](https://connective.celigo.com/u/michaelsmith)\ **Post date:** [May 30, 2025, 8:45pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/4 "2025-05-30T20:45:43Z")
can you share what the error message is? or some images of the flow and flow steps? ---
**Author:** ![Erdem\_Gungordu](https://avatars.discourse-cdn.com/v4/letter/e/ee7513/32.png) [@Erdem\_Gungordu](https://connective.celigo.com/u/Erdem_Gungordu)\ **Post date:** [June 2, 2025, 1:48pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/5 "2025-06-02T13:48:53Z")
The error I am getting is : The record is missing a value for the field: Internal ID. This field is required, because the value is used to determine if a row should be updated vs appended in the spreadsheet. This Error doesn`t make sense because each line of the export has Internal ID Code : missing\_required\_field Source : Pre map hook Message: The record is missing a value for the field: Internal ID. This field is required, because the value is used to determine if a row should be updated vs appended in the spreadsheet. I am unable to share screenshots, my company policy somehow blocks uploading files here. I am happy to send it via email. My Export: Record Type = Transaction Saved Search = "Transaction Saved searc" Group Rows. My Import : SpreadSheet ID: Populated Shee Name: Populated Does your sheet have column headers: Checked. Headers : automatically calculated (Matches to the Google Sheet) Column to find existing rows :Internal ID Source record field to find existing rows : Internal ID When I preview I get error too : [ { "code": "missing\_required\_field", "message": "The record is missing a value for the field: Internal ID. This field is required, because the value is used to determine if a row should be updated vs appended in the spreadsheet.", "source": "pre\_map\_hook", "resolved": false, "occurredAt": 1748872000567 } When I adjust my saved search to look for 1 transaction only I don`t get any errors, so basically if I pull 1 journal entry from Netsuite flow works but when I pull multiple it errors out. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [June 2, 2025, 3:00pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/6 "2025-06-02T15:00:27Z")
There is no reason to use "group rows" in this case. Can you disable that and then use line unique key as the "Column to find existing rows" and "Source record field to find existing rows". ---
**Author:** ![Erdem\_Gungordu](https://avatars.discourse-cdn.com/v4/letter/e/ee7513/32.png) [@Erdem\_Gungordu](https://connective.celigo.com/u/Erdem_Gungordu)\ **Post date:** [June 2, 2025, 3:31pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/7 "2025-06-02T15:31:00Z")
Is it possible to do screen sharing? When I undo the Grouping and re-try - Run Console shows the Integration ran successfully however no data being populated in the Google Sheets. | Step | Status | Success | Ignored | Errors | Auto-resolved | Pages | Duration | Completed | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Pull Saved Search | Completed | 1034 | 0 | Success | 0 | 52 | 00:00:13 | 06/02/2025 10:28:10 am | | Update existing rows and append new rows | Completed | 1034 | 0 | Success | 0 | 52 | 00:01:28 | 06/02/2025 10:29:30 am | ---
**Author:** ![Erdem\_Gungordu](https://avatars.discourse-cdn.com/v4/letter/e/ee7513/32.png) [@Erdem\_Gungordu](https://connective.celigo.com/u/Erdem_Gungordu)\ **Post date:** [June 2, 2025, 3:56pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/8 "2025-06-02T15:56:50Z")
When I look at the Google Sheet cell audits - I am seeing cells are being replaced with " " . Basically when integrator runs it replaces the data with the blank values and it shows successful in UI - Somehow data gets erased within the process I think.. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [June 2, 2025, 4:01pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/9 "2025-06-02T16:01:50Z")
You may have to redo your mappings after removing the grouping. Maybe start a fresh flow without grouping and then a new import and freshly map everything in? ---
**Author:** ![Erdem\_Gungordu](https://avatars.discourse-cdn.com/v4/letter/e/ee7513/32.png) [@Erdem\_Gungordu](https://connective.celigo.com/u/Erdem_Gungordu)\ **Post date:** [June 2, 2025, 7:14pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/10 "2025-06-02T19:14:32Z")
Tyler - you were right re-doing the whole thing made the trick. Thanks for your help. I got this error but my file was limited to 1000 rows after expanding the rows to 3k - Error went away. {"error":{"code":400,"message":"Invalid data[19]: Range (Sheet2!1001) exceeds grid limits. Max rows: 1000, max columns: 27","status":"INVALID\_ARGUMENT"}} ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [June 6, 2025, 9:38pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/11 "2025-06-06T21:38:09Z")
Can you share what you're sheet looks like? How many rows of data do you have? How many columns? Are you making a table that just includes the whole sheet and only a few rows/columns are populated? Maybe you can join office hours next week and show us: [https://zoom.us/meeting/register/338c30f6ce7573eacde7dc3c8da9331e#/registration](https://zoom.us/meeting/register/338c30f6ce7573eacde7dc3c8da9331e#/registration) ---
**Author:** ![Orlando\_Matthewson](https://avatars.discourse-cdn.com/v4/letter/o/ed655f/32.png) [@Orlando\_Matthewson](https://connective.celigo.com/u/Orlando_Matthewson)\ **Post date:** [January 15, 2026, 8:37pm UTC](https://connective.celigo.com/t/netsuite-google-sheet-pre-built-flow-issues/4683/12 "2026-01-15T20:37:49Z")
Im interested in this whole process, are there recorded webinars in Celigo showing this? What are the course related to this?