Google Sheets in ProfitPath

The Google Sheets integration connects ProfitPath directly with your Google account. Once the connection is set up, you can export any product you analyze in ProfitPath to a Google spreadsheet with a single click - including all important metrics such as purchase price, selling price, profit, ROI, fees, and much more.

In short:

Google Sheets is your personal deal database. Instead of copying promising products, writing them down, or trying to remember them, you collect them automatically and in a structured way in one place — in your own Google Drive.

You remain fully in control: the spreadsheets are stored in your Google account. ProfitPath only writes the data into them — you can continue editing, filtering, sorting, or sharing them with colleagues at any time.

Before you start, you need:

✅ A Google account - free; a normal Gmail/Google account is enough.

✅ An active ProfitPath or ProfitGo subscription that includes the export function.

✅ Account owner rights: spreadsheets can be managed by the account owner. Team members use the spreadsheets created by the owner.

Note: The connection uses Google’s official, secure OAuth process. ProfitPath only receives permission to read and write spreadsheets and to view your basic profile, meaning name and email address. ProfitPath does not have access to your other files in Google Drive.

Open Settings → Integrations in ProfitPath.

Find the Google Sheets card and click Connect.

Or click here: https://dash.profitpath.com/settings/integrations

A notification window appears: “Do you want to continue? We will establish a secure connection to your Google account.” Click Continue.

You will be redirected to Google. Select your account and confirm the permissions.

Important: In the Google dialog, make sure to tick all boxes — especially access to your Google Sheets. If this box is missing, ProfitPath will not be able to create or write to spreadsheets later.

After successful confirmation, you will automatically return to ProfitPath. On the card, you will now see:

your Google account ID, meaning your email address,

the time “Connection confirmed on …”,

the status “Connection established & confirmed.”

The Manage Sheets button will now also appear — your direct path to the management page.

Done! Your Google account is connected.

You can find the central management area under Google Sheets in the navigation, or via the Manage Sheets button from Integrations.

At the top, you will see the title Google Sheets with the subtitle: “Manage your Google Sheets and export product data to share it with your team.”

In the top right, there are two buttons:

Create → create a new spreadsheet.

Connect → connect an existing Google spreadsheet.

As long as you do not have a spreadsheet yet, the page displays the message: “Nothing to see here. Create a new spreadsheet or connect an existing one.”

Once you have spreadsheets, they appear as clear cards in a grid.

You have two options. Both lead to the same result — simply choose what works best for you.

Ideal if you want to start fresh. ProfitPath automatically creates the spreadsheet in your Google Drive.

Click Create. The Create new spreadsheet dialog opens.

Sheet title, required field: Give the spreadsheet a name that helps you recognize it in ProfitPath — for example, “Member Sourcing Sheet” or “Q3 Wholesale Deals.”

Amazon marketplaces, optional, ProfitGo-exclusive: Select additional marketplaces: DE, ES, FR, IT, NL, GB. For each selected marketplace, a separate row with the relevant figures is automatically added during export. The region in which you are currently viewing the product is always exported automatically.

Columns to export: Select the fields that should be included in your spreadsheet; see section 8. These fields will later form row 1, the header row, of your Google spreadsheet. You can add and remove columns and rearrange them via drag & drop.

Click Create. You will receive the confirmation: “New spreadsheet has been created.”

Tip: You can rename or rearrange the columns later at any time in Google Sheets — the automatic export will adapt accordingly.

Ideal if you already have a Google spreadsheet that should be used for exports.

Click Connect. The Connect existing spreadsheet dialog opens.

Sheet link (URL), required field: Paste the full URL of your Google spreadsheet, for example:
​https://docs.google.com/spreadsheets/d/1PfeF4N4Ps.../

ProfitPath automatically detects the spreadsheet ID from the link.

Amazon marketplaces: Select the desired marketplaces, as in Option A.

Click Connect. You will receive the confirmation: “Existing spreadsheet has been connected.”

Important: The spreadsheet must be located in your connected Google account, or that account must have write permissions, so that ProfitPath is allowed to write to it.

If you have multiple spreadsheets, you can mark one as the default. The default spreadsheet is the one used by the quick “one-click” export buttons, for example from the deal tables.

Click the ⭐ star icon on a spreadsheet card.

The star turns yellow — this spreadsheet is now your default spreadsheet, meaning the “default spreadsheet for exporting products.”

When you connect your first spreadsheet, it is automatically set as the default.

Tip: Without a defined default spreadsheet, the quick export buttons display the message “Set a default spreadsheet first” with a link to configure it.

