How to Generate & Print Salary Slips Every Month for Employees from Google Sheets Using Pabbly Connect

Learn how to automate the generation and printing of salary slips for employees using Google Sheets and Pabbly Connect. Follow our step-by-step tutorial! Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Salary Slip Automation

To generate and print salary slips every month for employees, you will first need to set up Pabbly Connect. This powerful automation tool allows you to connect various applications seamlessly. Start by creating an account on Pabbly Connect and logging into your dashboard.

Once logged in, you can create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow something like ‘Automated Salary Slip Generation System’. This step is crucial as it sets the foundation for automating the entire process.

2. Creating Google Sheets for Employee Details

Next, you will need to prepare a Google Sheets document containing your employees’ salary details. This sheet will serve as the data source for generating salary slips. Ensure that you include necessary columns such as employee name, email, mobile number, designation, department, and salary.

• Create a new Google Sheet and name it ‘Employee Salary Sheet’.
• Add columns for Name, Email, Mobile, Designation, Department, and Salary.
• Fill in the details for each employee in the respective columns.

This Google Sheet will be connected to Pabbly Connect, allowing it to fetch employee data automatically during the salary slip generation process.

3. Scheduling the Automation in Pabbly Connect

After setting up your Google Sheets, go back to Pabbly Connect to schedule the automation. You will need to set a trigger that specifies when the salary slips should be generated. Click on the trigger option and select the ‘Scheduler’ app.

Choose how often you want to run your workflow (e.g., once a month) and set the specific date for generating the salary slips. For example, you might select the 31st of each month. Make sure to set the time in UTC format to ensure it runs at the correct time.

4. Generating Salary Slips Using Google Docs

To create the actual salary slips, you will need to connect Google Docs to Pabbly Connect. Prepare a template in Google Docs that includes variable tags for each employee’s details (e.g., name, salary). This template will be filled with data from the Google Sheet.

In Pabbly Connect, add a new action step and select Google Docs. Choose the ‘Create Document from Template’ action. Connect your Google Docs account and select the template you created. Map the employee details from the Google Sheets to the corresponding fields in the template.

5. Printing the Salary Slips Automatically

Finally, to print the generated salary slips, you will need to connect a mobile printing application, such as Easy, to Pabbly Connect. After generating the salary slips, you can create a shareable link for each document in Google Drive.

Connect Easy to Pabbly Connect and select the ‘Print File’ action. Map the PDF link generated from Google Drive to the printing application. Configure the print settings as per your requirement, and your printer will automatically print the salary slips on the scheduled date.

Conclusion

Using Pabbly Connect, you can automate the generation and printing of salary slips for employees effortlessly. This process saves time and reduces manual errors, ensuring that salary slips are printed accurately every month.