I need to export 100% of Zoho CRM Leads & Deals to a Google Sheet every hour, overwriting the previous data each time.

We are then using this data to make reports in Google Data Studio.

We completed this with Leads doing the following below:

Synced data from Zoho Leads to Google sheet using a specified date range (Feb 2019 - today).

For syncing we used Zoho reports rest API to fetch the data. We then inserted data into Google sheets using the Google sheet API

For this complete application we created a window application service using c# and stored this on a Google Cloud Server.

>> What I need now:

The same set up for all Deals

The same thing in a second account (extract 100% of Leads & Deals from Zoho CRM into a Google Sheet).

Clean up the first sheet. It has two issues (user names have no space between first and last name & the date range is specified and not 100% of leads. Need to go back before Feb 2019 and update the date to the date of the first lead).

Change management of all that was completed, with our internal developer reviewing and approving the changes,

Further details:

We are exporting 13 fields from Zoho, and the columns in Google Sheets will have the same titles. And the data from Zoho CRM should overwrite the data in Google Sheets each time

Skills: CRM, Excel, PHP,, Software Architecture

See more: how to import data from web to google sheet, google form to google sheet, wordpress form to google sheet, link smartsheet to google sheet, email csv to google sheet, ssrs report export to excel formatting, ifttt add to google sheet, report bug to google, how do i convert a google doc to google sheet, link google doc to google sheet, access 2010 report export to separate pdf files, export pdf to google sheet, salesforce report to google sheet, open office export to google doc, data studio export to google sheets, report problem to google gmail, wix form to google sheet, add trigger to google sheet, elementor form to google sheet, json post to google sheet

About the Employer:
( 0 reviews ) Mohali, India

Project ID: #20032199

8 freelancers are bidding on average $24 for this job


Zoho Expert : ........................... Full Zoho CRM customization Data migration Any type of Automation and notification Deluge script for Custom Functions and do automation with any module Email Templates & Inven More

$20 USD in 7 days
(3 Reviews)

Hi, I have very much familiar about google sheet . I ready to give you sample . if you satisfied then you can hire me . Regards Faisal

$25 USD in 1 day
(0 Reviews)

Hi, I am having an experience in CRM and excel so I believe that I will done the job perfectly. Thanks in advance. Shanthi Relevant Skills and Experience Hi, I am having an experience in CRM and excel so I believe tha More

$25 USD in 1 day
(0 Reviews)

Let's give a try and I need your full and clear instruction. Thank if you has chosen me. Excel speak

$20 USD in 4 days
(0 Reviews)

Just give a try Relevant Skills and Experience Have experience in excel

$25 USD in 1 day
(0 Reviews)

Hi! My name is Kate Angala and I have 10 years of experience working in fast paced environment. 6 years as a Senior Customer Service Specialist and 4 years as a Recruiting Consultant. I am looking forward in working More

$30 USD in 7 days
(0 Reviews)

Hello Dear Client Please try our services once. 100% satisfaction rate. ZOHO Expert with CRM, Books, Flow, Forms, Creator, Compaign, Google suite etc

$20 USD in 3 days
(0 Reviews)

Acrozen Aiders Pvt. Ltd. intend to pay complete attention to details and complete the project with 100% satisfaction within your Budget and Time. Our company have expert team of CFAs/ CAs/ ICWAs with good knowledge Tal More

$25 USD in 1 day
(0 Reviews)