Skip to content

Google Sheets GREEN-API for Google Sheets#

Google Sheets - an online spreadsheet editor by Google.

The GREEN-API for Google Sheets add-on lets you send WhatsApp messages to recipients listed in a Google Sheets spreadsheet, using your own GREEN-API account. The add-on works right inside Google Sheets: you choose which columns contain phone numbers and message text, start the sending task yourself, and get the sending statuses back into the spreadsheet.

How it works#

  1. Prepare the spreadsheet. Put the recipients' phone numbers, the message text and, if needed, links to media files in separate columns of the spreadsheet.
  2. Connect your GREEN-API instance. Open the add-on in the spreadsheet and enter the instance parameters idInstance, apiTokenInstance and apiUrl. You can find them in your GREEN-API account, see Before you start.
  3. Select the columns. Specify which columns contain phone numbers, message text and media links.
  4. Start sending. You start each sending task yourself. The add-on reads the recipients and messages from the selected columns and sends them through the GREEN-API service to WhatsApp.
  5. Check the result. The add-on writes the sending status of each message back into the spreadsheet.

Sending statuses are visible to everyone with access to the spreadsheet

Statuses are written into the spreadsheet itself, so anyone who has access to it according to its Google Sheets sharing settings can see them. Your GREEN-API credentials and add-on settings are stored privately in your Google account and are not visible to other users of the same spreadsheet.

What the add-on can access#

The add-on requests only the following permissions:

  • access to the spreadsheet the add-on is opened in - the add-on cannot access your other files in Google Drive;
  • connection to an external service - used only to send requests to the GREEN-API service to deliver your messages;
  • display of the add-on interface - used to show the add-on's settings and sending interface inside Google Sheets.

The add-on does not access your Google account profile, email, contacts, or any other Google service.

Fees#

The add-on is provided free of charge. Messages sent through the add-on are billed under your GREEN-API tariff.

Resetting settings and revoking access#

  • To delete your credentials, settings and sending history stored by the add-on, open Settings > Reset settings > Reset in the add-on. Spreadsheet contents are not affected.
  • To revoke the add-on's access, uninstall it or remove its access at https://myaccount.google.com/permissions.

Privacy Policy - how the add-on accesses, uses, stores and shares data, including Google user data.

Terms of Service - terms of using the add-on.

Support#

Questions about the add-on: support@green-api.com.