Google Sheets SMS Campaign Automation (n8n) with SMS Vert Pro MCP

Send an SMS from Google Sheets (n8n) and fetch the delivery report with SMS Vert Pro MCP

Automate your SMS sending flow in n8n: this workflow sends a text message via SMS Vert Pro MCP, pauses briefly to let delivery status update, and then retrieves the campaign delivery report using the returned campaign ID.

What this workflow does

• Manual start: The workflow runs when you start it manually (you can later swap the manual trigger for your preferred trigger).
• Send SMS via SMS Vert Pro MCP: It calls the send_sms tool with your configured recipient, message, and sender name.
• Wait for status to update: After sending, it waits 30 seconds to allow the SMS delivery status to change.
• Retrieve delivery report: It then calls the get_delivery_report tool using the campaign ID returned from the send response.

Use cases

• Test and verify SMS delivery: Quickly validate that your recipients are receiving messages and that delivery reports are available.
• Operational SMS follow-ups: Send an SMS notification and check the delivery outcome in the same run.
• SaaS workflows: Trigger SMS sending from your own n8n pipeline (including data sourced from Google Sheets) and automatically pull delivery results.

Technical details

• Integration: SMS Vert Pro MCP using Bearer Auth with your SMS Vert Pro API V2 token.
• Tools used: send_sms and get_delivery_report.
• Workflow nodes (as configured): if, set, code, wait, filter, sticky note.
• Setup reminders: Update the recipient phone number (international format without +), message text, and sender name (max 11 characters).

Build reliable Google Sheets–driven SMS automation in n8n with accurate, campaign-level delivery reporting through SMS Vert Pro MCP.