How to Send Covid Test Results on SMS Automatically Using Pabbly Connect

Learn how to send Covid test results via SMS automatically using Pabbly Connect, Google Sheets, and Google Drive. Follow this detailed tutorial for seamless integration.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for SMS Automation

To send Covid test results automatically via SMS, you first need to set up Pabbly Connect. This platform allows you to integrate various applications seamlessly. Start by logging into your Pabbly Connect account and navigating to the dashboard.

Once logged in, click on the ‘Create Workflow’ button. Here, you will name your workflow, for example, ‘Send Covid Test Results.’ This will help you identify the workflow later. After naming, select the trigger application, which in this case is Google Sheets.

2. Integrating Google Sheets with Pabbly Connect

Next, you will connect Google Sheets to Pabbly Connect. This integration allows you to collect patient data such as names, phone numbers, and test results. Choose Google Sheets as your trigger application and set the trigger event to ‘New Spreadsheet Row.’

• Select your Google account and authorize access.
• Choose the specific spreadsheet containing the Covid test results.
• Map the columns for patient names, phone numbers, and test results.

Once set up, Pabbly Connect will monitor this Google Sheet for new entries. Every time a new row is added, it will trigger the subsequent actions in your workflow.

3. Generating Test Result Documents with Google Docs

After setting up Google Sheets, the next step involves generating test result documents using Google Docs via Pabbly Connect. This is crucial for creating a formal report of the test results. Select Google Docs as your next application and choose ‘Create Document’ as the action event.

In this step, you will select a template document that will serve as the basis for your test results. Ensure that your template contains placeholders for patient names and test results. Pabbly Connect will automatically fill these placeholders with data from your Google Sheets.

4. Sending SMS Notifications through Gmail

Once the document is generated, you will need to send the test results via SMS. For this, integrate Gmail with Pabbly Connect as the next step. Select Gmail as your action application and choose ‘Send Email’ as the action event.

• Connect your Gmail account to Pabbly Connect.
• Set the recipient’s email to the patient’s email address collected from Google Sheets.
• Compose the email body to include a link to the generated document.

This step ensures that patients receive their test results promptly via email, which can also be used to send SMS notifications.

5. Finalizing the Automation Workflow

Finally, review your entire workflow in Pabbly Connect. Ensure that all connections between Google Sheets, Google Docs, and Gmail are properly set up. Test the workflow by adding a new entry in your Google Sheets to see if the SMS is sent automatically.

Once everything is confirmed to be working, you can activate your workflow. This will allow Pabbly Connect to handle the automation of sending Covid test results via SMS, providing a seamless experience for both you and your patients.

Conclusion

In this tutorial, we explored how to send Covid test results automatically via SMS using Pabbly Connect, Google Sheets, and Gmail. This automation simplifies the process of notifying patients, ensuring they receive their results promptly and efficiently.