Do you want to interactively learn about setting up your import in Channable? Learn how to create a Channacademy account in the Channable app through this Help Center article and start with the Basic Imports course.
Important: This article assumes you have read the article: How do I import from a datafeed?
Step 1 - Publish Google Spreadsheet
If you want to import the information from your Google Spreadsheet to Channable you have to make your sheet public. To do this you have to follow these steps:
- Go to your Google Spreadsheet
- Click on File
- Publish to the web
- If you have multiple sheets/tabs in one Google Spreadsheet and you want to publish multiple sheets, you need to publish each sheet/tab and create a separate import per sheet/tab. Select the name of the sheet you want to import. In the following example, we will only import 'Sheet1':
- Copy the link and paste it into Channable, after having selected 'Google Spreadsheet' as your import type.
Step 2 - Setup webshop
Now go back to your project in Channable and go to the setup page. Now click on the '+ Combine webshops' button. Here you can click 'Google Spreadsheet' and enter the link from Google Spreadsheet. Now click continue.