When creating or editing a spreadsheet, you can freely choose from more than 100 available fields. This lets you build exactly the spreadsheet you need. By default, the following columns are preselected:

Amazon Marketplace · Product Name · ASIN · Amazon URL · Image URL · Image · Keepa Image (30 days) · Category

The available fields are grouped by topic:

Product & Identification: Product name, ASIN, brand, category, EAN/UPC barcode, rating, reviews, color, image & image URL, Keepa charts for 30/60/90/180/365 days, dimensions & weight.

Purchasing / Supplier, ProfitPath-exclusive: Supplier title, supplier page, supplier image, supplier URL, supplier price, purchase price, purchase currency, purchasing marketplace, custom wholesale fields.

Sales & Profitability: Selling price, sales currency, sales marketplace, Buy Box current & averages, breakeven, maximum cost, profit, ROI %, profit margin %, discounts.

Fees: Referral fee, FBA shipping costs, variable closing fee, per-sale fee, storage costs, digital services fee, net VAT, total fees — also available as 30-day averages.

Shipping & Fulfillment: Amazon fulfillment type, FBA/FBM, FBM shipping costs, prep fee, other fees, inbound shipping.

VAT / Taxes: VAT on purchase and selling price, including rates.

Market Data / Sales Rank: Current & average sales rank, sales rank drops, top %, estimated sales, number of FBA/FBM sellers, Amazon Buy Box, number of variations.

Properties & Flags: Private label, IP complaint, oversized, meltable, dangerous goods, ungated.

Notes & Metadata: Groups, latest note, all notes, export date & time, UTC and local, history URL, source URL.

Special export features:

Images are embedded as real images using Google Sheets’ =IMAGE() formula.

Links, such as Amazon URL, supplier URL, history, etc., are stored as clickable hyperlinks.

This is the real strength: Google Sheets export is available in many places throughout ProfitPath — always just one click away.

When you have a product open, you will find a dedicated button for each connected spreadsheet in the Google Sheets section. One click exports the current product directly into the selected spreadsheet. The default spreadsheet is marked with a star.

In the Analyzer, there is also a Google Sheets icon button for quick export. This immediately sends the product to your default spreadsheet, meaning “Export to default spreadsheet.”

In product tables, you can export individual rows via the action menu, using the Google Sheets icon. Available in, among others:

DealWatch

Explore

A2A, Amazon-to-Amazon

Store Spy

Wholesale, including favorites

Supplier favorites

Tip: You can show or hide this quick action under Settings → Actions, action “Export Google Sheets.”

When sourcing directly on Amazon or supplier pages with the ProfitGo browser extension, you can immediately save promising finds to your Google spreadsheet — without having to open ProfitPath separately.

On the Google Sheets page, you manage each spreadsheet via the ⋮ menu on its card.

Edit opens a window with:

Sheet title — the name within ProfitPath; freely editable.

Google Sheet name — the name in Google Drive; can only be changed in Google itself.

Google Sheet ID — the unique, unchangeable ID.

Available tabs — select which tab, meaning worksheet, in the spreadsheet should be used for exports.

Columns — reselect or rearrange fields.

Amazon marketplaces — adjust the selection.

Note: If you change the columns or their order, ProfitPath creates a new tab with the new columns so your existing data remains untouched.

Change order: Drag the cards by the handle icon and drop them into your preferred order.

Delete: Via the ⋮ menu → Delete. This only removes the connection in ProfitPath — your actual spreadsheet remains in Google Drive.

To disconnect your Google account again:

Go to Settings → Integrations → Google Sheets. Or click here: https://dash.profitpath.com/settings/integrations

Click Disconnect.

Confirm the warning window: “Are you sure? This action cannot be undone. This will permanently delete the Google connection and no further product exports will be possible.”

Your already exported spreadsheets remain fully intact in your Google Drive — only the connection to ProfitPath is disconnected.

Will my existing data be overwritten?
No. New exports are added as additional rows. If you change the column structure, a new tab is created.

Can I rename or rearrange the columns in Google Sheets myself?
Yes. The automatic export adapts — you can customize the spreadsheet exactly as you like.

What does “ProfitGo exclusive” mean for marketplaces?
Simultaneous export for multiple Amazon marketplaces is a ProfitGo feature. However, the currently viewed region is always exported.

Can ProfitPath see my other Google files?
No. The integration only receives access to spreadsheets, read/write, and your basic profile.

Can my team use the same spreadsheet?
Yes. Simply share the spreadsheet in Google Drive with your colleagues — just like any other Google spreadsheet.

What happens to my data when I disconnect the integration?
Everything that has already been exported remains in your Google Drive. Only future exports will no longer be possible.