Create Sheet

  1. Open the Sheets home screen at (https://docs.google.com/spreadsheets/u/0/).

  2. Click New ➕ . This will create and open your new spreadsheet.

../_images/CS-1.png ../_images/CS-2.png

  1. Copy Sheet ID.

../_images/CS-3.png

Example sheet URL: docs.google.com/spreadsheets/d/1YxK1mHhF2xGXOEhulaNYqGW9UtQLA59HDsMDlbr98Ak/edit#gid=0

Sheet ID: 1YxK1mHhF2xGXOEhulaNYqGW9UtQLA59HDsMDlbr98Ak

Create Apps Script Setup