Validating profile... 0% complete

What is your current level of experience in freelance work?

 

 

Python Script for Google Sheets Data & Google Route Optimization

Project Title Python Script to Scrape Google Sheets & Optimize Delivery Routes Project Overview We need a robust, nightly Python script that: 1. Authenticates & Reads Connects to 10–20 Google Sheets via a service account (using gspread or equivalent). Handles credential setup, token refresh, and secure storage of service-account keys. 2. Applies Business Rules Processes each sheet’s rows (packages) to identify which are scheduled for delivery the next business day. Supports configurable filters (e.g. date fields, geographic regions, package types). 3. Calls Routing API Sends a batch request to a Google OptimizeToursRequest API endpoint (or similar proprietary routing service). Provides driver-vehicle availability and package manifests as input. Receives back optimize...