Script specification for invoices
A script needs to be created for Google Sheets (apps script) to generate invoices according to the template.
How the script works:
The user selects a range (active range)
The script reads the data (invoice number, client, date, contact, amount
Then the script reads the invoice items in the form of a table
The user clicks a button (custom button "generate invoice".
The script generates the invoice in PDF format based on the template and this data and saves it in a specific folder on Google Drive. Signing: Invoice, Client, amount, date, number

Important!!! The data in the table may exceed that in the template, so automatic expansion of the table in the final file should be provided

I will insert the link to the template and folder myself. The template and the table from which the data should be taken are attached

Template https://docs.google.com/spreadsheets/d/10e4dCEapveBzchIpWlmXoaHQ9bNeaJBaWfJNrqvksjs/edit?usp=sharing

Table https://docs.google.com/spreadsheets/d/1TA2v_b9t-QSd-6ro-FoZmjdMfygBwoXgJcXXYEgHm4I/edit?usp=sharing

Proposals 4 Withdrawn 1 Rejected 1 Discussions 1

Nestor Andruschak

0 0

Projects -
Rating -
Rating 378

Budget: 1000 UAH Deadline: 2 days

Good day, I created a script for auto-filling contracts based on data from the database, so I have a ready tool that just needs to be adjusted for the account.
Here’s how it will look:
1. The invoice template will be created in Google Docs
2. The script takes data from the table and inserts it into the corresponding cells of the template
3. The finished PDF invoice is saved on your Google Drive.

The deadline is 1-2 days (depending on the start time of work)
I will be happy to collaborate.

Vladislav S.

102 0

Budget: 1200 UAH Deadline: 1 day

Hello! I will be happy to help. I will complete everything quickly and efficiently! Feel free to reach out!

Anton T.

345 0

Budget: 1200 UAH Deadline: 3 days

I automated the generation of invoices for Excel; it is also possible to do this in Google Sheets.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Bogdan Stislo

17 0

Budget: 3000 UAH Deadline: 2 days

Good day!
I can implement the task, but I would like to clarify some points. For example, what area is selected with the mouse? Maybe it would be better to use checkboxes to select the necessary positions?

Oleksandr Zabolotsky
Ukraine

Projects 18
Rating 5.0
Rating 742

Script for Google Sheets

Client's review of cooperation with Yurii Apostol

Script for Google Sheets

5.0

Oleksandr Zabolotsky

Freelancer's review of cooperation with Oleksandr Zabolotsky

Script for Google Sheets

5.0

Yurii Apostol

Nestor Andruschak

Vladislav S.

Anton T.

Proposals are currently absent

Proposals concealed

Bogdan Stislo

Current freelance projects in the category Javascript and Typescript

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.

Development of a Tampermonkey script for automating responses in the internal CRM via the OpenAI API.