WP plugin to send CF7 data to Airtable and sync Google Contacts

I want to develop a custom WordPress plugin which sends Contact form 7 data to Airtable and syncs this back to WordPress and to Google Contacts.

Developer would need knowledge of
- Wordpress Plugin creation
- The Wordpress Contact Form 7 plugin
- AirTable an the Airtable API
- Google Contacts and the People API

The WordPress plugin will need to be to do the following:

1) Firstly, when new customer data is submitted via a WordPress Contact Form 7 I want the plugin to automatically send this data to Airtable and generate a new record in a set table.

2) Secondly, I would like the plugin to periodically (i.e. daily) check the same Airtable table for modified records since the last visit and then do the following:

A) If there is a new record in the data which fulfils a simple 'if' statement (i.e. doesn't exist in Google contacts or is confirmed as new) then create a new contact in a Google Contact group and send the Google Contacts resource ID value back to a column in that record in Airtable. I don't want this to be done from Contacts Form 7 as new contacts need to be manually checked and appointments made before I can confirm them as a new contact.

B) Then, If the contact does exist and data has been modified, Get the relevant Resource ID and eTag from the contact and then overwrite all of the relevant fields in that relevant Google Contact. I want a one-way sync so that Google Contacts just replicates the relevant fields in Airtable.

C) Save all the changes coming from Airtable into a Wordpress Database as a backup.

I would envisage the plugin to just be one page. Contact Form 7 form identification link (so the correct data is sent), Airtable API Key, Base and table links and Google Contacts API key request button. Also a text history table of the records which have been changed.

I would also like a "sync now" button, to sync the contacts when needed.

The plugin only needs to be functional. Only I will have access so no extra CSS or elaborate design or public front end is required.

I have tried a lot of the "sync bots", but they always have some feature missing. E.g. not able to sync multiple phone numbers per contact.

I you are able to help me with this or would like to ask any further questions about it please let me know.

Please let me know how long you think it would take you and any previous similar things you have worked on which might be relevant.

Thanks for your time ...

Kris Lord

As a Reference:
Example fields to be using are:
First Name
Family Name
Name Prefix
E-mail 1 - Type
E-mail 1
E-mail 2 - Type
E-mail 2
Phone 1 - Type
Phone 1
Phone 2 - Type
Phone 2
Phone 3 - Type
Phone 3
Phone 4 - Type
Phone 4
Address 1 - Type
Address 1 - Street
Address 1 - Extended Address
Address 1 - City
Address 1 - Postal Code
Organization 1 - Name
Custom Field 1 - Type
Custom Field 1 - Value
Notes