Automated Document Creation Using Google Apps Script

$ 50.00 USD
We are looking for an experienced Google Apps Script developer to help us create an automated document from google sheets data.

The steps we want automated are as follows:

Generate a Google Document from a template document and populate it with some data from a Google sheet.

As well as inserting relevant fields there will be sections of the document that will be conditional upon the data in the Google Sheet...in other words sections may be included or omitted depending on the Google Sheets data.

The template document will include both text and images and again the inclusion of images will be conditional upon the data in the Google Sheet.

The workflow we want to automate is as follows.

Whenever a row gets added to a Google Sheet, automatically generate a document using this data.

Once the document is created save it as a pdf.

Save this pdf to Google Drive.

Email the pdf as an attachment to the relevant person.

Please only respond to this job if you are well versed with google apps script and have experience using it with google docs.

We anticipate that this job will be followed by more in the future so we are looking to build a long term relationship.

Similar Freelance jobs:

Create Google Doc From Template And Data From A Google Sheet.
In this folder are some Google Doc templates and a Google sheet. Complete the templates using data in the Google Sheet. https://drive.google.com/drive/folders/16ntcLYbSWTl-_90NixWVji8mEV0rvVOd?usp=sharing I will give the freelancer a non-public version of this document folder as this one is a public copy to allow freelancers to look over the source documents. The cell numbers in the template documents show where the data is to be taken from in the Sheet and inserted into Google template and saved as a new doc…
Full Description of Create Google Doc from template and data from…
Add A Schedule From Google Sheets Into Calendar (automatic)
Hello, I need someone expert on google sheet and google calendar in order to create on a google sheet a schedule that will create schedule into google calendar. The process is already explained here : https://cloud.google.com/blog/products/g-suite/g-suite-pro-tip-how-to-automatically-add-a-schedule-from-google-sheets-into-calendar I have created the google sheet already. please apply of you have reference with google suite dev. thank you doc: https://docs.google.com/spreadsheets/d/1HSnejny815cQNR-z2tjNvXANIvGDIOFbTDJb5R9Mh2o/edit#gid=0
Full Description of Add a schedule from Google Sheets into Calendar…
Push Data From Pipedrive To Google Data Studio
We need someone who would create a connection via API in order to push our Pipedrive Data to Google Data Studio. Ideally using Python. Finally it should look like a dashboard.
Full Description of Push data from Pipedrive to Google Data Studio
Programador Android Studio Kotlin Exportar Sqlite Excel O Google Sheet
En resumido, cuento con una app que almacena datos en SQlite Quiero poder exportar esos datos a una hoja de calculo de excel o google sheet
Full Description of Programador Android studio kotlin Exportar SQLITE excel o…
Google Data Studio Help
Want to build a forecasting tool. Can do a lot of the heavy lifting myself, but need some help with formatting the data in Google Sheets Need some help
Full Description of Google Data Studio Help
Google Slides Automate Powerpoint Presentation Using Google Apps Script
Hello Freelancers! I am looking for somebody with Google Slide Presentation Automation skills. I need to automate data inputs on the slides and directional arrows(color changing Red/Green). The Data will be coming from Google Slides. Python code can be implemented but need someone with Javascript experience to work with Google Apps Script. Here is code documentation: https://developers.google.com/slides/api/quickstart/apps-script Looking to complete project ASAP (24-48 hrs) for code logic and implementation. I can walk through project details and will create step-by-step documentation.…
Full Description of Google Slides Automate PowerPoint Presentation using Google Apps…
Create Google Doc From Template And Pull Data From A Google Sheet With Google App Script (gas).
In this folder are the Google Doc templates and a Google spreadsheet called: Source Data - Populated. Create the Google App Script (GAS) code in the spreadsheet to complete the google doc templates in the same folder, which are called: CLAIM TO EXEMPT GOODS - Witness Statement Notice-of-Claim-To-Exempt-Goods-CPR85.8 Draft Order Here is a copy of the folder containing the documents: https://drive.google.com/drive/folders/1WLnAXAlgg1fC0bjTQHF4joJQLFSMixq0?usp=sharing The assignment: Create the GAS code in the spreadsheet, make copies of each of the three Google docs and…
Full Description of Create Google Doc from template and pull data…
Add Fifo And Other Formulae To Google Sheet
Need two formulas added to this spreadsheet on google sheets implementing FIFO cost base in a single formulae. No other columns to be added to help the formulae. Also require a formula to calculate the amount that has been held for over a year if any. https://docs.google.com/spreadsheets/d/1DpxFYtUoqNb7hu1rR_1UGFRCITZMxYmb4muyU5KSjlg/edit
Full Description of Add FIFO and other formulae to google sheet
Help With Deploy Code In Serverless Google Cloud Angular +firebase
Need some help to guide our devloper how to with deploy code in Serverless of google cloud angular +firebase there is also opption for bigger project of 2 month full time after
Full Description of help with deploy code in Serverless google cloud…
Save Images Send By Wh To Google Drive And Tag Customer In Keap
We are using Whatsapp as a main channel and we use chat-api.com for the automation and respond.io as messaging platform. Our request is to be able to save photos shared by customers over whatsapp in a google drive and then tag that customer in Keap. We want to have a small script written on our server to check new messages in some interval (like every 1 hour) and put files from new messages to Google Drive and tag customer by…
Full Description of Save images send by WH to google drive…
Google Sheet Formula
Currently, the user is choosing the objective on a drop-down and I'm manually typing the CPM. What you need to do is formulate the CPM based on the chosen objective's predefined CPM. Add $2 on CPM if a column says yes. Conditional formatting for Gross Cost and CPM, if CPM is $28 above, gross cost should be equal to or greater than $15k Please send related sample Google sheet works.
Full Description of Google Sheet Formula
Google Sheet Formula
Currently, the user is choosing the objective on a drop-down and I'm manually typing the CPM. What you need to do is formulate the CPM based on the chosen objective's predefined CPM. Add $2 on CPM if a column says yes. Conditional formatting for Gross Cost and CPM, if CPM is $28 above, gross cost should be equal to or greater than $15k Please send related sample Google sheet works.
Full Description of Google Sheet Formula
© 2006 — 2024 hirelancer.com is an affiliate website, listing the freelance projects. We are collaborating with other sites like getFreelancer.com. Feel free to bid on any project and good luck! You will need register first, before bidding or posting projects. Basic memberhsip is always free. We might earn commissions from referring you. You will never ever pay additional fees for we referred you.