Excel-Claude Integration Script
Budget: ₹750 – ₹1,250 INR
I need a compact Python workflow that reads a list of company names from an Excel sheet, feeds each name to Claude AI through its API (no UI automation, please), receives only the strict-format JSON I define, then parses that JSON back into Excel—one row per individual contact discovered.
Key details you should know
• Preferred stack: Python 3.x with the requests library for all API calls. Feel free to add helpers such as pandas or openpyxl for spreadsheet handling.
• Multiple contacts: if Claude returns several people for the same company, the script must write a separate Excel row for every contact while repeating the parent company data.
• Reliability: build in graceful back-off delays so batches never trigger rate limits, plus simple error logging and a resume switch that can pick up from the last processed row.
• Data discipline: no copy-paste dumps. Every field—website, email, phone, title, etc.—must land in its own explicit column exactly as the JSON specifies.
• Ownership: I receive full, unrestricted rights to the final code.
Deliverables
• Fully commented .py script ready to run.
• A brief setup/usage guide outlining dependencies, environment variables for API keys, and how to restart a failed run.
When you reply, outline your planned approach (including any additional libraries or design patterns you’d leverage) so I know we’re on the same page.
Key details you should know
• Preferred stack: Python 3.x with the requests library for all API calls. Feel free to add helpers such as pandas or openpyxl for spreadsheet handling.
• Multiple contacts: if Claude returns several people for the same company, the script must write a separate Excel row for every contact while repeating the parent company data.
• Reliability: build in graceful back-off delays so batches never trigger rate limits, plus simple error logging and a resume switch that can pick up from the last processed row.
• Data discipline: no copy-paste dumps. Every field—website, email, phone, title, etc.—must land in its own explicit column exactly as the JSON specifies.
• Ownership: I receive full, unrestricted rights to the final code.
Deliverables
• Fully commented .py script ready to run.
• A brief setup/usage guide outlining dependencies, environment variables for API keys, and how to restart a failed run.
When you reply, outline your planned approach (including any additional libraries or design patterns you’d leverage) so I know we’re on the same page.