InNoHassle-ScheduleConflictResolver

React plugin for Google Spreadsheets to check conflicts in Innopolis University's schedule

This template was used for react integration: https://github.com/enuchi/React-Google-Apps-Script/tree/main

Installation and linking

1. Download node and pnpm package manager
2. In the root of the project run pnpm install
3. Enable the Google Apps Script API in your settings
4. Login into your google spreadsheets account via pnpm run login
5. Open the spreadsheet you wish to link the plugin to
   • Open your Google Sheets document
   • Go to Extensions -> Apps Script -> Project settings
   • Find Script ID and copy it
6. Rename the .clasp.json.EXAMPLE file to .clasp.json
7. Open the above file and change it's contents to link the project
   • DO NOT edit rootDir field
   • Change the scriptId field to the value copied on step 5
   • Change the parentId field to the id of your spreadsheet. You can get it via spreadsheet url. For example: https://docs.google.com/spreadsheets/d/.../edit the id is at ...
8. Next, follow either Launch for production if you intent on using the plugin and Launch for development if you want to change the code for the plugin

Launch for production

1. Run pnpm run deploy (if prompts to update the manifest, accept)
2. Run pnpm run open
3. After the page loads you will see InNoHassle menu item on top of your spreadsheet. Click the button and open the plugin. It will appear as a sidebar on your right

Launch for development

1. Run pnpm run start