Google Sheets

Connect Google Sheets to Profitscaler

No product feed yet? A published sheet of SKUs and cost prices is enough to get started.

Overview

A managed product feed is the right long-term answer, because it is already maintained by someone whose job it is. But if your cost prices live in a spreadsheet today, that will do to begin with. We read any CSV over HTTPS, and Sheets can publish one.

How it works

Publishing to the web turns a sheet into a CSV URL that anyone holding the link can read. Read that sentence twice: this is not your Google account's sharing settings, it is genuinely public, and search engines can find it. Put nothing in that sheet you would not put on a public page — product ids and cost prices only, no customer data, no supplier names or terms you would rather keep to yourself. If that is not acceptable, use a feed at an unguessable URL instead. If the sheet is not published, we get an HTML sign-in page back rather than a CSV, and the sync says so instead of failing quietly.

How to configure

One row per SKU. A column for the product id and a column for cost price excluding VAT.
File → Share → Publish to web, choose the single sheet, and pick Comma-separated values (.csv).
Copy the published URL — not the URL in your browser's address bar.
Paste it into onboarding step 1 and map the two columns.
Move to a real feed when you have one. The mapping step is the same.

Google Sheets

Google Sheets is Google's spreadsheet app. Its publish-to-web feature exposes a sheet as a CSV file at a public URL.

Website

sheets.google.com

Support

support@profitscaler.io

Start for free

See pricing

Already have an account?

More integrations

Browse all

Google Tag Manager

The one thing Profitscaler cannot work without. Your server container asks what an order was worth, and gets a number back before the tag fires.

Google Tag Manager

The one thing Profitscaler cannot work without. Your server container asks what an order was worth, and gets a number back before the tag fires.

Google Ads

Send profit as the conversion value, so bidding optimises for what you keep instead of what you turn over.

Google Ads

Send profit as the conversion value, so bidding optimises for what you keep instead of what you turn over.

Google Analytics 4

Profit as an event parameter and a custom metric, reported next to the revenue you already have.

Google Analytics 4

Profit as an event parameter and a custom metric, reported next to the revenue you already have.

Find out what your orders are actually worth

Start for free

Try our profit simulator

Track 500 orders for free. No credit card required.

Find out what your orders are actually worth

Start for free

Try our profit simulator

Track 500 orders for free. No credit card required.

Find out what your orders are actually worth

Start for free

Try our profit simulator

Track 500 orders for free. No credit card required.