Google Sheets Integration

Get your products and Buybox tracker data in Google Sheets, updated hourly with no files to download. Palmetrics can also read prices and costs from your sheet.

Hourly exports No file downloads Buybox tracker data Import prices and costs

Our team sets up the Google Sheets integration for you. Get in touch and we'll get it connected.

Google Sheets

Hourly Exports

Palmetrics updates your Google Sheet with your latest data every hour. There is no file to download or import, so your sheet is always ready for reporting, sharing with your team or building your own formulas.

Products and Buybox Data

Export your product list with its prices, stock levels and costs, alongside your Buybox tracker data. Filter, sort and chart it with the Google Sheets tools you already know.

Import Prices and Costs

Prefer to manage prices in a spreadsheet? On request, our team can switch on reading costs, selling prices and min and max prices from your sheet. Palmetrics checks it every hour, matches each row to a product by SKU and pushes new selling prices to your connected sales channels.

Frequently Asked Questions

How often is my Google Sheet updated?

Every hour. Palmetrics writes your latest product and Buybox tracker data to your sheet automatically, so there is no file to download.

How do I set up the Google Sheets integration?

Our team sets it up for you. Contact us and we'll give you a Palmetrics email address to share your Google Sheet with as an editor. Once it's shared, we'll connect it and your hourly exports will start.

Can Palmetrics read prices and costs from my sheet?

Yes, on request. Our team can switch on reading costs, selling prices and min and max prices from your sheet. Palmetrics checks it every hour and matches each row to a product by SKU, so the SKUs in your sheet must exactly match the SKUs on Palmetrics.

What happens when I change a selling price in my sheet?

Once reading prices is switched on, Palmetrics picks up the new price within the hour and pushes it to your connected sales channels.

Does the Google Sheets integration cost extra?

No. The Google Sheets integration is included in all Palmetrics plans at no extra cost.