Importing Work Order details from google sheet to Netsuite.

Proposal summary

Using google sheet to update the work orders in Netsuite with a trigger from google sheet.

Requirement

Utemaster has a list of orders to be updated in google sheet with ID and one custom body date field that needs to be updated.

At that point, Utemaster want to be able to trigger a script (or button) to update the date field on all the listed work orders.

On the manual trigger, the work order will have the date updated in Netsuite.

Utemaster will provide the google sheet to do the script.

The google sheet will have two columns which are “Work order Id” and the “Due Date”.
The “Work order Id” will be the internal id of the work order and the “Due date” will map to the “Customer Due Date” field in Netsuite.
A button will be added to the google sheet. On the button click, the google sheet script will trigger, and all the work orders in the google sheet will get updated in Netsuite.
Response from Netsuite will be updated in google sheet whether it is a success or failure. We will also update the reason in the google sheet if the response is a failure.
For showing the status of the update(success/ failure) and for showing the reason(if it is failure), we will add two more columns named “Status” and “Reason” respectively.
When the user needs to update the next batch of work orders needed to be updated, the user can remove the listed work order on the google sheet and can add the new batch of the work order list.

The “Work order Id” will be the internal id of the work order and the “Due date” will map to the “Customer Due Date” field in Netsuite.
Other than the “Due date”, no other fields will be added in the google sheet for updating.

The maximum number of calls allowed is 20,000 per day. So we have to confirm the maximum work orders that can be updated in google sheet per day.