How to Add Received KrispCall SMS in Microsoft Excel Using Pabbly Connect

Learn how to integrate KrispCall SMS into Microsoft Excel using Pabbly Connect. Follow this step-by-step guide for seamless automation. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add received KrispCall SMS in Microsoft Excel, you will first need to access Pabbly Connect. Start by visiting the Pabbly Connect website. Here, you can either sign in if you are an existing user or click on the ‘Sign Up for Free’ button if you are new. Pabbly Connect offers 100 free tasks every month, making it an excellent choice for automation.

Once logged in, navigate to the dashboard. Click on the ‘Create Workflow’ button located at the top right corner. You will be prompted to name your workflow. For this integration, name it ‘Add Received KrispCall SMS in Microsoft Excel’. After naming, select the appropriate folder for saving your workflow, then click on ‘Create’ to proceed.

2. Setting Up Trigger and Action in Pabbly Connect

In Pabbly Connect, the automation process follows a trigger-action model. The trigger will be the reception of a new SMS from KrispCall, while the action will be to add that SMS data to Microsoft Excel. Start by selecting KrispCall as your trigger application and choose the event ‘New SMS’. This setup ensures that every time a new SMS is received, the automation will initiate. using Pabbly Connect

• Select KrispCall as the trigger application.
• Choose ‘New SMS’ as the trigger event.
• Proceed to set up the action application.

Next, for the action application, search for Microsoft Excel and select it. The action event will be ‘Add Row to Worksheet’. This configuration allows Pabbly Connect to input the SMS details directly into your specified Excel worksheet whenever a new SMS is received from KrispCall.

3. Connecting KrispCall and Microsoft Excel through Pabbly Connect

To establish the connection between KrispCall and Pabbly Connect, you will need to input your API key and secret key from your KrispCall account. Access your KrispCall settings, navigate to the developer section, and copy the API and secret keys. Paste these keys into the respective fields in Pabbly Connect and click on ‘Save’.

Once the connection is established, you will see a confirmation message. Next, click on ‘Save and Send Test Request’ to verify the connection. At this point, send a test SMS to your registered KrispCall number to generate a response that Pabbly Connect can capture.

4. Mapping SMS Data to Microsoft Excel in Pabbly Connect

With the SMS details captured by Pabbly Connect, it’s time to map this data into Microsoft Excel. First, you need to connect Microsoft Excel to Pabbly Connect. Click on the connect button and authorize the secure access. Once connected, select the workbook you’ve created for this automation.

• Select the workbook named ‘KrispCall SMS’.
• Map the fields for ‘From Number’, ‘Query’, and ‘ID’ based on the SMS data received.
• Click on ‘Save and Send Test Request’ to finalize the mapping.

After mapping the necessary fields, click on ‘Save and Send Test Request’ again. This action will add a new row in your Excel sheet with the SMS details, confirming that the integration is working correctly.

5. Successfully Adding SMS Details to Microsoft Excel

After completing the mapping process, Pabbly Connect will automate the addition of SMS details into Microsoft Excel seamlessly. Whenever you receive a new SMS on your registered KrispCall number, the details will be added automatically into your Excel spreadsheet.

This integration not only saves time but also ensures that all SMS communications are logged efficiently. With Pabbly Connect, you can easily manage your SMS data without manual entry, ensuring accuracy and saving valuable time.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to add received KrispCall SMS into Microsoft Excel. This integration enhances your workflow by automating the data entry process, ensuring you never miss an important message logged in your spreadsheet.