Google Sheets to Twilio SMS Automation

This n8n workflow simplifies and automates the process of sending bulk SMS messages using Twilio, triggered by new or updated rows in a Google Sheet. It allows for conditional messaging based on a "Sent" status in your sheet, ensuring messages are only sent once.

What it does

1. Triggers on Google Sheet Updates: The workflow starts whenever a new row is added or an existing row is updated in a specified Google Sheet.
2. Reads Google Sheet Data: It retrieves the data from the Google Sheet, likely containing recipient phone numbers and message content.
3. Conditional Processing: It checks a specific condition (e.g., a "Sent" column) to determine if an SMS has already been dispatched for that row.
4. Sends SMS via Twilio: If the condition indicates the message has not been sent, it proceeds to send an SMS using Twilio to the designated recipient.
5. Updates Google Sheet: After successfully sending the SMS, it updates the corresponding row in the Google Sheet to mark the message as "Sent," preventing duplicate messages.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Google Account: A Google account with access to Google Sheets. You will need to set up a Google Sheets credential in n8n.
• Twilio Account: A Twilio account with an active phone number capable of sending SMS. You will need to set up a Twilio credential in n8n.
• Google Sheet: A Google Sheet containing the data for your SMS messages. This sheet should ideally include columns for:
  • Recipient phone numbers
  • Message content
  • A status column (e.g., "Sent") to track sent messages.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Google Sheets Trigger (Node 841):
     • Click on the "Google Sheets Trigger" node.
     • Under "Credentials," select an existing Google Sheets OAuth2 credential or create a new one. Ensure it has access to your Google Sheets.
     • Specify the "Spreadsheet ID" and "Sheet Name" that the workflow should monitor.
   • Google Sheets (Node 18):
     • Click on the "Google Sheets" node.
     • Under "Credentials," select the same Google Sheets OAuth2 credential used for the trigger.
     • Specify the "Spreadsheet ID" and "Sheet Name" for updating the "Sent" status.
   • Twilio (Node 45):
     • Click on the "Twilio" node.
     • Under "Credentials," select an existing Twilio credential or create a new one. You'll need your Twilio Account SID and Auth Token.
     • Configure the "From" phone number (your Twilio number) and the "To" phone number (dynamically pulled from your Google Sheet data).
     • Configure the "Body" of the message (dynamically pulled from your Google Sheet data).
3. Configure Nodes:
   • If (Node 20): This node will likely contain logic to check if a message has already been sent. You will need to configure the condition based on your Google Sheet's "Sent" column (e.g., {{ $json.Sent === "No" }}).
   • Edit Fields (Set) (Node 38): This node prepares the data for Twilio. Ensure it correctly maps the Google Sheet columns to the Twilio message fields (e.g., to and body).
4. Activate the Workflow:
   • Once all credentials and node configurations are complete, click the "Activate" toggle in the top right corner of the n8n editor to enable the workflow.

Now, any new or updated row in your specified Google Sheet will trigger the workflow, send an SMS via Twilio (if not already sent), and update the sheet accordingly.