Automate Country-Based SMS from Google Sheets and Update Status
Send marketing SMS via BulkGate based on country (IN/US) from new Google Sheets rows, then store the delivery status back in the sheet.
Apps used
Created by Abhishek Jaiswal
Installed by 1 users
- country in pending
Send a Marketing Bulk SMS MessageUpdate Spreadsheet RowAdd Step - country us and pendingSend a Marketing Bulk SMS Message 1Update Spreadsheet Row 1Add Step
- ifcbBLloHf8HAdd Step
Automate Country-Based SMS from Google Sheets and Update Status
Automate Country-Based SMS from Google Sheets and Update Status
Introduction
Turn new leads in Google Sheets into instant, country-specific SMS campaigns and keep your sheet updated with delivery status. ✅
Trigger Event
When a new row is added in your Google Sheet (e.g., a lead list) with status set to "pending" and a country specified.
Actions
- The automation checks the country in the new row.
- If the country is India (IN) and status is pending:
- It sends a marketing SMS via BulkGate to the provided phone number using the India route.
- It then writes the SMS response status (e.g., accepted/sent) back into the same row’s Status column.
- If the country is United States (US) and status is pending:
- It sends a marketing SMS via BulkGate using the US route.
- It updates the same row’s Status column with the SMS response status.
- If the country is neither IN nor US, or status isn’t pending, the flow safely does nothing.
Benefits
- Route messages by country automatically; no manual sorting
- Save time by sending SMS the moment a row is added
- Keep a single source of truth as status is stored in the sheet
- Reduce errors with clear, conditional rules
- Faster follow-ups and better campaign tracking
Can't find the right template?
Start with AI
Frequently Asked Questions
This template automates a specific workflow by connecting multiple apps and removing manual steps. It’s useful for anyone who wants to save time, reduce errors, and streamline repetitive tasks using automation.
No. You can install and customize this template without writing any code. Everything is done through simple configuration.
Only the apps shown on the template page are required. You can customize messages, add or remove steps, apply conditions, connect more apps, and add extra actions like notifications, data updates, or triggering other automations.
Yes. Once configured, it can be used for live workflows and production systems. You can also duplicate the template and customize it for different teams or processes.
Most templates can be set up in just a few minutes. You can pause, edit, duplicate, or delete the workflow anytime.
You can start with the free plan; limits depend on your viaSocket plan and usage. If you need help, you can contact viaSocket support, check the Knowledge Base, or book a demo.
