We have two Google accounts: Source account (A) and Target account (B) with 12.000+ mostly identical contacts. We need a customized one-time automation to compare postal addresses and update any missing data in the target account (B).
The program should do the following:
1. Extract all address data from the Source Google account (A) into CSV
1.1. Connect to the (A) Source Google account via OAuth
1.2. Extract all names, emails and postal addresses (more than one e-mail and postal address per contact possible) into a CSV table "[url removed, login to view]". The data should use Unicode formatting with special characters support äüöß
2. Compare missing postal addresses between CSV and target account (B)
2.1. Connect to the Target Google account (B) via OAuth
2.2. Compare if in (B) there are missing postal addresses, which are available in (A). The index field / connection is the email address of the contact. (B) can also have more than one email and postal address per contact - good checking is important.
2.3. For each contact with a missing address in (B), add one line per contact and the addresses from (A) + (B) into a new CSV "[url removed, login to view]" for review.
After the table is reviewed:
3. Import all postal addresses from "[url removed, login to view]" into the corresponding contact in (B)
For each step, the application should log each read / written entry into a log file.
You will receive two accounts for test but not have access to the real address data. To ensure your app will handle the amount of contacts (about 12.000), you might want to create or import dummy contacts