Python Script for Google Sheet to MySQL

Using this Google Sheet: [login to view URL] Need a python script that will run daily on an Ubuntu server which takes the items on the iPhone Used tab of this sheet and uploads them into 2 mysql database tables. The first table will be called item_prices with the following columns: model, capacity, carrier, swap, grade_a, grade_b, grade_c, grade_d, doa. Using this row as an example: iPhone 16 Pro Max 256GB Unlocked $925 $915 $895 $715 $335 $200 The data in each column would be as follows: model (char): iPhone 16 Pro Max capacity (char): 256GB carrier (char): Unlocked swap (smallint): 925 grade_a (smallint): 915 grade_b (smallint): 895 grade_c (smallint): 715 grade_d (smallint): 335 doa (smallint): 200 The second mysql table will be called item_deductions and will scrape the data at the top of each section. Here is the example for iPhone 16 Pro Max: Cracked Back = $180 off / Cracked Lens = $90 off / Bad Face ID = Parts / Bad Back Camera = ASK - - - HEAVY SCRATCHING / DEGRADED BATTERY % = EXTRA DEDUCTION or GRADE C If there is no set deduction then ignore that data piece. The data in each column from this example would be as follows: cracked_back (smallint): 180 cracked_lens (smallint): 90 Any deductions marked as 'ASK' or 'Parts' should be ignored. Include basic logging for successful uploads and failed attempts. Use Curl without auth if possible. API key if necessary for accessing the Google Sheet. Use the following error handling method: log errors. Exclude rows with missing or malformed data. Log information should be written to a simple text file. If a matching entry exists, the script should update the existing entry. If a matching entry exists, the script should update the existing entry with new data. The script should be triggered by a cron job. The script should be compatible with MySQL 8.0.