Google Sheets-Airtable Automated Data Integration

I am seeking a skilled coder who can create a system that automatically updates my Google Sheets and sends email notifications whenever a new row of specific data - names and contact information or sales data and revenue - is added to my Airtable. Efficiency and accuracy are of utmost importance, as this system will also need to generate reports based on the new data additions.

Ideal Skills:
- Expertise in Airtable and Google Sheets integration
- Proficiency in automation software
- Experience in data management, particularly with contact data and sales revenue
- Strong understanding of email notifications systems and report generation

Requirements:
- Set up system to update Google Sheets with new Airtable row additions
- Create a trigger to send email notifications when these updates occur
- Develop a mechanism to generate reports based on new data entries.