Automated Email-to-Google Sheets Payment Tracker
Budget: ₹1,500 – ₹12,500 INR
Email Notification Integration:
The script should be able to monitor incoming email notifications.
When a new email notification with a specific subject for received payments arrives, it should add a new row to a designated Google Sheet for that day.
When an email notification with a different subject for sent payments arrives, it should add a new row to the same Google Sheet, but the row should be highlighted in red.
Google Sheets Integration:
Each day, the script should create a new Google Sheet for tracking payments, with a name format like "Payment Tracker - [Date]".
All received and sent payment data for the day should be added to the respective sheet.
The script should calculate and display the total received and total sent amounts at the end of the sheet.
Data Management:
The script should have an option to reset the Google Sheet daily, creating a new sheet for each day while preserving past data.
Additional Notes:
We will provide you with sample email notifications and Google Sheets layout for testing and development.
The freelancer should have experience with Google Apps Script and email notification integration.
Code should be well-documented and maintainable.
The script should be able to monitor incoming email notifications.
When a new email notification with a specific subject for received payments arrives, it should add a new row to a designated Google Sheet for that day.
When an email notification with a different subject for sent payments arrives, it should add a new row to the same Google Sheet, but the row should be highlighted in red.
Google Sheets Integration:
Each day, the script should create a new Google Sheet for tracking payments, with a name format like "Payment Tracker - [Date]".
All received and sent payment data for the day should be added to the respective sheet.
The script should calculate and display the total received and total sent amounts at the end of the sheet.
Data Management:
The script should have an option to reset the Google Sheet daily, creating a new sheet for each day while preserving past data.
Additional Notes:
We will provide you with sample email notifications and Google Sheets layout for testing and development.
The freelancer should have experience with Google Apps Script and email notification integration.
Code should be well-documented and maintainable.