Replace Manual Work with Smart Logic 🔄

Learn how to automate tasks and replace manual work with smart logic using Pabbly Connect to integrate Google Sheets, Google Docs, Gmail, and Google Drive.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start replacing manual work with smart logic, open a new tab and navigate to Pabbly Connect by searching for Pabbly.com/connect. This platform is essential for automating workflows efficiently.

Once on the Pabbly Connect page, you will see options to sign in or sign up for free. If you are new, click on the ‘Sign Up Free’ button to create an account. Existing users can simply sign in. After logging in, click on the ‘Access Now’ button to enter the Pabbly Connect dashboard.

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘+ Create Workflow’ button. This will prompt you to select a workflow builder. Choose the ‘New Beta’ version for an enhanced experience. Name your workflow as ‘Replace Manual Work with Smart Logic’ and select a folder for organization.

After naming your workflow, click the ‘Create’ button. Your workflow is now created. The next step is crucial as it involves setting up a trigger. Click on the plus icon to select your trigger application, which in this case will be Google Sheets.

• Select ‘Google Sheets’ as the application.
• Choose the event as ‘New or Updated Spreadsheet Row’.
• Click on the ‘Connect’ button to establish the connection.

Once connected, a webhook URL will be provided. Copy this URL to link your Pabbly Connect account with Google Sheets.

3. Configuring Google Sheets with Pabbly Connect

Now, open your Google Sheets account where you maintain employee service records. Click on the ‘Extensions’ menu, then select ‘Pabbly Connect Webhook’, and proceed to ‘Initial Setup’. Paste the copied webhook URL into the designated field.

Next, specify the trigger column, which is the final data column where you enter information. For this example, enter ‘K’ as the trigger column. Click on the ‘Send Test’ button to verify the connection. You should see a success message indicating that test data was sent successfully.

• Ensure that the trigger column corresponds to the correct column in your Google Sheets.
• Confirm that you receive a new response in Pabbly Connect after the test.

Once confirmed, your Google Sheets is now successfully integrated with Pabbly Connect.

4. Creating Documents via Google Docs

Next, we will set up the action application as Google Docs to create experience letters. Click on the plus icon again and select ‘Google Docs’. Choose the event as ‘Create Document from Template’. Click on ‘Connect’ and select ‘Add New Connection’. Sign in to your Google account to establish the link with Pabbly Connect.

Now, select the template document titled ‘Experience Letter’. This document should contain placeholders for fields such as date, employee full name, employee ID, and department. Mapping these fields is essential for creating a dynamic document.

Map the employee’s full name by entering a slash (/) to select from previous responses. Ensure all necessary fields are mapped correctly to generate a personalized document.

After mapping, save your settings and send a test request to confirm that the experience letter is generated correctly in your Google Drive.

5. Sending Emails through Gmail

Finally, we need to send the experience letter via email using Gmail. Select Gmail as your next application and choose the event as ‘Send Email’. Connect your Gmail account to Pabbly Connect by selecting the existing connection.

In the email setup, map the sender’s name and email address from the previous responses. For the recipient email address, map the employee’s email address. Write a subject for the email and include the content, ensuring to personalize it with the employee’s name.

Attach the experience letter PDF using the mapped URL from Google Drive. Select the email content type as HTML for better formatting.

After filling in all fields, click on the ‘Save and Send Test Request’ button. Check your Gmail to confirm that the email was sent successfully with the attached experience letter.

Conclusion

In this tutorial, we explored how to replace manual work with smart logic using Pabbly Connect. By integrating Google Sheets, Google Docs, and Gmail, you can automate the process of creating and sending experience letters efficiently. This automation not only saves time but also enhances accuracy in your workflows.