Google Workspace App - Feeding Gmail email data to Airtable & Google Sheets

详细信息

Looking for a developer to help us build a Google Workspace App that would be a private app available to my Google Workspace Organization as a private app via the app marketplace. App needs to take incoming and outgoing emails out of Gmail, then pass the To field (to, CC, BCC), From field, Subject line, Date, and the first 300 characters of the email body text to an air table base and to a google sheet. As a google workspace admin I need to have a interface to designate the google sheet and/or the airtable base, map data to columns in those destinations and handle any OAuth requirements. I'll also need a toggle to turn on and off the contact matching within airtable described below. I'd like this app to be available as a private app just to my organization, that way I can activate it to all my users in my google workspace admin. For each user in the organization it will need to automatically setup any links to the designated airtable/google sheet designated at the admin level. It will need to handle any Oauth required. Last condition for air table logging only: I want the ability to only log emails of email addresses that already exist in a contacts database within air table. I'd like this feature to be able to toggle on and off at the admin level. Our airtable has a table for contacts and then a separate table for interactions, with the interactions referencing a contact. If ON, then an email would be sent or received: sent emails would check the to fields against the airtable contact list via a email address match, received emails would check the from field against that same contact list. If that contact has a match, it logs the email. If it doesn't match to an existing contact, it doesn't log it. If OFF, then it logs all emails regardless of if the contact is in the contact list. If a contact isn't in contact list, then a new contact will have to be generated, then the email will be logged against that newly created contact.