Google Sheets
Choose the connection type as Google Sheets.
![](https://storage.crisp.chat/users/helpdesk/website/347b00903ae24000/a40e7446-4cea-47ee-b40f-eca34e_1vq19q7.png)
Fill up the Shared Link with the URL of your feed file.
How to get the link, please refer below
![](https://storage.crisp.chat/users/helpdesk/website/3f2b9ea76f365600/1175245c-a818-4f26-80d9-3398a5_ywz3al.gif)
Use the link end with #gid for the current sheet https://docs.google.com/spreadsheets/d/14foqrEPqyHjbctDNyI/edit#gid=1443929246
Please add stock-sync@appspot.gserviceaccount.com with editor permission without changing the file to be accessed by anyone with a link.
![](https://storage.crisp.chat/users/helpdesk/website/9e740f1b5747c800/bfd247d2-4735-4a9b-86a9-0b352f_9t5zu3.png)
Specify the Sheet name for anything other than Sheet 1. Or you can also choose multiple Sheets separated by a comma. Kindly be informed that if you have multiple sheets, the column mapping should correspond to Sheet 1.
For example: If your sheet name consists of a wildcard or any specific date, you can only input the sheet name.
![](https://storage.crisp.chat/users/helpdesk/website/347b00903ae24000/a40e7446-4cea-47ee-b40f-eca34e_1vq19q7.png)
Fill up the Shared Link with the URL of your feed file.
How to get the link, please refer below
![](https://storage.crisp.chat/users/helpdesk/website/3f2b9ea76f365600/1175245c-a818-4f26-80d9-3398a5_ywz3al.gif)
Use the link end with #gid for the current sheet https://docs.google.com/spreadsheets/d/14foqrEPqyHjbctDNyI/edit#gid=1443929246
Please add stock-sync@appspot.gserviceaccount.com with editor permission without changing the file to be accessed by anyone with a link.
![](https://storage.crisp.chat/users/helpdesk/website/9e740f1b5747c800/bfd247d2-4735-4a9b-86a9-0b352f_9t5zu3.png)
Specify the Sheet name for anything other than Sheet 1. Or you can also choose multiple Sheets separated by a comma. Kindly be informed that if you have multiple sheets, the column mapping should correspond to Sheet 1.
For example: If your sheet name consists of a wildcard or any specific date, you can only input the sheet name.
Updated on: 02/07/2024
Thank you!