Google Contacts API (Oauth) - connect 2 accounts, compare values and make changes

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 4

Project Description

We have two Google accounts: Source account (A) and Target account (B) with [url removed, login to view]+ 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 [url removed, login to view]), you might want to create or import dummy contacts

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online