Google Sheets Payment Reminder Automation

Develop a Google Apps Script that automates task management and extension tracking based on predefined conditions. The script interacts with a Google Sheet containing task information and sends data to designated webhooks for automated notifications. It also auto-extends deadlines when required

Project Objectives:
Webhook Automation: Trigger webhooks to send data to specific endpoints based on conditions such as due dates and task status.
Auto-Extension: Automatically add extensions to task deadlines when conditions are met, providing flexibility for users.
Error Handling and Logging: Ensure robust handling of date parsing and add logging for tracking script execution and diagnosing issues


Key Components
Google Sheet Structure:
The spreadsheet contains task-related data, including (Column Names):
Task Name (fixed data coming from a third party form)
Notes (fixed data coming from a third party form)
Due Date ("Fixed Date coming in Text Format" from a third party form)
1st Extension (To be Activated & Input using script as per logic)
2nd Extension (To be Activated & Input using script as per logic)
3rd Extension (To be Activated & Input using script as per logic)w
Priority (fixed data coming from a third party form)
Status (pending/completed)
Assigned to (fixed names coming from a third party form)
RATING (auto calculated using a formula)

The Due Date and extension columns are in text format ("DD-MM-YYYY").

Script Functionality:
The script runs daily to check each task's status and due date, comparing it with the current date.
It sends data to specific webhooks if the task meets certain conditions:
If "Due Date" is on or before the current date and the Status is "Pending," send data to "Webhook 1."
If "Due Date" is past and the current date is on or before "1st Extension", send data to "Webhook 2."
If the current date is on or before "2nd Extension", send to "Webhook 3."
If on or before "3rd Extension", send to "Webhook 4."
If extensions are missing, the script auto-extends deadlines by 2 days to ensure flexibility.

The date being input in 1st, 2nd and 3rd Extension is again from Third Party Form, hence DATE IS IN TEXT FORMAT..The date is being added to the google sheet automatically

Error Handling and Logging:
The script needs to handle Empty rows properly and only check rows with data in them (Column A to D will always be populated whenever someone enters data using the third party form).. so this might help

Expected Outcomes
1. Automated Task Management: The script should automate data send to webhooks based on predefined conditions.
2. Reduced Manual Intervention: By auto-extending deadlines and sending data to webhooks, the script minimizes the need for manual updates.
3. Robust Functionality: The script should handle variations in date format and other potential issues with consistent performance and error handling (Google Sheet Columns will be in Text Format

Additional Considerations
1. Testing and Validation: The developer should thoroughly test the script to ensure correct functionality and proper handling of date parsing and other conditions.
2. Webhook Integration: Ensure webhooks are properly integrated and tested to confirm they receive data as expected.


FINALLY, when you deliver the code, I will simply replace the webhook URL's with my webhooks to get started and going...


Ideal Candidate:
- Expertise in Google Sheets App Script
- Experience with webhook TESTING (Use Webhook.site to Generate webhooks & do all your testing)
- Proven track record of developing automated systems.


We have already tried to retrieve the code using ChatGPT and it didn't work for us as the script was unable to detect the date in all the columns due to date being Received in text format. We can share the written code and you can make the changes where required for testing purposes and share the code