Updating Google Contacts from Google Sheet


I run a small B&B in Poland and keep track of my guests in a Google Sheet. When they call me, I'd like to see who they are and some basic information on their stay. I've made a spreadsheet pulling together all the relevant values and now I need someone to help me with pushing it into my phonebook.

Terms used:

1. Contact - guest with the relevant details

2. Sheet - Google Sheet [login to view URL]

3. Phonebook - my Google Contacts

Script should automatically sync data from the sheet:

1. Existing contacts should be updated in the phonebook

2. New contacts should be added to the phonebook and placed in a group

Sync should include:

1. New contacts added to the sheet

2. Contacts already existing in the sheet but changed either manually or by a function

Fields values in sheets can are imported and previously:

1. Manually inputed into the sheet

2. Imported from other sheets

3. Created or updated by formulas in the sheet


1. If the contact is duplicated on the sheet, script should sync the version with the closest check-in date.

2. Changes are happening often and should be pushed every 15 minutes

3. Empty rows can be pre-populated by incomplete formulas waiting for input and should not be pushed to the phonebook

4. „+” needs to be added in front of all phone numbers prior to adding them to phonebook

Evner: Google App Engine, Javascript, Scripting, Process Automation, Active Directory

Se mere: sync google contacts with google spreadsheet, google sheets 2018, google sheets contact list, google sheets, google spreadsheet contacts template, google mail contacts, google sheet link, where's google sheets, upload price sheet google google shopping, access map contacts using google maps, spread sheet google foreclosure, google analytic drupal contact goal, retrieve longitude latitude excel sheet google, add google map joomla contact, google maps expert contact google maps, google maps iframe contact data joomla, google yahoo apis contact import, google apps shared contact api application, export gmail contacts using google contacts api php, spread sheet google

Om arbejdsgiveren:
( 0 bedømmelser ) Warsaw, Poland

Projekt ID: #20848730

9 freelancere byder i gennemsnit $36 på dette job


Hi, You've removed the before the project and I've got no way to reply back to you :|

$10 USD in 7 dage
(2 bedømmelser)

Hi This is deep ,iam a searching for a part time job i have some skills that i meantioned above,if iam useful for anyone you can apporoach me, iam very honest and energetic person, i wil do my work as much as fast and Flere

$10 USD in 20 dage
(0 bedømmelser)
$25 USD på 1 dag
(0 bedømmelser)

Hi.i am interested in your work

$25 USD på 1 dag
(0 bedømmelser)

I want this urgenr

$25 USD på 1 dag
(0 bedømmelser)


$24 USD på 1 dag
(0 bedømmelser)

Hi, Does your phonebook sync with your phonebook already ? If yes , then I can sync the google sheet with your google account and that should in turn sync it with your phonebook. let's get on a chat to discuss the poss Flere

$150 USD in 3 dage
(0 bedømmelser)

i wan5 to work with you

$27 USD på 1 dag
(0 bedømmelser)

I work on Google cloud every day basis . I work efficiently and able to complete the job in the given time.

$25 USD in 4 dage
(0 bedømmelser)