pip install requests pandas

+1234567890,"👋 Welcome to {{your-business-name}}! Thanks for signing up. We are just a message away!"
+1234567890,"💐 Your order has been shipped. Tracking number is {{tracking-number}}. Don't hesitate to reach out to if you need help! 🤗"

import requests
import pandas as pd

# Replace this with the URL of your published Google Sheets CSV file
# See the indications above to obtain the Google Sheets download URL to enter here
google_sheets_csv_url = 'ENTER_GOOGLE_SHEETS_CSV_URL_HERE'

# Replace this with your Agent Connect API token
# Get your API token here: https://chat.agentconnect.chat/apikeys
token = 'ENTER API KEY HERE'

# Optionally specify the target WhatsApp device ID connected to Agent Connect
# you want to use for messages delivery (24 characters hexadecimal value)
device = 'DEVICE ID GOES HERE'

# Define the headers for the API request
headers = {
  'Content-Type': 'application/json',
  'Authorization': f"{token}"
}

# Define the URL for the Agent Connect API
api_url = 'https://api.agentconnect.chat/v1/messages'

# Read the Google Sheets CSV file and parse it as a CSV
data = pd.read_csv(google_sheets_csv_url)

# Iterate through the DataFrame rows
for index, row in data.iterrows():
    phone_number = row[0]
    message = row[1]

    # Create the payload for the API request
    payload = {
        'phone': phone_number,
        'body': message,
        'device': device
    }

    # Send the message using the Agent Connect API
    response = requests.post(api_url, headers=headers, json=payload)

    # Check if the API request was successful
    if response.status_code == 200:
        print(f"Message sent to {phone_number}: {message}")
    else:
        print(f"Failed to send message to {phone_number}: {response.text}")

print("Finished sending messages")

https://drive.google.com/uc?id=1RG3CAPiwiFlFATUlIIwhk0RrbEU4PgVP&export=download

import requests
import csv
from io import StringIO

# Replace this with the URL of your published Google Sheets CSV file
# See the indications above to obtain the Google Sheets download URL to enter here
google_sheets_csv_url = 'ENTER_GOOGLE_SHEETS_CSV_URL_HERE'

# Set the download URL of the file to be sent.
# The file must be publicly accessible from the Internet and return the file binary content
# You can also upload a local file in Google Drive and make the file publicly available for download
# Accepted file formats are: images (JPEG, WEBP, PNG), video (MP4), audio (MP3, OGG) and documents (PDF, XLSX, DOCX, ZIP...)
file_url = 'https://picsum.photos/seed/picsum/600/500'

# Replace this with your API token
# Get your API token here: YOUR_CONSOLE_URL/apikeys
token = 'ENTER API KEY HERE'

# Optionally specify the target device ID connected to the API
# you want to use for messages delivery (24 characters hexadecimal value)
device = 'DEVICE ID GOES HERE'

# Define headers for the API request
headers = {
    'Content-Type': 'application/json',
    'Authorization': f'{token}'
}

# Define URLs for the API
base_url = 'https://api.agentconnect.chat/v1'
url = f'{base_url}/messages'
files_url = f'{base_url}/files'

def upload_file(url):
    body = {'url': url}
    try:
        response = requests.post(files_url, json=body, headers=headers)
        response.raise_for_status()
        return response.json()['id']
    except requests.exceptions.HTTPError as error:
        if error.response.status_code == 409 and error.response.json():
            return error.response.json()['meta']['file']
        print(f'Failed to upload file: {error.response.text}')
        return None

def normalize_phone(phone):
    return f"+{phone.replace('\\D', '')}"

def send_message(phone, message, file):
    body = {
        'phone': phone,
        'message': message.strip(),
        'device': device,
        'media': {'file': file}
    }
    try:
        response = requests.post(url, json=body, headers=headers)
        response.raise_for_status()
        print(f"==> Message created: {phone}")
    except requests.exceptions.HTTPError as error:
        print(f'Failed to create message to {phone}: {error.response.text}')

def main():
    try:
        if not file_url:
            raise ValueError('Missing required fileUrl')

        print('=> Downloading Google Sheets CSV file...')
        response = requests.get(google_sheets_csv_url)
        response.raise_for_status()
        data = response.text
        records = csv.reader(StringIO(data))

        print('=> Uploading file...')
        file_id = upload_file(file_url)
        if not file_id:
            raise ValueError('Failed to upload file: check the error')

        print('=> Processing messages...')
        for phone, message in records:
            if not phone or not message:
                continue

            number = normalize_phone(phone)
            if number and len(number) >= 8 and message:
                send_message(number, message, file_id)

    except ValueError as error:
        print(f'Error: {error}')
    except requests.exceptions.HTTPError as error:
        print(f'Error: {error.response.text}')

if __name__ == "__main__":
    main()

# Replace this with the URL of your published Google Sheets CSV file
google_sheets_csv_url = 'ENTER_GOOGLE_SHEETS_CSV_URL_HERE'

# Replace this with your Agent Connect API token
token = 'ENTER API KEY HERE'

# Optionally specify the target WhatsApp device ID connected to Agent Connect
# you want to use for messages delivery (24 characters hexadecimal value)
device = 'DEVICE ID GOES HERE'

python send_messages.py

python send_media.py

=> Message created: +1234567890
=> Message created: +1234567890
=> Message created: +1234567890