In this tutorial, we will learn how to import products directly from Google Sheets into Products Sync Master.

Step 1: Get the Share Link

Open your Google Sheet document and copy the share link:

Example link:

https://docs.google.com/spreadsheets/d/1UTbgP_28rxRR908v5mCNNcS4I16BiKGU/edit?usp=sharing

Step 2: Modify the Link

The link you copied cannot be used directly. We need to adjust it so that it can be read as a CSV file by Products Sync Master.

Take the part of the link before the word "edit":

https://docs.google.com/spreadsheets/d/1UTbgP_28rxRR908v5mCNNcS4I16BiKGU/

Then add this to the end:

export?format=csv

✅ Final link will look like this:

https://docs.google.com/spreadsheets/d/1UTbgP_28rxRR908v5mCNNcS4I16BiKGU/export?format=csv

Step 3: Use the Link in Sync Master

Paste the modified link into the file source field in Sync Master and continue with your import settings.

Tips:

• Make sure your Google Sheet is set to “Anyone with the link can view”, otherwise the app will not be able to access it.
• Each worksheet in Google Sheets can be exported separately. By default, only the first sheet is used.
• If you make changes in Google Sheets, they will be reflected immediately in the CSV export link.