Schedule MyContent

Google App Script project to list and update status of an Schedule Spreadsheet

Overview

This project provides a user-friendly interface for the sales team (closers) to update the status of their call schedules, which are recorded in a Google Sheets document. The interface is built using Google Apps Script, jQuery, and TailwindCSS.

Features

1. Web page to list the schedule in a datatable
2. Pop-up form for selecting the status
3. Change log recorded in a separate sheet/tab

Technology Stack

• Google Apps Script
• Google Sheets
• HTML
• CSS (TailwindCSS)
• JavaScript (jQuery)

Installation

1. Open your Google Sheets document
2. Go to Extensions > Apps Script
3. Copy and paste the provided Google Apps Script code
4. Save and deploy as a web app

Usage

1. Open the Google Sheets document
2. Click on the custom menu item to open the status update interface
3. Select the lead and update its status using the pop-up form
4. Changes will be automatically recorded in the main sheet and the change log

Contributing

This is a closed project for internal use. For any issues or feature requests, please contact the project maintainer.

License

This project is proprietary and confidential. Unauthorized copying, modification, distribution, or use of this software is strictly prohibited.