For the Microsoft SharePoint connection method, you can refer below to follow the steps:-

1. Provide the Shared Link to have the connection. For how to get the Shared link, can refer below more detail.
    For example, https://<tenant>sharepoint.com/


2. The File Format field is set to Auto where Stock Sync auto-detect the file format or can also choose the type of file format.

3. By default First Row Header is disabled. If there’s a header on the file, need to enable this option. 

4. Then, for the Sheet Name you can put the sheet name under that field. If there are multiple sheets separated, you can put commas as separate. 

For example Sheet1, Sheet2

5. Lastly, you can click Test Connection to test the connection as well. 


Steps to get the shareable link:

1. Locate your file in Microsoft SharePoint and click on the Share icon. 

2. It will show up this. You can edit the setting as by clicking the part Anyone with the link can edit


3. You can set it as Anyone with the link or can add it as specific people  for [email protected] to access the file. Click on Apply to save the setting. 


4. Click on the share icon again to copy the link or you can right click on the file section to copy the link.