Neptyne is a powerful option that marries Python code with Google Sheets so you can do lots of data processing and analysis. It can import data from spreadsheets, CSV files, JSON, HTML tables and databases, and integrates with Google Analytics. Neptyne also has more advanced data processing abilities like summarization, refinement, AI model-based classification, anomaly detection, time series forecasting and Monte Carlo simulations. It also has visualization and automation abilities, making it a good option for practical uses like predicting stock quotes and forecasting weather.
Mito is another good option for automating repetitive spreadsheet tasks with Python. It can generate Python code automatically based on spreadsheet changes, which means data transformation, visualization and pivot tables are within reach without having to learn a lot of Python programming. Mito also works well with commonly used data science tools and offers interactive dashboards, so you can get work done faster with automation and AI-assisted code generation.