Đã Hủy

Updating Google Contacts from Google Sheet

Hello,

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

Watchouts:

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

Kĩ năng: Google App Engine, Javascript, Scripting, Process Automation, Active Directory

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Warsaw, Poland

ID dự án: #20848730

9 freelancer đang chào giá trung bình $36 cho công việc này

sangeethDeshal

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

$10 USD trong 7 ngày
(2 Nhận xét)
2.3
kashyapdeep422

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 Thêm

$10 USD trong 20 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
0.0
emd08673

Hi.i am interested in your work

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
alishababa3417

I want this urgenr

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
bujjiadi5

Heerfgh

$24 USD trong 1 ngày
(0 Nhận xét)
0.0
PankajTheGreat

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 Thêm

$150 USD trong 3 ngày
(0 Nhận xét)
0.0
thetigris3

i wan5 to work with you

$27 USD trong 1 ngày
(0 Nhận xét)
0.0
SravanthiAnumako

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

$25 USD trong 4 ngày
(0 Nhận xét)
0.0