Google Sheets Script for PDF export and email

€8-30 EUR

Suoritettu

Julkaistu

yli 6 vuotta sitten

€8-30 EUR

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 15134520

Tietoa projektista

3 ehdotukset

Etäprojekti

Aktiivinen 7 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@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 päivässä

5,0

(8 arvostelua)

4,0

3 freelancerit tarjoavat keskimäärin €22 EUR tätä projektia

@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 päivässä

4,8

(30 arvostelua)

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 päivässä