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 [login to view URL]'.
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
4 freelancers are bidding on average $147 for this job
Where you want run the code? server or local? Please send me details. ......................................... Stay tuned, I'm still working on this proposal.