| Step | Instructions |
|---|---|
| Step 1 | Open the web app link provided. |
| Step 2 |
If you see a Google Sheet in view-only mode:
|
| Step 3 |
If you see a page with two options (Make a Copy and AppScript File):
|
| 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. |
Posts