How To Automatically Create And Send Salary Slips Using Google Sheets

Рет қаралды 32,169

Күн бұрын

In this tutorial we would learn:
1. How to create salary slips in PDF format using google app script.
2. How to Automate Salary slip creation process.

Пікірлер: 130

@Summer-tq7pg Жыл бұрын

Your tutorial is super easy and, at the same time, very professional. Thank you so much.

@AutomationMadeEasy Жыл бұрын

Glad it was helpful!

@jackiebananura4003 4 ай бұрын

How do you create the codes

@ismatismet6559 2 жыл бұрын

thank you its worderfull explanation i hope u make "send salary by Whatsapp" im waiting :) because ur explain its so clear for beginner like me best regards

@Nidhin89 2 жыл бұрын

Wonderful Explanation.Thank you😇

@AutomationMadeEasy 2 жыл бұрын

Glad it was helpful!

@makelifeeasy1917 Жыл бұрын

Hi, Thanks for the information. Your way of explaining is wonderful, thanks alot for the source code. : )

@AutomationMadeEasy Жыл бұрын

Glad it was helpful!

@excelwithjamessm.6468 5 ай бұрын

I love the content. Helpfull. Kudos Sir

@AutomationMadeEasy 5 ай бұрын

Glad to hear that

@faisalmalik1637 11 ай бұрын

Hi, this is really super and easy to understand tutorial, love the way of your teaching method. Sir you are awesome. Keep helping up.

@AutomationMadeEasy 11 ай бұрын

Thank you

@faisalmalik1637 11 ай бұрын

@@AutomationMadeEasy sir is there any limitations. After two days it stop working.

@faisalmalik1637 11 ай бұрын

It's not filling salary slips and showing error on sending emails.

@AutomationMadeEasy 11 ай бұрын

yes there are certain limitations. max execution time in a 24 hr window is 1 hr

@Krish9811 Жыл бұрын

Super satisfying. 🤩👍👍

@AutomationMadeEasy Жыл бұрын

Glad you think so!

@heryantobinhassan1562 2 жыл бұрын

Hi thanks for the wonderful explanation. Can you help which code I need to change if I want to generate pay slip only for the selected row when clicking the button?

@HeyTash 2 жыл бұрын

THIS IS AWESOME!!!

@AutomationMadeEasy 2 жыл бұрын

thank u

@user-ys4bm7bn4k 4 ай бұрын

Thank you so much for this sir. Thank you too for the script. I deeply appreciate you

@AutomationMadeEasy 4 ай бұрын

Happy to help

@Azizashiq 2 жыл бұрын

Thank You Sir, great information

@AutomationMadeEasy 2 жыл бұрын

Glad it was helpful!

@EFFORTSWILLSCH 4 ай бұрын

thanks so much for this tutorial its really impactful. Thanks

@AutomationMadeEasy 4 ай бұрын

Glad you think so!

@RAHULKUMAR-pm5no 11 ай бұрын

You explained complex things in a simple way. Awesome to watch and please provide me source code.

@AutomationMadeEasy 11 ай бұрын

thanks. You can find the code on the blog automationandagile

@SalAbraham7 7 ай бұрын

@@AutomationMadeEasy Where is the blog?

@AdminYAIHarja2 3 ай бұрын

thank you sir. clearly explanation

@AutomationMadeEasy 3 ай бұрын

You are welcome

@PeasOfCrab 2 жыл бұрын

Good explanations, boss - keep up the work!

@AutomationMadeEasy 2 жыл бұрын

Appreciate it!

@reggaedude111 Жыл бұрын

Hello. Is there a way to use a google sheet format instead of google doc format? Thank you.

@michaelangelosuarez8763 5 ай бұрын

Thnx is working :)

@AutomationMadeEasy 5 ай бұрын

Welcome 👍

@swaminaathanvl6517 Жыл бұрын

If explain in Tamil it is very helpful

@srishtipawar4254 2 жыл бұрын

Interesting! Could you please share the code? Or the link to download the code?

@iamhutchi Жыл бұрын

