ClickSend SMS + AWeber + Google Sheets Integrations

How to connect ClickSend SMS + AWeber + Google Sheets

Zapier lets you send info between ClickSend SMS and AWeber and Google Sheets automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

Free forever for core features
14 day trial for premium features & apps

Do even more with ClickSend SMS + AWeber + Google Sheets

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with ClickSend SMS, AWeber, and Google Sheets. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

New Incoming SMS
Triggers when a new incoming sms is received.
Trigger
Instant
Try It
- List NameRequired
  The name of the contact list.
Action
Write
- Contact ListRequired
  The list that you want to remove. Will require a list ID that will generally have to be returned from other actions.
Action
Write
- ToRequired
  Mobile phone number. Can be in local or international format. Must be in international (E.164) format if sending to another country. e.g +61411111111.
- SubjectRequired
  Subject line. Maximum 20 characters.
- BodyRequired
  Message body. Up to 1500 characters or 500 unicode characters View GSM Characters.
- Schedule
  Allows a message to be scheduled. Time must be in Unix format e.g. 1462788759. Leave blank for instant delivery.
- From
  From number - use a ClickSend dedicated number that you've purchased (anything else will fail). If you don't have a ClickSend number, leave it blank.
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
- Media URLRequired
  A URL of the media file you want to send.
Action
Write
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
- PDF File UrlRequired
  A public URL to the PDF file. If you're not sure what this is, more info can be found here.
- Priority
  Choose delivery priority. Options are Standard or Priority post.
- Template Used
  Choose if you've used our template file or not. If 'no', we insert a blank addressed page as the first page. View our template here.
- Colour
  Choose to use colour or B&W printing.
- Duplex
  Choose to use Duplex (double-sided) or Simplex (single sided) printing.
- Address NameRequired
- Line 1Required
- Line 2
- CityRequired
- State
- Postal CodeRequired
- CountryRequired
  The address country. Must be a 2-digit country code e.g. "US", "AU", "GB".
- Return AddressRequired
  Return address - you can manage return addresses on the ClickSend Dashboard: Open Dashboard or via our API).
Action
Write

- Campaign NameRequired
  Give your campaign a name. Ie. January Marketing Campaign
- List NameRequired
  A contact list to send to. You can add/manage contact lists via the ClickSend dashboard.
- From
  From number or name - where the message comes 'from' on the handset. If you're sending to the US/Canada leave this field blank or use a ClickSend dedicated number that you've purchased (anything else will fail). If you use a name for the from address e.g. "MyCompany", the receiver won't be able to reply. More Info.
- MessageRequired
  Learn about message limits.
- Schedule
  Allows a message to be scheduled. Time must be in Unix format e.g. 1462788759. Leave blank for instant delivery.
Action
Write
- ToRequired
  Mobile or landline phone number in local or international format. Must be in international format (E.164) if sending to a different country.e.g. +61411111111.
- MessageRequired
  Message body to be read out.
- Language
  Choose which language you want to use. Full list here: Open Docs.
- VoiceRequired
  Choose the message to be read out in a Male of Female voice.
- From
  The from number. This must be a valid ClickSend dedicated number.
- Schedule
  Allows a message to be scheduled. Time must be in Unix format e.g. 1462788759. Leave blank for instant delivery. More info can be found here: Open Docs.
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
Action
Write

- Contact ListRequired
  The list you want to search for the contact.
- Email AddressRequired
  Email address you want to search.
Action
Search
New Account
Triggers when a new account is added.
Trigger
Scheduled
Try It
- AccountRequired
Trigger
Scheduled
Try It
- AccountRequired
- ListRequired
  Select an Account first to see your lists.
- SubscriberRequired
Action
Write
- AccountRequired
- ListRequired
  Select an Account first to see your lists.
- SubscriberRequired
  Select a list first to see subscribers from.
- Email
- Name
- Status
- Add
- Remove
- Destination List
  Move the subscriber to a different list.
Action
Write
- AccountRequired
- List NameRequired
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Trigger
Scheduled
Try It
- No Team Drive
  If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Trigger
Instant
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
  The column position (zero-based) to insert. If not set, append to the right by default.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
  Create a duplicate of an existing spreadsheet.
- Headers
  These Headers are ignored if a "Spreadsheet to Copy" is selected.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  Use a search step before this to get the row to delete.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Action
Write
- Owner
  Determines which App Extensions will appear in the dropdown below.
- App ExtensionRequired
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet?
- Row Count
  Number of rows to return. Max is 500.
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- ColumnsRequired
  Let us know which columns to return. e.g. A:Z
- Row CountRequired
  Number of rows to return. Max is 500.
- First Row
  Number of the first row to return (1 is the header)
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Search or write

- Contact ListRequired
  The list where you want to add the contact.
- First Name
  Contact's first name.
- Last Name
  Contact's last name.
- Phone Number
  The contact phone in local or international format e.g. +61411111111.
- Email
  Contact's email address.
- Fax Number
- Organization Name
- Custom 1
- Custom 2
- Custom 3
- Custom 4
- Address Line 1
- Address Line 2
- City
- State
- Postal Code
- Country
  The contact's country. Must be a 2-character country code e.g. "US", "AU", "GB".
Action
Write
- Contact ListRequired
  The list where you want to remove the contact.
- Contact IDRequired
  The contact_id of the contact you want to delete. This is returned when originally adding the contact. If you don't have it you can use the search in Zapier to search for the contact, then use the contact_id from the response.
Action
Write
- ToRequired
  Phone number in E.164 format. Eg. +61261111111.
