> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.assisty.ai/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to manually set incoming inventory using Google spreadsheets

the 
### Navigate to Incoming Inventory Settings:

1. Log in to your Assisty account.
2. Go to the "Settings" menu.

### Generate Google spreadsheet file:

1. Select "Incoming Inventory" from the options available.
2. Select the source "Google spreadsheets file" by the select box.
3. Click the button "Generate now" to get the spreadsheet file
4. Select the Google Drive account to receive the file, or click Add New if there's no account yet.
5. Click the button "Generate and share".

![generate imcoming inventory sheets](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/screenshot-6_6hw78x.png)

### Generate Google spreadsheets file:
1. Open the speardsheets file, then choose "incoming_inventory" sheet, then enter data for the corresponding columns: product, location, and quantity.
2. Go back to the setting page, click button "Update Data" to Assisty", the process will take a few minutes.

![insert data](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/screenshot-5_1xh5dtf.png)

### Go to report data and see if incoming quantity is updated

![report data](https://storage.crisp.chat/users/helpdesk/website/4a116e5f64029800/screenshot-6_w4sa5s.png)