Integrate KrispCall SMS with Google Sheets Using Pabbly Connect

Learn how to automate adding received KrispCall SMS to Google Sheets using Pabbly Connect. Follow our step-by-step tutorial for seamless integration. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To integrate KrispCall SMS with Google Sheets, you must first access Pabbly Connect. Begin by typing ‘Pabbly.com/connect’ in your browser. Here, you can either sign in if you’re an existing user or click on the ‘Sign up for free’ button if you are new.

Once signed in, you will land on the Pabbly Connect dashboard. To create a new workflow, click on the ‘Create Workflow’ button located at the top right corner. A dialog box will appear, prompting you to name your workflow. Name it something descriptive, like ‘Add Received KrispCall SMS in Google Sheets’.

2. Setting Up Trigger and Action in Pabbly Connect

In this step, you will set up the trigger and action for your workflow using Pabbly Connect. The trigger application will be KrispCall, and the action application will be Google Sheets. Under the trigger section, search for ‘KrispCall’ and select it.

• Choose ‘New SMS or MMS’ as the trigger event.
• This will activate the workflow whenever you receive a new SMS.

Next, move to the action section and select ‘Google Sheets’. The action event will be ‘Add a New Row’. This configuration will ensure that every time you receive a new SMS, the details will be added to your specified Google Sheet.

3. Connecting KrispCall and Pabbly Connect

To establish a connection between KrispCall and Pabbly Connect, click on the ‘Connect’ button in the trigger setup. You will be prompted to enter your API Key and Secret Key from your KrispCall account. To find these keys, log in to your KrispCall account and navigate to Settings > Developer.

Copy both the API Key and Secret Key and paste them into the respective fields in Pabbly Connect. Click on ‘Save’ to establish the connection. After saving, you will be directed to send a test request. This test will confirm that the integration is set up correctly.

4. Adding SMS Details to Google Sheets

After successfully connecting KrispCall to Pabbly Connect, the next step involves adding the SMS details to Google Sheets. Click on the ‘Connect’ button in the action setup to link Google Sheets with Pabbly Connect. Sign in with your Google account to authorize the connection.

• Select the spreadsheet you created for storing SMS data.
• The spreadsheet should have columns for ‘From Number’, ‘Query’, and ‘ID’.

After selecting your spreadsheet, map the fields from the SMS response to the corresponding columns in your Google Sheet. This ensures that the correct data is inserted into the right columns every time a new SMS is received.

5. Testing the Integration and Finalizing

With the setup complete, it’s time to test the integration using Pabbly Connect. Send an SMS to your registered KrispCall number to trigger the workflow. After sending the SMS, return to Pabbly Connect and check for a response.

If everything is configured correctly, you should see a positive response indicating that the SMS details have been captured. Now, check your Google Sheets, and you should see the new SMS details added in a new row, confirming that the integration works seamlessly.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the process of adding received KrispCall SMS to Google Sheets. By following these steps, you can ensure that every SMS is logged efficiently, streamlining your workflow and enhancing productivity.