Scripts to connect Quickbooks Desktop to Google Sheets in Real-time

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

Hello,

Please see the below description of what is required by means of scripts in Google Sheets to retrieve information from Quickbooks Desktop (Enterprise edition.)

1) Auto populate Work Order information in Google Sheets

When a Work order is created in Quickbooks Desktop automatically create an entry in Google Sheets including the information below:

i. Work Order Number

ii. Customer Name

iii. Due Date

iv. Item Name

v. Item Description

vi. Item Quantity

When Work Order is Closed in Quickbooks, remove from Google Sheet.

2) Auto populate Work Order information in Google Calendar

When a Work Order is created in Quickbooks Desktop automatically create an entry in Google Calendar using the associated due date and information below:

i. Work Order Number

ii. Customer Name

iii. Due Date

iv. Item Name

v. Item Description

vi. Item Quantity

3) Auto populate Item information in Google Sheets

When a new Item is created in Quickbooks Item List automatically populate Google Sheets with the information below:

i. Item Name/Number

ii. Item Description

iii. Bill of Material Item(s)

iv. Bill of Material Item Quantity

Thanks

JavaScript

Project ID: #12009471

About the project

8 proposals Remote project Active 7 years ago

8 freelancers are bidding on average $632 for this job

prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i wi More

$773 CAD in 20 days
(5 Reviews)
4.7
mdkass

Hello, I have good Google apps script experience and looking to work on your project. I can do a small desktop application + a Google web app The small desktop application will get the updates on the quickbook db, More

$593 CAD in 7 days
(9 Reviews)
4.3
RubyOnRail

Hi,I have gone through your project description. I could be confident if we can proceed towards more discussion. I am an individual developer and you will be working directly with me if we proceed work on this project More

$777 CAD in 15 days
(2 Reviews)
3.8
AdeelAslam4

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an More

$500 CAD in 10 days
(1 Review)
3.2
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$555 CAD in 10 days
(1 Review)
3.2
nagarajdvdg2009

Hi, I have 7 years of experience in web development. I gone through the requirment. Hope we can have more conversation Regards, Nagaraja Devadiga

$744 CAD in 10 days
(2 Reviews)
2.9
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discus More

$555 CAD in 10 days
(0 Reviews)
0.0