With this code you will be able to automatically read the names of CS:GO skins from your Google Sheets and enter the prices on the Buff163 service into the same Google Sheets.
- Install Python 3.11 or later
- Clone the repository and write this command in the software folder:
pip install -r requiments.txt
- Get your Google account access key in JSON format and paste it into the folder with the software.
- Here get your service account email and add this email as an editor to your Google Sheets.
- Set up the
config.py
and run themain.py
.
TABLE_URL
- Your link to the Google Sheets.SHEET_ID
- Your Sheet ID from the table.CELLS_SKINS
- Cells with names of CS:GO skins.CELLS_PRICE
- Cells with prices of CS:GO skins.AUTH_FILE
- The name of your Google authorization key.SLICE
- The range of lots within one item to calculate the average price. If you want to get the minimum price, set it to1
.CREATE_XLSX
- Create an xlsx file in the software folder.COPY_TO_CLIPBOARD
- Copy results to clipboard.