Step |
Instructions |
Step 1 |
Open the web app link provided. |
Step 2 |
If you see a Google Sheet in view-only mode:
- Click on the File button in the top left corner.
- Select Make a copy from the dropdown menu.
|
Step 3 |
If you see a page with two options (Make a Copy and AppScript File):
- Click on the Make a Copy button.
|
Step 4 |
Follow the on-screen instructions to complete the setup. |
Step 5 |
Click on the Extensions menu at the top of the Google Sheet. |
Step 6 |
Select Apps Script from the dropdown menu. |
Step 7 |
In the Apps Script editor, click on the Deploy button. |
Step 8 |
Select New deployment from the dropdown menu. |
Step 9 |
In the deployment configuration, click on Select type and choose Web app. |
Step 10 |
Fill in the required fields and click on Deploy. |
Step 11 |
Grant the necessary permissions when prompted. |
Step 12 |
Once deployed, copy the web app URL provided. |