Integration _best_: Phantombuster Google Sheets

In your Phantom setup, paste the Google Sheet URL into the "Profiles to scrape" or "Search URLs" field.