In Progress

Google Spreadsheet & Docs Expert

We require the assistance of a Google Sheets/Docs expert to assist with the amendment of pre-existing Sheets and creation of a new process integrating Google Docs, Drive and Sheets.

It is difficult for me to elaborate ALL of the functions and work to be involved, however as a quick summary I can say the following:

- We use various Google Sheets to keep track of monthly sales data which we manually input

- A 'sale' in our industry is a lead who has converted into a paying consulting client

- We want to be able to automate the process of once a lead converts into a paying client that a few things happen:

1. The sheets transfer data from one to another where required

2. A unique client folder is created in a shared Google Drive with certain blank templates saved to that folder

3. We need to be able to generate receipts/invoices for each unique client using Google Doc templates

4. You need to be fully knowledgeable in Sheet formulas and the creation of rules/triggering data across one area to another

5. You need to know how to set up conditional formatting/colour coding

6. I expect this to be a project that requires maybe 10 hours of developement initially, plus spending about an hour or two discussing the project on a call.

7. I expect this to be an on-going relationship/work as we will continue to develop our Google Sheet/Doc process until it becomes most likely our replacement CRM

Skills: Excel, Data Entry, Data Processing, Visual Basic, Microsoft

See more: php mysql data google spreadsheet, google spreadsheet functions manual, google maps api expert, google spreadsheet data entry, salary google certified ppc expert, google finance google spreadsheet, google map api expert, php form google spreadsheet, google apps docs forms invoice, use google spreadsheet access table, google maps javascript expert, google base api expert, synchronize google apps docs desktop, google spreadsheet expert, google script form spreadsheet docs calendar, google spreadsheet google docs, google spreadsheet in google docs, docs google >/ spreadsheet, google spreadsheet to crm, google docs google spreadsheet

About the Employer:
( 21 reviews ) Kangaroo Point, Australia

Project ID: #21365480

Awarded to:

KulfiSoftwares

Google Apps Script expert!! I can write script for Google spreadsheets/docs/calendar.. I have read your project description thoroughly and believe to be perfect for the job. I only bid on projects, I am sure to impress More

$20 AUD / hour
(327 Reviews)
7.6

23 freelancers are bidding on average $19/hour for this job

ponnarasiBabu

I read and understood your requirements and would like to have a look at the pre-existing spreadsheets to assess the work. So i hope you would open a PM to discuss about the work . Regards, Ponsi

$25 AUD / hour
(425 Reviews)
7.5
zekovicm

Hi there,I am Google sheets expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within th More

$25 AUD / hour
(136 Reviews)
7.3
polarjin2017

Hello? How are you? I am excited to work with you on Google doc, Google spreadsheet and PPT api. So I think I can help you if you want. [login to view URL] This is what i have done in google script with a More

$25 AUD / hour
(102 Reviews)
6.7
kalidas365

Hello, Thanks for posting suitable project as per my skill. I am having 10 yrs similar experience and handled thousands of projects. I have reviewed your requirements well and ready to start the project with 100% acc More

$15 AUD / hour
(241 Reviews)
6.4
Bhawnakul9

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$15 AUD / hour
(116 Reviews)
6.2
mateenbhatti94

Dear sir I will be able to create a automate process that will do these 7 functions whenever a lead converted into a paying client. I have been in this industry for 1 year and such jobs are my daily practice. I can as More

$15 AUD / hour
(78 Reviews)
6.2
furqanahmed55

Hello, I am an expert at Google spreadsheets and maintaining and creating new data entries. I am a top rated freelancer in this category and have a lot of experience with similar projects. I am very well equipped in w More

$15 AUD / hour
(8 Reviews)
5.9
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$22 AUD / hour
(103 Reviews)
6.2
bhupendrayadav

I can develop a google spreadsheet (using java script programming) based CRM system to manage your clients with integration of google doc to generate invoices and other reports. Please find below a brief introduction o More

$25 AUD / hour
(33 Reviews)
5.2
sg11513

Hi ! Greetings! I have gone through your project requirements and interested to do this job as my skills and work experience match your requirements. I am ready to do small sample so that we can share same understa More

$15 AUD / hour
(24 Reviews)
4.8
AymunSaif

I will start right now. I am expert of this ...........................................................

$15 AUD / hour
(16 Reviews)
3.6
rickytondan

Hey i saw your proposal and it seems great to me i have 5+ year experience in data administrative work field .kindly share your work details looking forward to work with you.

$16 AUD / hour
(1 Review)
2.2
corporatessc

CRM + Google Spreadsheet + Google Apps Script Hi There, I have understood your requirement of CRM type functionality Google Docs, Sheets and Drive using google apps script and smart formulas. I am a Google app scr More

$15 AUD / hour
(1 Review)
2.4
waqarakram

Hi mate, “HIGH QUALITY AND FAST DELIVERY IS PROMISED “ I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my More

$15 AUD / hour
(4 Reviews)
1.1
saubhagyamweb

Hello, We're SAUBHAGYAM, a Web and Mobile App development company based in India. We've industry proven expertise in developing trendy, innovative websites using OOP, Core PHP, Laravel Framework, CodeIgniter PHP Fram More

$15 AUD / hour
(0 Reviews)
0.0
bp00053

Have 5 + years experience on Data Analysis and Data Entry. Expert on Excel (formulas,formatting,vlookup etc) sql and Access. The projects you offered are really similar with what I did at current work

$20 AUD / hour
(0 Reviews)
0.0
charmrhia

Hi Im very much willing to help you, i was working as a admin assistant before for allost 3 yrs so your need in work is already meet my skills. Please inform me immediately help you.

$27 AUD / hour
(0 Reviews)
0.0
KhawarKhan101

Hello Dear, I am skilled Data Entry Expert with extensive macro creating and conditional formating skills which are needed to automate your work. I would Like to give you FREE Trial work. Contact me Relevant Skills More

$16 AUD / hour
(0 Reviews)
0.0
zishanjavaid7861

Dear Hiring Manager, I am a professional in market research and lead generation. I have great experience in lead generation, database building, web scraping, company information, LinkedIn scraping, and google docs. I f More

$15 AUD / hour
(0 Reviews)
0.0
jafarsadek

I am very much interested to work on your project. I am well in English. I have very fast internet (50 MBPS) and very fast computer with two screens/monitors. I am super fast at typing(40 words per minute) I am a profe More

$20 AUD / hour
(0 Reviews)
0.0