Open Calls log

Instructions
About the app
Developer: kaspar@crewnew.com (Contact if you want similar solution or source code

Google Spreadsheet -> MySQL and HubSpot and Google Contacts

UserDateTimeDirectionPhonePrefixFirst nameLast nameCompanyDurationNo ReplyTagsNotesVoice recordsAction
8824/10/201813:15Incoming
C8PeterEzeaFipeDigital0:09:190:00:00CN-LeadSend information about ApiatoExists in DB
8824/10/201815:32Outgoing
A8AllanTeetlausHelindusTeenused.ee0:01:110:00:00PT-LeadTahab erinevaid musti 3x3m vaatama tulla. Helistab ette.Exists in DB
8824/10/201819:30Incoming
A8GajaliVeerojaEraisik0:02:410:00:00PT-LeadTahab kaubikut järgmine nädalExists in DB
8824/10/201821:50Missed
C7HarriReiliEcommerceMarketing0:00:000:00:00CN-ContactAdd 1GB RAM at DOExists in DB
8825/10/201816:49Incoming
A8AnuTaalEraisik0:04:590:00:00PT-LeadTahab garaaziExists in DB
8826/10/201813:38Missed
A8AnuTaalEraisik0:00:000:00:00Exists in DB
8826/10/201815:36Incoming
A8AnuTaalEraisik0:11:520:00:00PT-LeadExists in DB
8831/10/201815:12Missed
0:00:000:00:00CN-LeadExists in DB
885/11/201812:05Missed
A8AllanTeetlausHelindusTeenused.0:00:000:00:00PT-LeadExists in DB

Contacts HubSpot -> MySQL

vidOffset:0 (last offset: 18601)
No new contact to import from HubSpot
200 OK

Instructions

Save contacts to phone in this way: PREFIX[space]FIRST_NAME[space]LAST_NAME[space]COMPANY_NAME. Prefix is just to separate different contacts and maybe have the last number of the year when the customer first contacted.

About the app

  1. After each call data is collected by Android Open Calls app.
  2. We read and modify data from Google Spreadsheet
  3. We save new data in MySQL for own CRM that isn't there already.
  4. Sync call data with Hubspot API
  5. Sync contacts with Google Contacts
  6. Other team members see who's calling and previous call/email/chat history with this number:)
  7. Some other user cases than HubSpot/SQL/G-contacts integration>>
  8. (Sync and update is done in every 3 minutes)