Send SMS campaigns from Google Sheets and track delivery with SMS Vert Pro MCP

Description

Quick Overview
This workflow manually sends an SMS via the SMS Vert Pro MCP server, waits 30 seconds, and then retrieves a delivery report for the SMS campaign using the returned campaign ID.

How it works
Runs when you start the workflow manually.
Sends an SMS through the SMS Vert Pro MCP server using the send_sms tool with the configured recipient, message, and sender name.
Waits 30 seconds to allow the SMS status to update.
Requests the campaign delivery report from SMS Vert Pro using the get_delivery_report tool and the campaign ID from the send response.

Setup
Create an n8n Bearer Auth credential using your SMS Vert Pro API V2 token and select it in both SMS Vert Pro MCP client steps.
Update the recipient phone number (international format without +), message text, and sender name (11 characters max) in the send request payload.
Run the workflow manually, or replace the manual trigger with your preferred trigger and map the phone number/message fields accordingly.