Integrate Twilio SMS Received Time into Google Sheets Using Pabbly Connect

Learn how to automate SMS received time logging in Google Sheets with Twilio using Pabbly Connect in this step-by-step tutorial. 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. Setting Up Pabbly Connect for Twilio SMS Integration

To automate the process of logging SMS received times into Google Sheets, we will use Pabbly Connect. Begin by signing up for a free account on Pabbly Connect’s website. Once signed up, log in and navigate to the dashboard where you can create your workflow.

Click on the ‘Create Workflow’ button and give your workflow a name. This will set the stage for integrating Twilio with Google Sheets through Pabbly Connect. You will find two modules: Trigger and Action, which are essential for automation.

2. Configuring Twilio SMS Trigger in Pabbly Connect

In this section, we will set up the trigger for receiving SMS messages using Pabbly Connect. Select Twilio as your app in the trigger section and choose the ‘New SMS’ event. This event will trigger whenever a new SMS is received.

• Search for Twilio in the Choose App field.
• Select ‘New SMS’ as the Trigger Event.
• Copy the provided webhook URL for Twilio.

After copying the webhook URL, log into your Twilio account. Navigate to the Active Numbers section, and under Messaging, set the webhook URL in the configuration. Save these changes, and your Twilio account will now be connected to Pabbly Connect.

3. Capturing SMS Details and Received Time

Once the trigger is set, it’s time to capture SMS details. Send a test SMS to your Twilio number. Upon receiving the message, Pabbly Connect will capture the SMS details, including the body of the message, in the response section.

• Ensure the message includes relevant content for testing.
• Check the response section for captured message details.

However, the time of the received message will be in UTC format. To convert this to your local time zone, we will use the DateTime Formatter in Pabbly Connect to adjust the time accordingly.

4. Formatting Date and Time for Local Time Zone

To convert the UTC time to your local time zone, add another action in your workflow using Pabbly Connect. Select the DateTime Formatter and choose the action event as ‘Format Date with Time Zone’. You will need to map the date and time from the previous step.

Map the received date and time from the previous step. Select UTC as the source time zone. Choose your local time zone, e.g., Asia/Kolkata.

After setting this up, click ‘Save and Send Test Request’ to verify the conversion. This will give you the correct local time for when the SMS was received, which is crucial for accurate logging.

5. Logging SMS and Time in Google Sheets

Now that we have the SMS details and the correct time, it’s time to log this information into Google Sheets using Pabbly Connect. Add another action step and select Google Sheets as the application. Choose ‘Add New Row’ as the action event.

Connect your Google account to Pabbly Connect. Select the spreadsheet where you want to log the SMS details. Map the SMS body and the formatted time into the respective columns.

After mapping, click on ‘Save and Send Test Request’. This will confirm that your data has been successfully logged into Google Sheets. You will now have a record of all incoming SMS messages along with their received times, making management much easier.

Conclusion

By following this tutorial, you can effectively automate the logging of SMS received times in Google Sheets using Pabbly Connect. This integration not only saves time but also ensures accurate record-keeping of important SMS communications. Start using Pabbly Connect today to streamline your SMS management processes!