Skip to main content

SellerAmp SAS: Set Up Google Sheet

This article helps you connect SAS with Google Sheets and export your sourcing data to ArbitrageOne with a single click

ArbitrageOne Support avatar
Written by ArbitrageOne Support
Updated over 10 months ago

All your sourcing data is stored securely and encrypted, and it can only be decrypted with your account. At no point do we have access to your sources in plain text.

Important: Once you have created the sheet in ArbitrageOne, do not edit the sheet or delete any rows.

Don't feel like reading? Watch this video...

If you haven’t yet linked a Google account to SellerAmp SAS, you can do so here under "Google Account": https://sas.selleramp.com/ga-connections/update


Step 1: Create a New Sheet

Click on "New Sheet" in SellerAmp SAS.

Step 2: Adjust the Columns (Field Mappings)

In the "Field Mappings" section, you need to add all the following columns. The order does not matter:

  • Export Date (UTC yyyy-mm-dd)

  • Export Time (UTC)

  • ASIN

  • Quantity

  • Source URL

  • Tags

  • All Notes

  • Estimated Sales

  • Cost Price

  • Sale Price

  • Sales Marketplace

  • VAT

  • VAT on Fees

  • VAT on Sale

  • VAT on Cost

Step 3: Add Headers

Once you have correctly set up the Field Mappings, click on "Test & Write Headers".

⚠️ Important: Press this button only once.

Step 4: Save

Click "Save" to finalize the setup.

Step 5: Open Google Sheet

Click on "Open in Sheets" to open your newly created Google Sheet.

Step 6: Grant Access

A new tab will open. Click on "Share" in the top-right corner.

A pop-up window will appear. Add the following ArbitrageOne Service Account:

Note: The service account is not a regular Google account. It is required to securely retrieve your data in an encrypted manner. The ArbitrageOne team cannot log into this service account or view your sheets.

All your sourcing data is securely encrypted and can only be decrypted with your account. At no point do we have access to your sources in plain text.

Click "Send" to confirm.

Step 7: Copy the URL

Click in your browser's address bar and select the entire URL. Copy it to your clipboard (CTRL + C or Right-click > Copy).

Step 8: Paste the URL into ArbitrageOne

Paste the Google Sheet URL into ArbitrageOne.

Important: Once you have added the sheet to ArbitrageOne, do not edit the sheet or delete any rows.

Did this answer your question?