Hi, Any one have idea integrate Netsuite with Goog...
# general
j
Hi, Any one have idea integrate Netsuite with Google Sheet?
p
Can you be more specific?
j
I need to send Netsuite Saved Search results to Google Sheet on every week. for this, i need to sync Netsuite with google sheet
t
what I do is use microsoft flow and my gmail account. I have netsuite saved search send a CSV to my gmail on schedule, and then microsoft flow automatically picks it up and uploads to google drive in a folder. you can then open it via google sheets as needed. microsoft flow is free ^
m
At a past company I wrote a simple Restlet that just proxied
search.lookupFields
and a Custom Google Sheet Function. Then I was able to use formulas like
=GET_NETSUITE_VALUE('transaction', A2, 'amountremaining')
to pull data from NetSuite