Google Sheets Script for PDF export and email

€8-30 EUR

Завершено

Опублікований

over 6 years ago

€8-30 EUR

Оплачується при отриманні

I use a Google form to collect dozens of answers from different clients. The Google form is connected to a Google Sheet where I gather and process somehow all the answers. After that, I have one sheet that I export to PDF, name correctly and create an email to send the questionnaire result to my client. I have to do this dozen of times. And is boring and time demanding. I've seen there is a possibility to do something similar to this with Google Apps Script. For example: [login to view URL] Now... What I specifically want is... From a Google Sheet with some sheets... 1) Specify one sheet which will be exported as a single page PDF 2) Name that PDF archive depending on the value of some cells 3) Send an email with that PDF attached.

Google App Engine

ID проекту: 15134520

Про проект

3 пропозицій(-ї)

Дистанційний проект

Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@mohamedkaram93

Hi! Thanks for inviting me. I will be happy to help you with that simple one. You can have a script bounded to the spreadsheet. The script will add a custom menu. When you want to export the sheet as a pdf file, you will click the menu. The script will run, get the name of the pdf "I assume from a certain cell in the sheet that will be always fixed", then email the pdf attachment. We can also control the export options, like export the sheet as landscape or portrait. Just like the options you have when you try to download the sheet manually as a pdf file. I will be happy to offer more suggestions for you to make the process more automatic. We can develop a script that fires when the form is submitted, process the answers and do everything for you! I will be happy to address any of your questions! Sincerely, Mohamed

€25 EUR за 0 день

5,0

(8 відгуки(-ів))

4,0

3 фрілансерів(-и) готові виконати цю роботу у середньому за €22 EUR

@Viqtor

Hi, can help. Ar you using fixed number of rows or you sheet length changing. Do you have example of sheet which you want export as pdf? In email must be only attached PDF? Relevant Skills and Experience Over 100 + different scale google apps projects Proposed Milestones €29 EUR - Google Sheets Script for PDF export and email

€29 EUR за 1 день

4,8

(30 відгуки(-ів))

5,6

@aponfreelance

That's a very clear requirement, with supportive link. I could help you in further refine the code to match your requirement. At the end, you shall get a new menu in the spreadsheet, and when you click it, the required sheet shall be converted to PDF, and send to the respective email id. Something about myself, I have enough experience in Google script, which is required for this project my previous projects are almost in Google scripts. Hope we could start

€12 EUR за 1 день