CSV --> Loops Api

do-it.py

import csv
import requests
import time

file_path = 'my-csv.csv'
headers = {"Authorization": "Bearer ......"}

# Open the CSV file
with open(file_path, newline='') as csvfile:
    # Create a CSV reader object
    csvreader = csv.reader(csvfile)
    next(csvreader)  # Skip header row

    # Loop through each row in the CSV file
    for row in csvreader:
        # Prepare the data for the API
        data = {
            "firstName": row[0],
            "email": row[1],
            "cohort": row[2],
            "status": row[3],
        }
        print(f'Sending data for {data["email"]}...')
        response = requests.post('https://app.loops.so/api/v1/contacts/update', json=data, headers=headers)
        print(f'Status code: {response.status_code}')  # Print the status code for each request
        time.sleep(.25) # Avoid rate limiting

print('Done!')