> ## Documentation Index
> Fetch the complete documentation index at: https://docs.arbitrageone.de/llms.txt
> Use this file to discover all available pages before exploring further.

# BuyBotPro: Set Up Google Sheets

> Set up Google Sheets for BuyBotPro and connect it to ArbitrageOne.

All your sourcing data is securely encrypted and can only be decrypted with your account. We never have access to your sources in plain text.

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

**Step 1: Copy our BuyBotPro template**

Click [here](https://docs.google.com/spreadsheets/d/1Oebal-DF0Z1_k8CR65ifKhBTjXISmSYLfS73nJhxfuY/edit?gid=0#gid=0) to open the BuyBotPro template. Then click "File" and select "Make a copy".

<img src="https://mintcdn.com/arbitrageonegmbh/4jbrhR-MLLXqAQ6j/articles/purchases/images/buybotpro-set-up-google-sheets-01.png?fit=max&auto=format&n=4jbrhR-MLLXqAQ6j&q=85&s=46a2fa3ba0c5086dc0ea34f9f47c6df7" alt="" width="1128" height="563" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-01.png" />

A window appears. Click "Make a copy" again.

<img src="https://mintcdn.com/arbitrageonegmbh/4jbrhR-MLLXqAQ6j/articles/purchases/images/buybotpro-set-up-google-sheets-02.png?fit=max&auto=format&n=4jbrhR-MLLXqAQ6j&q=85&s=c61cfe070b9a2c7972c040f7acc1a93d" alt="" width="1259" height="622" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-02.png" />

**Step 2: Grant access**

A new tab with the copied sheet has opened. Click "Share" in the top right.

<img src="https://mintcdn.com/arbitrageonegmbh/4jbrhR-MLLXqAQ6j/articles/purchases/images/buybotpro-set-up-google-sheets-03.png?fit=max&auto=format&n=4jbrhR-MLLXqAQ6j&q=85&s=19326b0c436ec41792ea7116adc78d0a" alt="" width="1730" height="417" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-03.png" />

A pop-up window appears. Add the following ArbitrageOne Service Account: ***`googlesheet@arbitrage-one.iam.gserviceaccount.com`***

The service account is **not** a regular Google account. It's required to securely retrieve your data in encrypted form. 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. We never have access to your sources in plain text.

Click **"Send"** to confirm.

<img src="https://mintcdn.com/arbitrageonegmbh/4jbrhR-MLLXqAQ6j/articles/purchases/images/buybotpro-set-up-google-sheets-04.png?fit=max&auto=format&n=4jbrhR-MLLXqAQ6j&q=85&s=fa21f442613b9cbc21a379d300eeb76e" alt="" width="1517" height="703" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-04.png" />

**Step 3: 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).

<img src="https://mintcdn.com/arbitrageonegmbh/4jbrhR-MLLXqAQ6j/articles/purchases/images/buybotpro-set-up-google-sheets-05.png?fit=max&auto=format&n=4jbrhR-MLLXqAQ6j&q=85&s=dd681e82e0b23425a3eb48a1f85bd53c" alt="" width="1320" height="443" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-05.png" />

**​Step 4: Paste the URL into ArbitrageOne**

→ Open directly in the app: [app.arbitrageone.de/googlesheets](https://app.arbitrageone.de/googlesheets)

Paste the copied Google Sheets URL into ArbitrageOne.

**Step 5: Open BuyBotPro**

Open a new tab and navigate to any product page on Amazon. Click on the BuyBotPro settings.

<img src="https://mintcdn.com/arbitrageonegmbh/4jbrhR-MLLXqAQ6j/articles/purchases/images/buybotpro-set-up-google-sheets-06.png?fit=max&auto=format&n=4jbrhR-MLLXqAQ6j&q=85&s=c92c52b5f7c1a326f9948f25c19cd7e7" alt="" width="426" height="159" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-06.png" />

**Step 6: Add Google Sheet**

In the "Google Sheets" section, click "Add".

<img src="https://mintcdn.com/arbitrageonegmbh/TL_61VARw_FBL6qD/articles/purchases/images/buybotpro-set-up-google-sheets-07.png?fit=max&auto=format&n=TL_61VARw_FBL6qD&q=85&s=b92f820eb45a97e0004fd77f09f2186e" alt="" width="416" height="236" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-07.png" />

ArbitrageOne will display a "Google Sheets ID" field. Copy this ID and paste it into the "Google Sheets ID" field in BuyBotPro.

<img src="https://mintcdn.com/arbitrageonegmbh/TL_61VARw_FBL6qD/articles/purchases/images/buybotpro-set-up-google-sheets-08.png?fit=max&auto=format&n=TL_61VARw_FBL6qD&q=85&s=ea5607c3e1c5489fdb394889aac3a6d6" alt="" width="415" height="268" data-path="articles/purchases/images/buybotpro-set-up-google-sheets-08.png" />

Under "Name" you can optionally enter a custom name.

**⚠️ Important:** Click "Save & Sync" in BuyBotPro at the bottom.

Once you've created the sheet in ArbitrageOne, **do not edit the sheet or delete any rows.**
