Script for Google Sheets
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
Client's review of cooperation with Yurii Apostol
Script for Google SheetsGreat performer, very responsible work! I recommend for collaboration.
Freelancer's review of cooperation with Oleksandr Zabolotsky
Script for Google SheetsEverything is great. I am happy to continue working with Oleksandr and I recommend him to others.
-
426 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.
-
4467 102 0 Hello! I will be happy to help. I will complete everything quickly and efficiently! Feel free to reach out!
-
5911 345 0 I automated the generation of invoices for Excel; it is also possible to do this in Google Sheets.
-
981 17 0 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?
-
500 грн ?
-
Current freelance projects in the category Javascript and Typescript
Fix the CSS/DOM layout of cards in the Chrome extension for localizing D&D BeyondThere is a Chrome extension Manifest V3 that localizes the D&D Beyond website into Ukrainian. The project is written in TypeScript + WXT. The extension works through a content script: it finds English text on D&D Beyond pages and replaces it with the Ukrainian translation. The… HTML & CSS, Javascript and Typescript ∙ 9 hours 51 minutes back ∙ 22 proposals |
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5770 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 18 hours 51 minutes back ∙ 83 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 1 day back ∙ 17 proposals |
Commercial on-premise video communication platform "ViM"It is required to develop an on-premise video conferencing system with a basic calculation for 100 simultaneous connections (10 isolated rooms of 10 people each). The platform should have a built-in architecture for future horizontal scaling up to 1000 users by adding new media… Javascript and Typescript, Web Programming ∙ 1 day 19 hours back ∙ 28 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 2 days 23 hours back ∙ 18 proposals |