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

Learn how to send Bank OTP SMS received on iPhone to Google Sheets using Pabbly Connect. This detailed tutorial covers all the integration steps. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for OTP SMS Integration

To send Bank OTP SMS received on your iPhone to Google Sheets, the first step is to set up Pabbly Connect. This powerful integration platform allows you to automate the process seamlessly. Start by logging into your Pabbly Connect account and creating a new workflow.

Once your workflow is created, you will need to select the trigger app. In this case, choose the ‘Webhook’ option. This will enable Pabbly Connect to receive data from your iPhone when you receive an OTP SMS. After selecting the webhook, you will be provided with a unique URL to use in your iPhone shortcut.

2. Creating an iPhone Shortcut for OTP SMS

Next, you will need to create a shortcut on your iPhone that sends the OTP SMS to Pabbly Connect. Open the Shortcuts app and navigate to the Automation tab. Click on the ‘Create Personal Automation’ button, and select ‘Message’ as the trigger.

• Set the condition to ‘Message Contains’ and enter your bank’s name, such as HDFC.
• Choose to run the automation immediately without confirmation.
• Add an action to get contents of URL and paste the webhook URL from Pabbly Connect.

This setup allows your iPhone to automatically send any SMS containing your bank’s name to Pabbly Connect for processing.

3. Filtering OTP SMS in Pabbly Connect

After setting up the iPhone shortcut, the next step is to filter the OTP SMS in Pabbly Connect. This ensures that only relevant OTP messages are sent to Google Sheets. In your Pabbly Connect workflow, add a filter action after the webhook trigger.

For the filter condition, select the message field and set the filter type to ‘Contains’ with the value as ‘OTP’. This will allow only the SMS that includes the word ‘OTP’ to proceed further in the workflow. If the condition is met, the automation will continue to the next step of adding the data to Google Sheets.

4. Sending OTP Data to Google Sheets

Now that you have filtered the OTP SMS, it’s time to send the data to Google Sheets using Pabbly Connect. Add a new action step to your workflow and select Google Sheets as the app. Choose the action event as ‘Add New Row’.

• Connect your Google Sheets account to Pabbly Connect.
• Select the spreadsheet where you want to store the OTP details.
• Map the fields from the webhook response to the corresponding columns in Google Sheets.

This process allows you to automatically log the OTP SMS details into your selected Google Sheets document, making it easy to share with your team.

5. Testing the Automation

The final step is to test the entire automation process to ensure it works as intended. Send a test SMS to your iPhone containing the OTP and your bank’s name. Check if the automation triggers and the data appears in Google Sheets as expected.

If everything is set up correctly, you should see the OTP SMS details logged in the specified Google Sheets. This confirms that Pabbly Connect is effectively integrating your iPhone’s SMS with Google Sheets, automating the process of sharing OTPs with your team.

Conclusion

By using Pabbly Connect, you can easily automate the process of sending Bank OTP SMS received on your iPhone to Google Sheets. This integration saves time and reduces manual effort, allowing for efficient sharing of important OTPs with your team members.