Question: I'm looking for a spreadsheet assistant that can write formulas and create templates for me.

If you want a spreadsheet bot to write formulas and generate templates for you, SheetSavvy AI is a good choice. It can automate complicated tasks, generate formulas and link to many data sources to help you get more done with data analysis and collaboration. The AI assistant can generate templates and explain complex formulas using Natural Language Processing (NLP), and it has data connectors to automatically import live data from sources like CRM systems.

Another good option is Formula Bot. This service uses AI to convert text prompts into Excel formulas, SQL queries and other data manipulation tools, so you can get to your data faster. It's got an Excel Formula Generator, SQL Query Generator and a Data Analyzer, so you can build charts and tables without having to write any programming code. It also can automate spreadsheet chores like sentiment analysis and text classification, making data analysis easier and more accessible.

FormulaGenerator is another option. It uses fine-tuned GPT models to generate Excel formulas, VBA automations and SQL queries. The tool can generate formulas based on text prompts, find and fix errors, and explain how it arrived at its generated formulas. It's available as a web app and as a Google Sheets extension, with a free tier and a premium membership option for heavier use.

Last, ManyExcel offers an AI tool to generate formulas, regex patterns and scripts. It's got an AI Formula Generator, AI Regex Generator and an AI Script Generator for Excel and Google Workspace. The tool also offers a Data Analysis Tool to extract insights and generate interactive charts, and free and pro plans are available depending on your needs.