Importing from a Google Spreadsheet

This article assumes you have read the article: How do I import from a datafeed?

1) 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:

1. Go to your Google Spreadsheet
2. Click on File
3. Publish to the web
4. Publish
   
   
   
   Note: If you have multiple sheets in one Google Spreadsheet you want to import into Channable, you need to publish each sheet separately and create separate imports for them in Channable. If you choose "Entire Document" it will automatically take the first sheet. You can choose which sheet you want to publish by clicking on "Entire Document":
   
   
   
5. Copy the link
   
   

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.