![]() Here you can click 'Google Spreadsheet' and enter the link from Google Spreadsheet. Now click on the '+ Combine webshops' button. Now go back to your project in Channable and go to the setup page. Copy the link and paste it into Channable, after having selected 'Google Spreadsheet' as your import type.In the following example, we will only import 'Sheet1': Select the name of the sheet you want to import. 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.To do this you have to follow these steps: ![]() It uses many functions used in the tidyverse suite of data analysis tools. If you want to import the information from your Google Spreadsheet to Channable you have to make your sheet public. The googlesheets4 package can import data in Google Sheets directly into R. Important: This article assumes you have read the article: How do I import from a datafeed? Step 1 - Publish Google Spreadsheet
0 Comments
Leave a Reply. |