Python Developer Needed for Group Email Web App

Project Title: Web App for Group Email Management with Airtable and SendGrid Integration Description: We are looking for a skilled web developer experienced in Python, Airtable, and SendGrid to build a custom email management web application. This application will be used by our leaders and management team to send group emails to parents and leaders, based on various filters and custom groupings. Key Requirements: 1. Group Creation: • Ability to create dynamic groups based on campus and location. • Support for custom group creation. • Integration with Airtable’s Parent and Teacher tables to pull contact data. 2. Email Composition: • Rich text editor for composing emails. • Ability to attach documents and images. • Functionality to add hyperlinks, CC, BCC, and inline formatting. • Option to insert attachments (e.g., PDFs, images). 3. SendGrid Integration: • Use SendGrid to send emails to the defined groups. • Ensure all sent messages are stored in the Airtable base for future reference. 4. Authentication and Security: • Google OAuth authentication for secure access. • Permissions-based access to ensure only authorized users can send emails or view messages. 5. Message Tracking: • Ability for end-users to view previously sent messages. • Display all message details, including recipients, attachments, and message body. 6. User Interface: • Modern, clean, and user-friendly interface for ease of use. • The UI should support filtering and selecting groups, with clear and simple navigation. 7. Hosting: • The application will be hosted on AWS, using Elastic Beanstalk for easy scalability and management. Deliverables: • A fully functioning web app deployed on AWS. • Source code with clear documentation. • Detailed instructions on deployment and integration with Airtable and SendGrid. • Testing and debugging of all functionality, including email sending and message tracking. To Apply: • Provide examples of previous projects involving Airtable, Python, and SendGrid integration. • Include a brief description of how you would approach the Google OAuth integration and the storage of sent messages in Airtable. • Share your proposed timeline for the project, including key milestones and estimated delivery.