)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
You can integrate NetSuite saved searches with Google Sheets while preserving all your existing data by using a multi-tab approach that separates live imports from historical records.
Here’s how to set up saved search integration that protects your existing data while providing automated updates.
Preserve existing data while integrating NetSuite saved searches using Coefficient
Coefficient connects directly to your NetSuite saved searches without affecting uninvolved cells or tabs. By importing to dedicated tabs and using formulas to combine data, you maintain complete control over your existing information.
How to make it work
Step 1. Set up your saved search import to a dedicated tab.
Go to Import from → NetSuite → Saved Searches and select your target search. Import to a new “NS_Import” tab that’s separate from your existing data. This ensures your current information remains untouched.
Step 2. Create your data preservation architecture.
Set up three tabs: “NS_Import” for Coefficient’s refreshed data, “Master_Data” for your permanent historical records, and “Working_Sheet” for the combined view using formulas.
Step 3. Build formulas to identify and add new records only.
Use this formula to find new records:. This identifies records in the import that don’t exist in your master data.
Step 4. Schedule automated updates without data loss risk.
Set up hourly or daily refresh schedules for your saved search import. Since the import goes to its own tab, your historical data and existing calculations remain completely safe.
Protect your data while automating updates
This approach gives you automated NetSuite updates while maintaining complete data integrity. You get the benefits of live connections without any risk to your existing information. Start integrating your saved searches safely.
