How to integrate with Google Sheets?

This integration allows users to export and manage the order data directly in Google Sheets with just a few clicks.


Here is the instruction

Step 1

Log in to your Google Sheets account → create a blank spreadsheet → click the Get Add-ons button in the right sidebar → search ParcelPanel and then click to installcomplete the authorization


Step 2

Go to ParcelPanel adminIntegration tab → API Key section → copy the ParcelPanel API Key


Step 3

Go back to Google Sheets → click to open ParcelPanel widget in the right sidebar → paste your ParcelPanel API Key → click the Export to sheet button



That’s it — you can now easily export your store’s order data to Google Sheets.


💡 Some useful tips

  • No need to re-enter your API Key — Google will remember your ParcelPanel API Key for the next export.
  • Support up to 20 stores — you can export orders from up to 20 different stores at once. Just enter multiple ParcelPanel API Keys on separate lines, and each store’s orders will be written to its own sheet automatically.
  • Customizable export fields — which fields are exported (and in what order) depend on your settings in ParcelPanel Admin → Orders tab → Export → Edit export fields.
  • By default, the system exports orders from the last 30 days. To change this or apply filters, create a view named Google Sheets in ParcelPanel Admin → Orders tab, and the system will export orders from that view instead.



Need help? Feel free to contact us via online chat or email, our world-class 24/7 support team is always glad to help you 🧐