ZOHO CRM для бизнеса
ZOHO CRM для бизнеса
Внедрение, обучение, интеграция приложений ZOHO

Google Sheets Sync for ZOHO extension

Need to integrate Zoho CRM with Google Sheets? Push your Leads, Contacts or any other information to Zoho CRM with a few clicks! The extension works with selected by user Zoho CRM modules.

4 easy steps to set up Google Sheets Sync for Zoho Extension:

1.Install the Extension. Specify Zoho CRM access token. 

2.Create and add service account Google Sheets 

3. Add link to Google Sheets

4. Sync the Leads from Google Sheets to your Zoho CRM.


How to synch data from Google Sheets to CRM:

1. Specify token - https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCRM%2Fcrmapi&DISPLAY_NAME=googlesheets

2. Create Service account Google Sheets :

- follow the link - https://console.developers.google.com

- Create a new project.

- Click Enable API. Search for and enable the Google Drive API.

- Create credentials for a Web Server to access Application Data.

- Name the service account and grant it a Project Role of Editor

- Download the JSON

Short video instructionhttps://s3.amazonaws.com/com.twilio.prod.twilio-docs/original_images/google-developer-console.gif

3. Upload the JSON into Settings, field Service account Google Sheets

4. To start downloading, enter the Goggle Sheets link (Note! Open access to the Google Sheet - Anyone who has the link can access), then click on Next button.

5. Select the name of the Sheet.

6. Select the name of the module to which the data will be loaded.

7. Match the google sheet import fields with the data in Zoho CRM.

8. Select the option, «Download now» or  «Add to Task Scheduler» option to load the data on a schedule.

9. Save the settings.

All the data will be saved in chosen Module

The extension:
• Maps all custom fields in Google Sheets
• Supports campaigns sync 
• Supports scheduled sync 
• Syncs up to a hundred leads per one API request

Google Sheets Sync for ZOHO FAQ

How can I obtain ZOHO API Token?
Open https://accounts.zoho.com and make sure you are logged in. 
Copy and open the link in browser, or press on it https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCRM/crmapi&DISPLAY_NAME=googlesheets