Sending messages from Google Sheets with TNZ

Send SMS, Email and Voice/Text-to-Speech messages from Google Sheets using TNZ's preconfigured template.

Prepare recipient details and message text in a spreadsheet, including names and custom fields for personalised messages.

1. Get the TNZ template

Contact TNZ for the Google Sheets template link. Copy the supplied sheet into your Google account before you add your own data.

You also need a TNZ account. If you do not have one, register for a free trial.

2. Add your Sender and APIKey

1. Sign in to the TNZ Dashboard.
2. Open Users and select the user intended for this spreadsheet.
3. Enable API access and open the user's API tab.
4. Enable Sender/APIKey and create an APIKey if needed.
5. Copy the Sender and APIKey into the credential fields in your copy of the template.

The documented template uses a Sender/APIKey pair. See Managing API users, APIKeys and authorisation for help finding these values.

Restrict access to the configured sheet. It contains credentials that allow messages to be sent through your TNZ account.

3. Prepare your messages

Replace the template's example data with your intended recipients and message text. Use its name and custom fields where you need personalised content.

Start with a single test recipient you control. Review the destination and the completed message before sending.

4. Send and check delivery

1. Use the template's Send button to submit your test message.
2. Check that the message reaches your test recipient.
3. Use Update Status to check delivery status in the sheet.
4. After the test succeeds, prepare and review the remaining recipients before sending.

If the sheet does not send

Check that the Sender and APIKey belong to the same TNZ user and that API access is enabled. Review the destination and any error shown by the sheet.

If you need help with script permissions, the template controls, or an error, contact TNZ. Include the error text, but remove credentials and recipient details from screenshots.