> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.stock-sync.com/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).

# Export to Google Sheets connection method 

For the **Export to Google Sheets** connection method, follow the steps outlined below.

1. In the **Source Host** section, paste the link to your Google Sheet where the inventory details will be exported. For example, the link will be https://docs.google.com/spreadsheets/d/.....

![](https://storage.crisp.chat/users/helpdesk/website/-/b/2/1/9/b219050a5836c000/screenshot-2026-03-31-at-11314_og9wge.png)

2. To grant your access to stock sync for entire sheet and specific sheet can refer below here:

###### Entire Sheet Grant Permission 

To protect your entire sheets, please grant access to [stock-sync@appspot.gserviceaccount.com](stock-sync@appspot.gserviceaccount.com) as **Editor**. 

![](https://storage.crisp.chat/users/helpdesk/website/-/b/2/1/9/b219050a5836c000/ezgifcom-video-to-gif-converte_1canlis.gif)

###### Specific Sheet Grant Permission 

To protect your **specific sheet**, please grant access to [stock-sync@appspot.gserviceaccount.com](stock-sync@appspot.gserviceaccount.com) as **Editor**. 

![](https://storage.crisp.chat/users/helpdesk/website/-/b/2/1/9/b219050a5836c000/ezgifcom-video-to-gif-converte_1mh7qao.gif)
3. Enabling **Replace all is defined** will clear the google sheet before writing. By default, it is disabled and will not clear the sheet.

4. By default **Create new line** is enabled and the new products will be appended as well as updating the existing product. Ensure that Create new line always enabled before Starting the Process.

5. In the Matching Column section of **Step 2**, column index of numbers and letters are supported for export feed, and **NOT column names**. Please ensure that using **column index (1,2,3... or A,B,C...)** instead of column name.

![](https://storage.crisp.chat/users/helpdesk/website/-/b/2/1/9/b219050a5836c000/screenshot-2026-07-27-at-34454_j9j17h.png)

###### Troubleshooting: Sheet Empty After Export

If the export feed runs but the Google Sheet remains empty, please ensure you have granted **write (Editor) permission** to `stock-sync@appspot.gserviceaccount.com`. Without write access, the export feed cannot fill in quantity or price data.