Integration setup#
System requirements#
- MS Excel 2016 or higher versions
- Windows 10 or higher versions (Windows 7 support ended on 01/14/2020, so when using the table with earlier versions you may see errors related to software relevance)
Preparing for installation#
- Install the WhatsApp mobile application
- Registration in the console
- Create and authorize an instance
- Get access parameters to instance
Installation#
1. Download MS Excel spreadsheet#
2. Unblock downloaded file#
Do right-click on the file and choose "Properties". Set check on the security checkbox section and click the "OK" button to save your changes.
If you can't unlock the file, try moving it to your work folder.
3. Enable macros in MS Excel#
Select "Enable Content" in the Security Warning dialog, select "Yes" to make the document trusted.
4. Necessary authentication#
- Move to the
Parametersworksheet.
Copy from your GREEN-API console following parameters:
idInstanceapiTokenInstancemediaUrlapiUrl
Strongly recommend for the best performance and stability work use apiUrl and mediaUrl from your GREEN-API console.
Recommendations for sending messages.
Change message sending delay from 500 milliseconds to 10-15 seconds. To change the messages sending delay from queue, use SetSettings method with delaySendMessagesMilliseconds parameter (see examples). After that, change the "Delay between messages" when sending to the queue on the Parameters sheet from 10 seconds to 1 second.