Google Sheets

Modified on Mon, 21 Aug 2023 at 10:51 PM

1. Choose the connection type as  Google Sheets.

2. Fill up the Shared Link with the URL of your feed file.

3. How to get the link, please refer below


Use the link end with #gid for the current sheet
https://docs.google.com/spreadsheets/d/14foqrEPqyHjbctDNyI/edit#gid=1443929246 


4. Please add stock-sync@appspot.gserviceaccount.com with editor permission without changing the file to be accessed by anyone with a link.




5. Specify the Sheet name for anything other than Sheet 1. Or you can also choose multiple Sheets separated by a comma. It's also supported as a sheet index. You can write it as 0,1,2,3...


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 use it as a sheet index so that no need to change the name frequently. You can write it as 0 or 0,1,2,3.. because its support is separated by a comma.






Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article