Question 1

What data does CommerceShip send to Google Sheets?

Accepted Answer

Shipment records with package dimensions, weights, and service levels. Tracking events with timestamps and delivery outcomes. Carrier charges broken out by base rate, surcharge, and accessorial. Invoice line items and audit results. Order and fulfillment records tying shipments back to the channel they came from.

Question 2

How often does data update in Google Sheets?

Accepted Answer

Scheduled exports run daily or weekly on the cadence you set. For anything closer to real time, delivery exceptions can post to your alerting tool as they happen on the full platform, and the REST API supports pulling records on your own schedule.

Question 3

Can I map shipping fields to my existing Google Sheets schema?

Accepted Answer

Yes. Map any shipment field to your own column names and apply transforms during export, so data arrives in the shape your existing models expect. You do not need to restructure Google Sheets tables or rewrite downstream queries to take shipping data.

Question 4

Do I still get reporting inside CommerceShip?

Accepted Answer

Yes. Pre-built dashboards cover orders, shipments, carrier service, transit times, charges, and savings, with filtering by customer, carrier, service, and period. Exporting to Google Sheets is for joining shipping data to the rest of your business data, such as revenue, margin, and customer lifetime value.

Question 5

Will an export break the formulas in my Google Sheets sheet?

Accepted Answer

Exports write to a named range or tab you choose, so formulas, pivots, and charts elsewhere in the workbook keep pointing at data that refreshes underneath them. Replace-in-place keeps the range dimensions stable between runs.

Question 6

How much data can I move through Google Sheets?

Accepted Answer

Spreadsheets are the right tool up to the tens of thousands of rows. Past that, a database or warehouse connection handles the volume better, and the same export can be pointed there without redoing the field mapping.

Question 7

What access does CommerceShip need to Google Sheets?

Accepted Answer

The connection uses scoped credentials limited to the record types the integration works with, and you choose which fields are included. Credentials are encrypted at rest and stored separately from your operational data. Revoke the connection from either side at any time and the access ends with it.

Question 8

How is my data protected?

Accepted Answer

TLS in transit and AES-256 at rest, with tenant isolation enforced by row-level security in the database. Role-based permissions control who on your team can see cost data or change carrier settings, and automated actions are written to an audit log. CommerceShip is pursuing SOC 2 Type II certification. The security page carries the full detail.

Type	Format	Rows	Status
Invoice Audit	xlsx	1,284	Pending
Finance Invoices	xlsx	312	Pending
Invoice Audit	xlsx	5,902	Pending

Keep supply chain data current in Google Sheets

Google Sheets Integration Capabilities

How the Google Sheets integration works

Connect Google Sheets

Map columns

Refresh and import

Google Sheets Integration FAQs

Move data between CommerceShip and Google Sheets

Other Data Destinations