Skip to main content

Google Sheets Connector

The Google Sheets connector lets you use the data of a Google Sheet as a product feed in the Product Feed module.

Authorize LoyJoy​

Authorize LoyJoy to access your Google Sheet by clicking the Authorize button. Make sure you are logged in with the Google account that has access to the Google Sheet you want to connect.

Find the Sheet ID​

Obtain your Sheet ID and paste it into the connector settings in LoyJoy. Open your Google Sheet and copy the ID from the URL. The ID is the long string of letters and numbers between /d/ and /edit in the URL.

Google Sheets URL with the Sheet ID portion between /d/ and /edit highlighted.

Add the Sheet Name​

Get the Sheet name from your Google Sheet, for example Sheet1, and paste it into the connector settings in LoyJoy.