Hi, I try your tutorial, and it working perfectly fine. But I need extra options is it possible to lock/encrypt the PDF file that is attached to the email for more security? let's say use the 'empID' as a pdf password. thank you for very useful tutorial :)

@AutomationMadeEasy Жыл бұрын

It is feasible but will need lot of customization's.

@LagaIndraLesmana Жыл бұрын

Hi Thank you for your inspiring tutorial video, I already implement it to my own form but the script doesn't work :D please help me

@jaysonradibok7596 2 жыл бұрын

When it comes to the linking of the SalarydetailFolder and salaryTemplate I just want to know what is the problem if the salary slp pdf doesnt appear in the google drive folder(Salarydetailfolder)?....

@AutomationMadeEasy 2 жыл бұрын

it can be any subfolder in the google drive.

@TilakConrad Жыл бұрын

super - not only the comprehensive content but also your clear teaching style - really superb - thanks very much question - what needs to be modified in the appscript - to delete the extra pdf and the multiple "copy of salary template" that is created in this process. Hope you can advise - but thanks for the content you create.

@AutomationMadeEasy Жыл бұрын

script for remove is explained in the tutorial. Syntax given below: pdfFolder.removeFile(paySlipFile);

@TilakConrad Жыл бұрын

@@AutomationMadeEasy Thank you very much for that and sorry I explained badly - all works fine - but the script creates multiple (1 for each address) Doc files in the root of my Google Drive - called "Copy of Salary Slip Template" My "Salary Slip Template" is in my Salary_Slips folder and that is where the pdf's are created - however the "Copy of Salary Slip Template" are created in the root - I would like to have these automatically deleted - not sure what I've done incorrectly and your help is appreciated. TIA Tilak

@DibyenduR 8 ай бұрын

Its very helpful to me but I want to do this by google form when I submit the form by EmpID then script is running and One prob is removeFile property show disable

@ThanjaiThalaivaas Жыл бұрын

is it possible to create in ms excel and send in outlook mail

@mohamadsafwan4575 Жыл бұрын

Thanks 👍🙏👍

@AutomationMadeEasy Жыл бұрын

Welcome 👍

@francinehernandez1876 Жыл бұрын

