Đã hoàn thành

Automatically generate Google Docs Packing List from Sheets data

Please help improve the workflow of Cyntony Corp by coding a replacement for a manual packing list generation process that presently uses MS Word, with a new Google Apps Script approach.

I already made a Zapier automation to push data from new Freshbooks invoices into a 'Packing List Data' Sheets file that lives on my Google Drive. (an .xlsx example of 'Packing Data List' is uploaded). New rows are populated for each line item from the invoice. Column headers describe information in the rows that are unique to each invoice or each line item.

The project is to create a script the will become part of a Google Docs file formatted like 'Automated Packing List Template' (an .docx example of Automated Packing List Template' is uploaded) to place the values of cells from the latest 'Packing List Data' Sheets rows into the 'Automated Packing List Template' Docs in the appropriate places. Note that 'Packing List Data' header names correspond to entries with $$ before each header name in the 'Automated Packing List Template'.

The only tricky part is filling the packing list table with info from 'Packing List Data' so that the final product looks like the uploaded 'Packing List [url removed, login to view]'.

The 'Automated Packing List Template' will reside in my Google Docs account and be able to execute the Google Apps Script to populate the template with the latest 'Packing List Data' from Sheets

Kĩ năng: Javascript

Xem nhiều hơn: generate google doc from spreadsheet, populate google doc from spreadsheet, script for generating google documents from google spreadsheet data source, generate google doc from google form, mail merge google sheets to docs, google spreadsheet to google doc, google apps script to fill in a document template with spreadsheet data, google apps script create document from template, google docs stock data, google docs chart extract data, data entry google docs, google docs data entry spreadsheet, google docs data entry, google docs base data, google docs data entry form, php automatically generate list files, php form data google docs, post form data google docs, graphic design price list product data sheets, automatically generate marker google map

Về Bên Thuê:
( 1 Nhận xét ) Lexington, United States

ID dự án: #15969012

Được trao cho:


Hi there, We can develop a Google Script and bound it to the packing list data spreadsheet. Then we can either run the script manually using a custom menu added to the spreadsheet interface Relevant Skills and Experi Thêm

$138 USD trong 3 ngày
(19 Đánh Giá)

5 freelancer đang chào giá trung bình $138 cho công việc này


Where you want run the code? server or local? Please send me details. ......................................... Stay tuned, I'm still working on this proposal.

$140 USD trong 2 ngày
(10 Nhận xét)

Hello I can do that Relevant Skills and Experience javascript Proposed Milestones $155 USD - work done

$155 USD trong 3 ngày
(4 Nhận xét)

Hi, Reading your job description, I see you are looking for a developer proficient in software development for your requirements. I am a senior full-stack developer having 9 years of experience in developing projects Thêm

$155 USD trong 3 ngày
(0 Nhận xét)

Hey! I'm RICH PROGRAMMER I've reviewed your complete job description. I have more than 15 years of experience in this field. if you will respond me then I will be able to explain my skills. Relevant Skills and Expe Thêm

$100 USD trong 3 ngày
(0 Nhận xét)