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

可议价

可议价 Upwork Technology & Programming Overseas
845 days ago

Description

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.

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Node & Vue Developer We are looking for a Node & Vue Developer to join our team and help us develop and maintain various software applications. As a Node & Vue Developer, you will be responsible for building and deploying web applications using Node.js and Vue.js. You will work closely with our development team to design and develop new features, improve existing functionality, and ensure the performance, scalability, and security of our applications. Responsibilities: Design and develop web applications using Node.js and Vue.js. Work with our development team to design and implement new features. Improve existing functionality and optimize application performance. Write clean, maintainable, and scalable code. Collaborate with other team members to ensure seamless integration of applications. Stay up-to-date with the latest trends and technologies in web development. Requirements: Proven experience as a Node & Vue Developer or similar role. Strong knowledge of Node.js and Vue.js. Experience with HTML, CSS, and JavaScript. Familiarity with RESTful APIs. Experience with database technologies such as MongoDB or MySQL. Good understanding of software development principles and best practices. Excellent problem-solving and communication skills. Ability to work independently and as part of a team. Bachelor's degree in Computer Science or a related field. If you are a passionate Node & Vue Developer with a strong desire to develop innovative software applications, we would like to hear from you. Please submit your resume and portfolio of your work.
120.0 GBP Technology & Programming peopleperhour Overseas
3 hour ago