Python script to validate URLs using Google Maps API

I would like to create a python script that does the following tasks

1- Upload a csv file including a long list of URLs (see input.csv for example)

2- Check each URL in the input list for the following conditions:
Condition 1- look for URL in Google Maps API, if match found go to condition #2
Condition 2- Check if business category in Google Maps API is an acceoted category (see script-categories.csv list attached for accepted category), if match found go to step 3

3- List all URLs that satisfy both conditions above in an output csv including the following fields

Column a = domain URL
Column b = list store category (from Google Maps API)
Column c = append sales@ before domain URL in column a
Column d = append info@ before domain URL in column a

See script-output.csv for example

Output file name needs to include date and time (ex: Output_Success_2022-02-10_14-20.csv)

4- List all invalid URLs in separate output csv including the following fields

Column a = domain URL
Column b = list store category (from Google Maps API)

Output file name needs to include date and time (ex: Output_Failed_2022-02-10_14-20.csv)

Thank you,
Dan