- Make sure your spreadsheet is public or accessible with link.
Open up your spreadsheet in your browser, click on
Share
button, thenGet sharable link
, thenDone
- Open up your spreadsheet in your browser, copy the URL, click on
Retrieve from URL
button, paste the URL and click onParse
button to fill Spreadsheet ID (alternatively read this article to learn how to obtain SpreadsheetID) - Save settings