If you're looking for a tool that can convert your spreadsheet edits into Python code for automation, the Mito project could be just what you're looking for. Mito lets you generate Python code based on spreadsheet changes through an interface you're already used to. It automates repetitive work, including data transformation and pivot tables, and integrates with Jupyter, Streamlit and Dash environments. Mito has a variety of pricing options, from free for basic features to $149.99/month for premium features.
Another great option is Neptyne, which marries Python code with Google Sheets to handle a range of data processing and analysis tasks. Neptyne can import data from a variety of sources and integrate with Google Analytics. It has advanced data processing abilities like AI-assisted summarization and time series forecasting. It also can automate reports, emails and notifications, so it's a good option for anyone who wants to automate data-related tasks.
If you're looking for a more specialized tool to generate and automate Excel and Google Sheets tasks, ManyExcel has an AI tool that can generate formulas, regex patterns and scripts. Its AI Formula Generator, Regex Generator and Script Generator can help you automate tasks. The tool also has a Data Analysis Tool for extracting insights and creating interactive charts, and it has a free plan with limited use and a Pro plan for $5/month.