DEV Community

Caper B
Caper B

Posted on

How I Automate My Freelance Workflow with Python

#python #freelancing #automation #productivity

How I Automate My Freelance Workflow with Python

As a freelancer, I've learned that streamlining my workflow is crucial to increasing productivity and earning more. In this article, I'll share how I use Python to automate repetitive tasks, freeing up time to focus on high-leverage activities like finding new clients and delivering quality work.

Step 1: Project Management Automation

I use Trello to manage my projects, and Python to automate task creation and assignment. With the requests library, I can interact with the Trello API to create new cards, add descriptions, and assign due dates.

import requests

# Trello API credentials
api_key = "your_api_key"
api_token = "your_api_token"
board_id = "your_board_id"
list_id = "your_list_id"

# Create a new card
def create_card(name, description, due_date):
    url = f"https://api.trello.com/1/cards"
    params = {
        "key": api_key,
        "token": api_token,
        "name": name,
        "desc": description,
        "idList": list_id,
        "due": due_date
    }
    response = requests.post(url, params=params)
    return response.json()

# Example usage
new_card = create_card("New Project", "This is a new project", "2024-09-20T14:00:00.000Z")
print(new_card)
Enter fullscreen mode Exit fullscreen mode

Step 2: Time Tracking Automation

Accurate time tracking is essential for invoicing clients and optimizing my workflow. I use the pyautogui library to automate time tracking by taking screenshots of my screen at regular intervals and saving them to a folder.

import pyautogui
import datetime
import os

# Set the screenshot interval (in seconds)
interval = 300

while True:
    # Take a screenshot
    screenshot = pyautogui.screenshot()

    # Save the screenshot to a folder
    now = datetime.datetime.now()
    folder = f"screenshots/{now.strftime('%Y-%m-%d')}"
    if not os.path.exists(folder):
        os.makedirs(folder)
    screenshot.save(f"{folder}/{now.strftime('%H-%M-%S')}.png")

    # Wait for the next interval
    time.sleep(interval)
Enter fullscreen mode Exit fullscreen mode

Step 3: Invoicing Automation

With automated time tracking, I can generate invoices quickly and accurately. I use the openpyxl library to create invoices in Excel format.

import openpyxl
from openpyxl.styles import Font

# Load the invoice template
wb = openpyxl.load_workbook("invoice_template.xlsx")
sheet = wb.active

# Set the client information
client_name = "John Doe"
client_email = "john.doe@example.com"

# Set the invoice information
invoice_number = "INV001"
invoice_date = "2024-09-20"
total_hours = 10
hourly_rate = 50
total_amount = total_hours * hourly_rate

# Fill in the invoice template
sheet["A1"] = client_name
sheet["A2"] = client_email
sheet["B1"] = invoice_number
sheet["B2"] = invoice_date
sheet["C1"] = total_hours
sheet["C2"] = hourly_rate
sheet["D1"] = total_amount

# Save the invoice
wb.save(f"invoices/{client_name}_{invoice_number}.xlsx")
Enter fullscreen mode Exit fullscreen mode

Monetization Angle

By automating my freelance workflow with Python, I've increased my productivity and reduced the time spent on administrative tasks. This has allowed me to take on more clients and projects, resulting in a significant increase in revenue. In fact, I've seen a 30% increase in earnings since implementing these automations.

Conclusion

Automating my freelance workflow with

Top comments (0)