Exception: Document is missing (perhaps it was deleted, or you don't have read access?)Details Dismiss I'm getting this message when I try to execute it. What am I doing incorrectly?

@user-nk8ly9iy3p 2 ай бұрын

Hi, I am very happy to see your video. I have an issues that is my total employee 5person but when I applied your code then just created pdf for one employee that is in row no 2. please help me to solve this problem.

@AutomationMadeEasy 2 ай бұрын

check your loop may be the syntax for creating final pdf is placed outside the loop

@prithvirana1958 Жыл бұрын

I mean from google doc to google sheet?

@darrelgavino6176 11 ай бұрын

Thank you! you are a genius! I tried it and it worked!

@AutomationMadeEasy 11 ай бұрын

Glad it helped!

@orlandonietolaverde4763 11 ай бұрын

Hello, do you think it is possible that if one of the fields is 0, that concept is not created in the format? For example, if the person does not have a profession tax, do not call the concept?

@AutomationMadeEasy 11 ай бұрын

definately possible but will need lot of customization

@jaimelegaspi9869 2 жыл бұрын

Hi can i have a copy of the script i cant barely see it. Thank you in advance.

@Just-the-Gameplay 2 жыл бұрын

first

@acebrianamordomingo3236 Жыл бұрын

How do you make the code create and send payslips in a recurring manner? Like monthly?

@AutomationMadeEasy Жыл бұрын

you can set up a trigger for that

@sheesh772 Жыл бұрын

how can i trigger the script in mobile? can you help me pls

@jaikumar7519 2 жыл бұрын

Please share the script code of the tutorial

@stanleymunro9829 11 ай бұрын

Hi is it possible to edit the code in the end instead of emailing it, it prints the PDF it created?

@AutomationMadeEasy 10 ай бұрын

yes just exclude the last part where mails are sent

@kankanaroy141 2 жыл бұрын

Can't find the code neither the blog . Can anyone please help me out

@MirMakarimAhsan 11 ай бұрын

Everything is working fine. But there is an issue that a copy of salary slip is automaticaly saved as doc file in the root drive folder. We have removed doc file from salary details folder but how do i get rid of it. It will be very much helpfull if you help me in this case.

@AutomationMadeEasy 11 ай бұрын

in the script it is explained , how to delete the copy of template file

@menaeem 2 жыл бұрын

Hi, Thanks for the Tutorial. Can you please share the code??

@AutomationMadeEasy 2 жыл бұрын

its on the blog automationandagile

@menaeem 2 жыл бұрын

@@AutomationMadeEasy Plz share the exact link...

@NicolaBunchuay Жыл бұрын

When I use debug code runs perfectly, however when I run in Googlesheet it shows an error message "TypeError: cannot read properties of null (reading 'getLastRow')". How can I fix this?

@AutomationMadeEasy Жыл бұрын

check ur loop. seems it is reading null rows.

@NicolaBunchuay Жыл бұрын

@@AutomationMadeEasy I have tried to check the loop but still not sure how to fix - could I email it to you?

@AutomationMadeEasy Жыл бұрын

write into info@automationandagile.com

@NicolaBunchuay Жыл бұрын

@@AutomationMadeEasy Thank you very much for your prompt reply and great code! I will email you as suggested.

@sauravbanerjee2028 2 жыл бұрын

Hey, I want to connect with you on a work, This involved automation of a website on user's manual activites. let me know if we can connect

@AutomationMadeEasy 2 жыл бұрын

sure.. write into info@automationandagile.com

@sauravbanerjee2028 2 жыл бұрын

@@AutomationMadeEasy has sent you an email.

@BhavinJoshi123 Жыл бұрын

THE SCRIPT IS RUNNING AFTER DATA FINISH AND CREATEING EMPTY SALSLIP AND THAN THIS ERROR OCCURED Exception: Failed to send email: no recipient can you Pls help me here to stop script to run once cell are empty in G sheet

@AutomationMadeEasy Жыл бұрын

need to see ur script

@BhavinJoshi123 Жыл бұрын

@@AutomationMadeEasy function createAndSendSalSlips() { var empName=""; var empEmail = ""; var empDesg=""; var noOfPayableDay=0; var salMonth_Year=""; var basicSal=0; var trainSal=0; var attendanceAllowence=0; var incentives=0; var proffTax=0; var dNachBounce=0; var grossEarn=0; var totalDeduction=0; var netPay=0; var spSheet = SpreadsheetApp.getActiveSpreadsheet(); var salaryDetailsFolder = DriveApp.getFolderById("1-fvE_wRpEO25guMUyyYrsqbi5j28lcnS"); var salaryTemplate = DriveApp.getFileById("1WjNZgR93i4HBCF82P2XLGrtca38vBm0NXTXxxm20msQ"); var totalRows = spSheet.getLastRow(); for(var rowNo=6;rowNo

@dlodindigul5196 Жыл бұрын

the website you told was not available please enable to download the script sir

@SanviPatil2019 2 жыл бұрын

hi sir.. maine yeh code sub barobar copy paste kiya mere google sheet me.. but meri file jis folder me pdf banke aa rahi hai.usme koi bhi salary ki details nhi aa rahi hai.. salary template waise ki waise hi pdf ban ke aa raha hai. empid_xxxxx, empname_xxxxx, isme name value nahi aa rahi hai..help.me.. aur word file folder ke bahar ban rahi hai..

@AutomationMadeEasy 2 жыл бұрын

script meh folder id aur template ka id check karo.Kuch chhoti mistake hogi jisse se process theek se nhi ho raha.

@SanviPatil2019 2 жыл бұрын

@@AutomationMadeEasy dono id right hai. per values replace nahi ho rahi hai

@michaelangelosuarez8763 5 ай бұрын

hi the copy template is deleted in salary folder but in the copy template is automatic in my drive. how this happen

@AutomationMadeEasy 5 ай бұрын

it may be in your trash folder of your drive

@SanviPatil2019 2 жыл бұрын

sir please mujhe mere computer me yeh code ki settings karke do. mere pc me pdf file me kuch bhi changes nahi ho rahe he... file send ho rahi hai..but usme koibhi changes nahi ho rahe

@AutomationMadeEasy 2 жыл бұрын

write into info@automationandagile.com

@jenniferflores4433 Жыл бұрын

What if I want a meesage prompt first "Are you sure you want to send payslips" Yes/No. Can you show me how, please?

@AutomationMadeEasy Жыл бұрын

let me check

@EFFORTSWILLSCH 4 ай бұрын

thanks sir for the video, but pls i need to solve this "Exception: Failed to send email: no recipient"

@AutomationMadeEasy 4 ай бұрын

check the variable which is storing email id of the recepient

@faisalmalik1637 11 ай бұрын

Sir, is this possible we can send all email through outlook. If yes then please guide me. Thanks

@AutomationMadeEasy 11 ай бұрын

Certainly possible, refer below tutorial: kzfaq.info/get/bejne/brdpebuU0MqudqM.html

@faisalmalik1637 11 ай бұрын

@@AutomationMadeEasysir I have watched your refer video. But it's not working in Google sheets script. Also unable to add signature

@AutomationMadeEasy 11 ай бұрын

Above link I shared is for excel and outlook not google sheets.

@issacndlongwane7575 2 жыл бұрын

What to do if line 32 of the code is coursing an error in the code??

@AutomationMadeEasy 2 жыл бұрын

Can you share your script

@NicolaBunchuay Жыл бұрын

Do you have a solution I have the same problem but not in debug only when run in Googlesheets

@user-iy8wg9su6e 10 ай бұрын

Can we get a copy of this?

@AutomationMadeEasy 10 ай бұрын

you can find the script on the blog automationandagile

@JieTeves Жыл бұрын

Can i buy this?

@AutomationMadeEasy Жыл бұрын

share your contact info or write into info@automationandagile.com and I will help you to create a customized solution for your requirements

@FBTS-HR 6 ай бұрын

hi can i ask for the script?

@AutomationMadeEasy 6 ай бұрын

its on the blog automationandagile.com

@user-zn9tq1gc9j 3 ай бұрын

how to create that send button please reply...

@AutomationMadeEasy 3 ай бұрын

Click Insert - Drawing - Click Shape. Select shape, On the top right corner of shape click the 3 dots assign script and paste the name of function in app script

@prithvirana1958 Жыл бұрын

How did you move your template to google sheets?

@AutomationMadeEasy Жыл бұрын

template is created using google docs. The code is using the google doc template to generate the pay slips

@backofficearchtech6250 6 ай бұрын

make copy thing is not working for me..help me

@AutomationMadeEasy 6 ай бұрын

need to see your code

@mittalraghav13 Жыл бұрын

Can we send like this on wahtsapp also

@AutomationMadeEasy Жыл бұрын

unfortunately no

@rushrush6754 2 жыл бұрын

Share copy of file so we can play with

@AutomationMadeEasy 2 жыл бұрын

Entire code is available on the blog

@rushrush6754 2 жыл бұрын

@@AutomationMadeEasy link in description???

@user-sm1dv1km8g 29 күн бұрын

i can't find the script can you please send me

@AutomationMadeEasy 23 күн бұрын

you can find it on the blog automationandagile.com

@mohdsalihin6474 2 жыл бұрын

Can share the code please?

@AutomationMadeEasy 2 жыл бұрын

its on the blog

@fahadmunir5426 2 жыл бұрын

@@AutomationMadeEasy Where is the blog?

@teachinfolk Жыл бұрын

Please send me source code?

@vapcabs Жыл бұрын

Exception: The parameters (DriveApp.FolderIterator) don't match the method signature for DriveApp.File.makeCopy. createAndSendSalSlips @ Code.gs:85 I'm getting this error can you help me out