- FromRequired
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
- PDF File UrlRequired
Action
Write
- PDF File UrlRequired
  A public URL to the postcard PDF file. Can be a single file with 1 page (front only) or 2 pages (front and back) or 2 files with a single page each. View Template.
  If you're not sure what a public URL is, more info can be found here.
- Address NameRequired
- Line 1Required
- Line 2
- CityRequired
- State
- Postal CodeRequired
- CountryRequired
  The address country. Must be a 2-digit country code e.g. "US", "AU", "GB".
- Return AddressRequired
  Return address - you can manage return addresses on the ClickSend Dashboard Open Dashboard or via our API.
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
- Priority
  Choose delivery priority. Options are Standard or Priority post.
Action
Write
- ToRequired
  Mobile phone number. Can be in local or international format. Must be in international (E.164) format if sending to another country. e.g +61411111111.
- MessageRequired
  Learn about message limits.
- Schedule
  Allows a message to be scheduled. Time must be in Unix format e.g. 1462788759. Leave blank for instant delivery. .
- From
  From number or name - where the message comes 'from' on the handset. If you're sending to the US/Canada leave this field blank or use a ClickSend dedicated number that you've purchased (anything else will fail). If you use a name for the from address e.g. "MyCompany", the receiver won't be able to reply. More Info.
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
- Contact ID
  If you supply a Contact ID of a contact (optional), we will link the contact to the message on the ClickSend dashboard. You can get the contact ID after adding a contact or from a contact search.
Action
Write
- Contact List NameRequired
  A contact list to send to. You can add/manage contact lists via the ClickSend dashboard.
- MessageRequired
  Learn about message limits.
- Schedule
  Allows a message to be scheduled. Time must be in Unix format e.g. 1462788759. Leave blank for instant delivery.
- From
  From number or name - where the message comes 'from' on the handset. If you're sending to the US/Canada leave this field blank or use a ClickSend dedicated number that you've purchased (anything else will fail). If you use a name for the from address e.g. "MyCompany", the receiver won't be able to reply. More Info.
- Custom String
  This is your reference. It will show on all reports and will be passed back with any replies.
Action
Write
- List NameRequired
  The list name.
Action
Search
- Contact ListRequired
  The list you want to search for the contact.
- Phone NumberRequired
  Phone number you want to search. Must be in full international format without the leading + (E.164 format). Eg. 6141111111.
Action
Search
- Account
- Lists
  Select an Account first to see your lists.
Trigger
Scheduled
Try It
- AccountRequired
- ListRequired
  Select an Account first to see your lists.
- Status
  Only trigger on subscribers that are this status.
Trigger
Scheduled
Try It
- AccountRequired
- ListRequired
  Select an Account first to see your lists.
- EmailRequired
  AWeber requires double opt-in for any new subscriber.
- Name
- Tags
Action
Write
- AccountRequired
- ListRequired
  Select an Account first to see your lists.
- Email
- Name
  Must match the name in AWeber exactly, including capitalization.
Action
Search
- AccountRequired
- ListRequired
  Select an Account first to see your lists.
- EmailRequired
  AWeber requires double opt-in for any new subscriber.
- Name
  Must match the name in AWeber exactly, including capitalization.
- Tags
Action
Search or write
- No Team Drive
  If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Instant
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
  Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
- Background Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Bold
  True if the text is bold.
- Text Italic
  True if the text is italicized.
- Text Strikethrough
  True if the text is strikethrough.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Api Docs Info
  API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search or write

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How ClickSend SMS + AWeber + Google Sheets Integrations Work

Step 1: Authenticate ClickSend SMS, AWeber, and Google Sheets.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect ClickSend SMS + AWeber + Google Sheets

About ClickSend SMS

ClickSend is a cloud-based service that lets you send and receive SMS, Email, Voice, Fax and Letters worldwide.

Learn more

Related categories

Phone & SMS

About AWeber

AWeber provides professional email marketing software and services. AWeber's easy signup forms and autoresponders make it easy for you to stay in touch with your customers.

Learn more

Related categories

Email Newsletters

Similar apps

Mailchimp

Email Newsletters

Campaign Monitor

Email Newsletters

Constant Contact

Email Newsletters

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

ClickSend SMS + AWeber + Google Sheets Integrations

How to connect ClickSend SMS + AWeber + Google Sheets

Do even more with ClickSend SMS + AWeber + Google Sheets

New Incoming SMS

Create Contact List

List NameRequired

Delete Contact List

Contact ListRequired

Send MMS

ToRequired

SubjectRequired

BodyRequired

Schedule

From

Custom String

Media URLRequired

Send Letter

Custom String

PDF File UrlRequired

Priority

Template Used

Colour

Duplex

Address NameRequired

Line 1Required

Line 2

CityRequired

State

Postal CodeRequired

CountryRequired

Return AddressRequired

Send SMS Campaign

Campaign NameRequired

List NameRequired

From

MessageRequired

Schedule

Send Voice

ToRequired

MessageRequired

Language

VoiceRequired

From

Schedule

Custom String

Search Contact by Email Address

Contact ListRequired

Email AddressRequired

New Account

New List

AccountRequired

Unsubscribe Email

AccountRequired

ListRequired

SubscriberRequired

Update Subscriber

AccountRequired

ListRequired

SubscriberRequired

Email

Name

Status

Add

Remove

Destination List

Find a List

AccountRequired

List NameRequired

New Spreadsheet Row (Team Drive)

Drive

SpreadsheetRequired

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column