How to Send Bank OTP SMS Received on iPhone to Google Sheets Using Pabbly Connect

Learn how to send Bank OTP SMS received on iPhone to Google Sheets using Pabbly Connect. This step-by-step guide covers the entire automation process. 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. Setting Up Pabbly Connect for Bank OTP SMS Integration

To send Bank OTP SMS received on your iPhone to Google Sheets, you first need to access Pabbly Connect. This platform allows you to create automated workflows that facilitate the integration of various applications, including Google Sheets and your iPhone SMS.

Begin by signing into your Pabbly Connect account. Once logged in, you can create a new workflow that will capture the OTP SMS messages from your iPhone and send them to Google Sheets. This process eliminates the need for manual entry, streamlining your workflow significantly.

2. Creating Automation on iPhone Using Shortcuts

Next, you will set up an automation on your iPhone using the Shortcuts app. This automation will trigger when you receive a Bank OTP SMS. Open the Shortcuts app and navigate to the Automation tab to create a new automation.

• Select ‘Message’ as the trigger.
• Choose ‘Message Contains’ and enter your bank’s name, e.g., ‘HDFC’.
• Set the automation to run immediately without confirmation.

This setup ensures that any SMS containing your bank’s name will trigger the automation to send the SMS details to Pabbly Connect.

3. Configuring Webhook in Pabbly Connect

After configuring the automation on your iPhone, the next step involves setting up a webhook in Pabbly Connect. This webhook will receive the SMS data from your iPhone. In your Pabbly Connect workflow, select the ‘Webhook’ app as the trigger.

Choose the event ‘Catch Webhook’ to generate a unique webhook URL. Copy this URL and return to your iPhone automation. In the automation, select ‘Get Contents of URL’ and paste the webhook URL. Change the method to ‘POST’ and select JSON as the request body format.

4. Filtering OTP Messages in Pabbly Connect

To ensure that only relevant OTP messages are sent to Google Sheets, you will set up a filter in Pabbly Connect. This filter will check if the incoming message contains the keyword ‘OTP’. In your Pabbly Connect workflow, add a new action and select ‘Filter by Pabbly’.

• Select the message response from the webhook.
• Set the filter type to ‘Contains’ and enter ‘OTP’ as the value.

This ensures that only SMS messages containing the keyword ‘OTP’ proceed to the next step of being added to Google Sheets.

5. Adding OTP SMS to Google Sheets

The final step is to add the filtered OTP SMS details to Google Sheets. In your Pabbly Connect workflow, add a new action and select ‘Google Sheets’. Choose the action event ‘Add New Row’ to set up the addition of new OTP entries.

Connect your Google Sheets account and select the spreadsheet where you want to save the OTP details. Map the required fields such as date, sender, and message from the webhook response. Once mapped, test the action to ensure the data is being added correctly.

Conclusion

In this tutorial, you learned how to send Bank OTP SMS received on your iPhone to Google Sheets using Pabbly Connect. This automation not only saves time but also enhances collaboration by allowing team members to access OTPs without manual input. Implementing this process can greatly streamline financial operations.